Noos
PT EN
RAN-DBDEA-00232
Ranvier · DBDEA

Exam DBDEA Topics: transformation Difficulty: easy

A nightly reprocessing job was accidentally deployed with this write and, on its first run, replaced an entire silver table with only a partial re-run's worth of data: ```python df.write.mode("overwrite").saveAsTable("catalog.sales.silver_payments") ``` The team now wants every reprocessing job to fail loudly instead of touching a table that already exists. Which save mode gives that behavior?

Options (Reading Mode) Click to filter discussion →
  1. A. append, which replaces the table's previous contents with each new batch that gets written
  2. B. overwrite, which refuses to write whenever the target table already contains any data at all
  3. C. No save mode is needed, because Delta treats the modes as advisory hints and always appends the incoming data atomically
  4. D. errorIfExists, the default save mode, which makes the write fail if the target table already exists
Reveal answer

Correct answer: errorIfExists, the default save mode, which makes the write fail if the target table already exists

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 (D): errorIfExists, the default save mode, which makes the write fail if the target table already exists

⚓ 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.