Noos
PT EN
RAN-DBDEA-00222
Ranvier · DBDEA

Exam DBDEA Topics: transformation Difficulty: hard

A silver pipeline must process only the rows that changed in a bronze Delta table since its last run — inserts, updates, and deletes alike — instead of rescanning the whole bronze table every night. Which mechanism provides the incremental change stream?

Options (Reading Mode) Click to filter discussion →
  1. A. Rescan the bronze table nightly and MERGE on the primary key, accepting the full read every time
  2. B. Read the bronze table as a streaming source, which surfaces updates and deletes as well as inserts
  3. C. Enable change data feed and read the changes with table_changes, which returns each change with its type
  4. D. Keep a hand-built control table of processed ids, refreshed by a nightly full scan
Reveal answer

Correct answer: Enable change data feed and read the changes with table_changes, which returns each change with its type

Reference: https://docs.databricks.com/aws/en/tables/features/change-data-feed

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): Enable change data feed and read the changes with table_changes, which returns each change with its type

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.