Answer-first summary for fast verification
Answer: MERGE INTO
The `MERGE INTO` command is recommended because it allows for the merging of a set of updates, insertions, and deletions from a source table into a target Delta table. This approach effectively prevents the insertion of duplicate records when writing into Delta tables. For more information, refer to the Databricks documentation on [MERGE INTO](https://docs.databricks.com/sql/language-manual/delta-merge-into.html) and [data deduplication](https://docs.databricks.com/delta/merge.html#data-deduplication-when-writing-into-delta-tables).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A junior data engineer typically uses the INSERT INTO command to write data into a Delta table. A senior data engineer recommends a different command to prevent the insertion of duplicate records. Which command does the senior data engineer suggest?
A
APPLY CHANGES INTO
B
MERGE INTO
C
COPY INTO
D
UPDATE
E
INSERT OR OVERWRITE