Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
Which command can be used to write data into a Delta table while avoiding the writing of duplicate records?
Real Exam
Community
KKeng
0
A
DROP
B
INSERT
C
MERGE
D
APPEND
Explanation:
The MERGE command (also known as UPSERT) is specifically designed to write data into a Delta table while avoiding duplicate records. It performs the following operations:
- WHEN MATCHED: Updates existing records when a match is found
- WHEN NOT MATCHED: Inserts new records when no match is found
This allows you to:
- Update existing records with new values
- Insert new records that don't already exist
- Skip or handle duplicates based on specified conditions
Other options:
- DROP: Deletes a table entirely
- INSERT: Simply inserts data without checking for duplicates
- APPEND: Appends data to a table without checking for duplicates
The MERGE command is essential for maintaining data integrity and preventing duplicate records in Delta tables.
Comments
Loading comments...