Noos
PT EN
RAN-DBDEA-00122
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: medium

An online retailer's operational data lives in a MySQL database: product catalog, inventory, and orders. The analytics platform needs an initial copy of every table in Unity Catalog-governed tables, followed by continuous replication of inserts, updates, and row deletions as they happen, with no ingestion code for the data team to write or operate. Which approach meets these requirements?

Options (Reading Mode) Click to filter discussion →
  1. A. A Lakeflow Connect database connector: it takes an initial snapshot of each table and then streams ongoing changes, including deletes, into Unity Catalog-governed streaming tables
  2. B. A scheduled COPY INTO statement that reads the MySQL tables directly and appends their new rows into a Delta table every night
  3. C. A nightly Lakeflow Job that reads full table snapshots over JDBC and overwrites the target Delta tables with each night's copy
  4. D. A Lakeflow Connect Kafka connector pointed at the MySQL server, so row changes flow from the database into a streaming table
Reveal answer

Correct answer: A Lakeflow Connect database connector: it takes an initial snapshot of each table and then streams ongoing changes, including deletes, into Unity Catalog-governed streaming tables

Reference: https://docs.databricks.com/aws/en/ingestion/lakeflow-connect/

Train this exam on Ranvier →

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): A Lakeflow Connect database connector: it takes an initial snapshot of each table and then streams ongoing changes, including deletes, into Unity Catalog-governed streaming tables

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.