DatabricksDatabricks
DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #78
DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Question #78: Real Exam Question with Answer & Explanation
Sign in or unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to reveal the answer and full explanation for question #78. The question stem and answer options stay visible for context.
Submitted by khalil_dz· Apr 18, 2026ELT with Spark SQL and Python
Question
In which of the following scenarios should a data engineer use the MERGE INTO command instead of the INSERT INTO command?
Options
- AWhen the location of the data needs to be changed
- BWhen the target table is an external table
- CWhen the source table can be deleted
- DWhen the target table cannot contain duplicate records
- EWhen the source is not a Delta table
Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to see the answer
You've previewed enough free DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE questions. Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#MERGE INTO#INSERT INTO#Delta Lake#UPSERT