Noos
PT EN
RAN-DBDEA-00123
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: medium

A team defines a streaming table in a Lakeflow Declarative Pipeline using the read_files table-valued function over a landing directory, and the table's refresh schedule runs every 15 minutes. Files land in that directory around the clock. A new engineer assumes each refresh re-reads the entire directory and worries about duplicate rows. What does each scheduled refresh actually process?

Options (Reading Mode) Click to filter discussion →
  1. A. Only the files that have arrived since the last successful refresh, because the streaming table keeps durable state tracking what it has already ingested
  2. B. Every file in the directory, with duplicate rows removed afterwards by a deduplication step that the pipeline runs automatically
  3. C. Nothing, until an external scheduler updates a control table listing which files the previous refresh already consumed
  4. D. Only new files if the table was declared with AUTO CDC INTO; streaming tables fed by read_files always reload in full
Reveal answer

Correct answer: Only the files that have arrived since the last successful refresh, because the streaming table keeps durable state tracking what it has already ingested

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 (A): Only the files that have arrived since the last successful refresh, because the streaming table keeps durable state tracking what it has already ingested

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.