Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Databricks Certified Data Engineer Associate · Databricks
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
UPSERT can be INSERT, UPDATE, and/or DELETE MERGE INTO TargetTable AS target USING SourceTable AS source ON target.ID = source.ID WHEN MATCHED THEN UPDATE SET target.Name = source.Name WHEN NOT MATCHED BY TARGET THEN INSERT (ID, Name) VALUES (source.ID, source.Name) WHEN NOT MATCHED BY SOURCE THEN DELETE;
The response is C
C. MERGE The MERGE command allows you to perform upserts (update and insert) into a Delta table, effectively avoiding duplicates by updating existing records and inserting new ones as needed.