🔥 3-day streak
Databricks Certified Data Engineer Associate52 / 150
Question 52 of 150
A data engineer maintains a Silver Delta table 'customers' that must be fully synchronized with a daily full snapshot loaded into a staging view 'stg_customers'. The requirement is: insert new customers, update changed customers, and delete customers that no longer exist in the daily snapshot. Which single MERGE statement clause correctly handles the deletion of records that are present in the target but absent from the source?
Reviewed for accuracy · Report an issueNext question