DATABRICKS-DEP Question 18

Question

A CDC feed contains operation codes `I`, `U`, and `D`. Which `MERGE` logic is required to correctly apply deletes into a Delta target?
A. Overwrite the target table on every batch
B. Add a `WHEN MATCHED AND op = 'D' THEN DELETE` clause
C. Ignore delete rows and rely on `VACUUM`
D. Union source rows to the target and run `DROP DUPLICATES`

Accepted Answer

Marked answer: B. Add a `WHEN MATCHED AND op = 'D' THEN DELETE` clause

DATABRICKS-DEP Question 18

Community Discussion

Preparing Practice Exam…

DATABRICKS-DEP Question 18

Community Discussion