Noos
PT EN
RAN-DBDEA-00273
Ranvier · DBDEA

Exam DBDEA Topics: troubleshooting Difficulty: hard

A nightly aggregation shuffles about 6 GB of data. The plan submitted to the cluster ended with 200 post-shuffle partitions, yet the Spark UI shows the final stage ran only 12 tasks, each processing a reasonably sized slice — and nobody edited the query. Which mechanism changed the task count while the query was running?

Options (Reading Mode) Click to filter discussion →
  1. A. The driver, which locks the final task count when the plan is compiled and submitted for execution
  2. B. Adaptive Query Execution, which coalesces small post-shuffle partitions into fewer, larger tasks using runtime statistics
  3. C. A manual repartition transformation, which engineers are required to add to every job before Spark can merge its small shuffle partitions
  4. D. Photon, whose vectorized engine merges small partitions while it executes the stage's scans and aggregations
Reveal answer

Correct answer: Adaptive Query Execution, which coalesces small post-shuffle partitions into fewer, larger tasks using runtime statistics

Reference: https://docs.databricks.com/aws/en/optimizations/aqe

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): Adaptive Query Execution, which coalesces small post-shuffle partitions into fewer, larger tasks using runtime statistics

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