Noos
PT EN
RAN-DBDEA-00138
Ranvier · DBDEA

Exam DBDEA Topics: transformation Difficulty: medium

An auditor must verify catalog.finance.ledger as it stood 20 days ago. The team runs the time travel query for that snapshot, but it fails with a FILE_NOT_FOUND exception pointing at a data file. The table is vacuumed weekly with the default retention settings, and OPTIMIZE also runs regularly. What is the most likely cause of the failure?

Options (Reading Mode) Click to filter discussion →
  1. A. Time travel preserves every version since table creation, so the failure must come from missing SELECT privileges
  2. B. VACUUM only compacts small files into larger ones and never deletes any file from storage
  3. C. VACUUM removed data files older than the default 7-day retention, making older snapshots unreadable
  4. D. RESTORE TABLE can recover any prior version even after VACUUM has removed the underlying files
Reveal answer

Correct answer: VACUUM removed data files older than the default 7-day retention, making older snapshots unreadable

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 (C): VACUUM removed data files older than the default 7-day retention, making older snapshots unreadable

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