Noos
PT EN
RAN-DBDEA-00130
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: hard

A streaming table created with read_files over a landing directory has been live for weeks. A faulty transformation in the pipeline polluted its contents; the source files are still intact in cloud storage, and the transformation has now been fixed. The team decides to rebuild the table with a full refresh. Which statement describes what REFRESH TABLE ... FULL REFRESH does?

Options (Reading Mode) Click to filter discussion →
  1. A. It re-executes only the micro-batches whose output the faulty transformation affected, leaving every correctly loaded batch untouched in the table
  2. B. It discards the streaming state that tracks processed data and reprocesses everything from the source, fully re-deriving the table
  3. C. It drops and recreates the table schema before reloading, resetting column types and constraints to their original definitions
  4. D. It fires automatically whenever the source schema changes, so issuing it manually after fixing a transformation is redundant
Reveal answer

Correct answer: It discards the streaming state that tracks processed data and reprocesses everything from the source, fully re-deriving the table

Reference: https://docs.databricks.com/aws/en/ldp/concepts/streaming-tables

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 (B): It discards the streaming state that tracks processed data and reprocesses everything from the source, fully re-deriving the table

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.