DATABRICKS-DEP Question 69

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose C0

  - Correct answer : C — Recreate the table with `CLUSTER BY (customer_id)` so the file layout is maintained incrementally as the skewed data grows. A . Adding a second Z-ORDER column does not solve the underlying cost problem, since a Z-ORDER `OPTIMIZE` still rewrites the full set of touched files on every run regardless of how many columns are listed. B . Partitioning by a high-cardinality, skewed column like `customer_id` creates an excessive number of small partitions, which drives up file-listing overhead and small-file problems instead of fixing the rewrite cost. C . Liquid clustering with `customer_id` declared as a key incrementally maintains the layout as new data arrives, avoiding the full-table rewrite cost that a growing skewed table incurs under Z-ORDER. D . Given how heavily queries filter on `customer_id`, automatic clustering would likely select that same column as a key rather than avoid it, so this does not describe expected behavior.