Noos
PT EN
RAN-DBDEA-00278
Ranvier · DBDEA

Exam DBDEA Topics: troubleshooting Difficulty: hard

A complex batch ETL join stage spills over 40 GB of shuffle data to local disk on every nightly run. The query cannot be redesigned this quarter, so the team wants a compute-level change that reduces the spill without touching the code. Which change follows the documented guidance?

Options (Reading Mode) Click to filter discussion →
  1. A. Treat the spill as harmless log noise, because writing shuffle data to disk never slows a stage down
  2. B. Reduce the memory per executor, which forces Spark to launch more tasks and split the shuffle data among them
  3. C. Disable Adaptive Query Execution, which removes partition coalescing and with it all spill from the stage
  4. D. Use instances with more memory, or fewer and larger workers, so more of the shuffle fits before spilling
Reveal answer

Correct answer: Use instances with more memory, or fewer and larger workers, so more of the shuffle fits before spilling

Reference: https://docs.databricks.com/aws/en/optimizations/spark-ui-guide/

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 (D): Use instances with more memory, or fewer and larger workers, so more of the shuffle fits before spilling

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.