DATABRICKS-SPARK Question 46

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A0

  - MERGE INTO is the SQL standard upsert supported by Delta Lake. Combines source and target, updates matched rows, inserts unmatched, optionally deletes. UPSERT, REPLACE INTO, INSERT OR UPDATE are not Spark SQL keywords.