Noos
PT EN
RAN-DBDEA-00015
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: medium

An Auto Loader stream that feeds a Unity Catalog-governed Delta table failed in the middle of the night after processing part of the incoming file batch. In the morning, the on-call engineer restarts the stream from the same notebook, pointing at the same input directory, checkpoint location, and target table. What does Auto Loader guarantee after the restart?

Options (Reading Mode) Click to filter discussion →
  1. A. It resumes where it left off: files already recorded in checkpoint state are not reprocessed, preserving exactly-once semantics
  2. B. It starts over and re-ingests every file in the input directory, so the on-call engineer must schedule a deduplication job after every recovery
  3. C. It skips the partially processed files and leaves a gap that must be backfilled manually before the next run
  4. D. It truncates the target Delta table and reloads all files so the table returns to a consistent state
Reveal answer

Correct answer: It resumes where it left off: files already recorded in checkpoint state are not reprocessed, preserving exactly-once semantics

Reference: https://docs.databricks.com/aws/en/ingestion/cloud-object-storage/auto-loader/

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): It resumes where it left off: files already recorded in checkpoint state are not reprocessed, preserving exactly-once semantics

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.