Databricks Certified Data Engineer Associate — Question 14

Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?

Answer options

• A. DROP
• B. IGNORE
• C. MERGE
• D. APPEND
• E. INSERT

Correct answer: C

Explanation

The MERGE command is specifically designed to combine data from a source into a target Delta table while ensuring that duplicates are managed according to specified conditions. The other options, such as DROP, IGNORE, APPEND, and INSERT, do not inherently provide mechanisms to handle duplicates and may result in redundant records being added to the table.