Noos
PT EN
RAN-DBDEA-00094
Ranvier · DBDEA

Exam DBDEA Topics: troubleshooting Difficulty: easy

A team is creating a new Delta table for order line items. Queries almost always filter on `order_date` and `customer_id`. The team's older tables use Hive-style partitioning on a date column plus nightly `OPTIMIZE ... ZORDER BY` jobs, and the team plans to copy that design. What does Databricks currently recommend for this new table?

Options (Reading Mode) Click to filter discussion →
  1. A. Liquid Clustering with order_date and customer_id as keys — incremental layout, no ZORDER jobs
  2. B. Hive-style partitioning on customer_id, because clustering keys must have low cardinality to be effective
  3. C. Hive-style partitioning on both order_date and customer_id, so every query prunes at least one partition directory
  4. D. No layout optimization at all: rely on Delta's file-level statistics, which are recomputed on every write
Reveal answer

Correct answer: Liquid Clustering with order_date and customer_id as keys — incremental layout, no ZORDER jobs

Reference: https://docs.databricks.com/aws/en/tables/clustering

02 — The Myelin Layer · Canonical Discussion

Where the exam tries to trick you — and how those who passed solved it.

0 Passed

contributed to this question

Answer Distractor Matrix Click an option to filter or open its dissection.
✦ Consolidated Synthesis (Wiki) rev. #1 (baseline) · CC BY-SA 4.0
Start synthesis for this question →

No community synthesis consolidated for this question yet. Below is the verifiable official starting point — if you passed the exam, open the option dissection.

Official Answer (A): Liquid Clustering with order_date and customer_id as keys — incremental layout, no ZORDER jobs

⚓ Official Documentation Anchor: https://docs.databricks.com/aws/en/tables/clustering
Ranvier · DBDEA

Contribute to this Question

Your contribution builds your Orbital Sheath

Peer contributions

No public contribution yet. Be the first who passed to explain why the distractors trick candidates — your contribution builds your Orbital Sheath.