Noos
PT EN
RAN-DBDEA-00139
Ranvier · DBDEA

Exam DBDEA Topics: transformation Difficulty: medium

A streaming pipeline commits new data to catalog.ops.events every 30 seconds. After a few months, the Delta table holds hundreds of thousands of small files, and dashboard queries have degraded: execution time is dominated by listing and opening files rather than scanning data. Which maintenance action restores read performance?

Options (Reading Mode) Click to filter discussion →
  1. A. Run VACUUM with the default retention settings, so that small files are merged into larger ones
  2. B. Run OPTIMIZE, which compacts the small files into larger ones for more efficient reads
  3. C. Rewrite the entire table every night with repartition(1) to produce one giant file
  4. D. Scale up the compute behind the dashboards while leaving the file layout untouched
Reveal answer

Correct answer: Run OPTIMIZE, which compacts the small files into larger ones for more efficient reads

Reference: https://docs.databricks.com/aws/en/delta/best-practices

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 (B): Run OPTIMIZE, which compacts the small files into larger ones for more efficient reads

⚓ Official Documentation Anchor: https://docs.databricks.com/aws/en/delta/best-practices
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.