Noos
PT EN
RAN-DBDEA-00131
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: medium

A scheduled Lakeflow Job runs this statement every night to load the day's files into a reporting table: ```sql COPY INTO main.ops.deliveries_raw FROM '/Volumes/main/ops/landing/deliveries/' FILEFORMAT = CSV; ``` Last night the run failed halfway through, when it hit a corrupted file after several valid files had already been read. What is the state of the target table this morning?

Options (Reading Mode) Click to filter discussion →
  1. A. Unchanged: COPY INTO is atomic, no partial data was committed, and a rerun after the fix loads all still-pending files
  2. B. Partially loaded: the valid files read before the corruption were committed, and a rerun resumes from the file after the corrupted one
  3. C. Empty: the failed statement rolled the table back to its creation state, and the next successful run reloads everything from scratch
  4. D. Locked: the failed run marked every listed file as loaded, so the team must purge the copy history before it can retry
Reveal answer

Correct answer: Unchanged: COPY INTO is atomic, no partial data was committed, and a rerun after the fix loads all still-pending files

Reference: https://docs.databricks.com/aws/en/ingestion/copy-into

Train this exam on Ranvier →

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): Unchanged: COPY INTO is atomic, no partial data was committed, and a rerun after the fix loads all still-pending files

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