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

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