Answer: MERGE

The MERGE command in Delta Lake is designed for upsert operations, allowing you to either update existing records or insert new ones based on specific match criteria. This functionality is crucial for preventing duplicate entries in your Delta table. By utilizing MERGE, you can define conditions that determine whether to update matching rows or insert new ones, ensuring your data remains accurate and duplicate-free during updates.

Author: LeetQuiz Editorial Team