Noos
PT EN
RAN-DBDEA-00141
Ranvier · DBDEA

Exam DBDEA Topics: transformation Difficulty: hard

An operational database streams its change feed into a bronze table: each row carries the operation (insert, update, delete), a monotonically increasing sequence number, and the changed columns. In a Lakeflow Declarative Pipeline, the team must keep a streaming table in sync with the current source state — deletes included — without writing manual merge logic. Which construct should the pipeline declare?

Options (Reading Mode) Click to filter discussion →
  1. A. A hand-written MERGE INTO statement that joins the change rows to the target on the primary key
  2. B. An AUTO CDC INTO flow with KEYS and SEQUENCE BY, replacing the former APPLY CHANGES syntax
  3. C. A row-level expectation that drops invalid change rows as they flow into the target table
  4. D. A full refresh that recreates the streaming table from scratch whenever a new batch arrives
Reveal answer

Correct answer: An AUTO CDC INTO flow with KEYS and SEQUENCE BY, replacing the former APPLY CHANGES syntax

Reference: https://docs.databricks.com/aws/en/ldp/cdc

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): An AUTO CDC INTO flow with KEYS and SEQUENCE BY, replacing the former APPLY CHANGES syntax

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