Answer: MERGE

The MERGE command in Delta Lake is designed to upsert data into a Delta table. It updates existing records or inserts new ones based on specified match criteria, effectively preventing duplicates. This command is crucial for scenarios involving updates to existing records or the addition of new records, ensuring the Delta table remains duplicate-free with the latest data.

Author: LeetQuiz Editorial Team