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

Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?
A . DROP
B . IGNORE
C . MERGE
D . APPEND
E . INSERT

View Answer

Answer: C

Explanation:

The MERGE command can be used to upsert data from a source table, view, or DataFrame into a target Delta table. It allows you to specify conditions for matching and updating existing records, and inserting new records when no match is found. This way, you can avoid writing duplicate records into a Delta table1. The other commands (DROP, IGNORE, APPEND, INSERT) do not have this functionality and may result in duplicate records or data loss234.

Reference: 1: Upsert into a Delta Lake table using merge | Databricks on AWS 2: SQL DELETE | Databricks on AWS 3: SQL INSERT INTO | Databricks on AWS 4: SQL UPDATE | Databricks on AWS