A CDC feed contains operation codes `I`, `U`, and ...

Databricks Data Engineer Professional Practice Questions - Databricks Certified Data Engineer Professional Exam

Question Number 5

A CDC feed contains operation codes `I`, `U`, and `D`. Which `MERGE` logic is required to correctly apply deletes into a Delta target?

Overwrite the target table on every batch Add a `WHEN MATCHED AND op = 'D' THEN DELETE` clause Ignore delete rows and rely on `VACUUM` Union source rows to the target and run `DROP DUPLICATES`

✔ Correct Answer:

Add a `WHEN MATCHED AND op = 'D' THEN DELETE` clause

Databricks Data Engineer Professional Practice Questions - Databricks Certified Data Engineer Professional Exam

Question Number 5

Count Down:

Related questions :