What is considered a limitation when using the MERGE INTO command in Databricks?

Real Exam

Merge operations are not supported in streaming jobs without the use of Watermarking.

7.6%

Merge operations cannot delete records; they only support upsert operations.

8.4%

Merge operations cannot proceed if a single source row matches and attempts to modify multiple target rows in the table.

13.7%

Merge operations cannot proceed if multiple source rows match and attempt to modify the same target row in the table.

62.6%

All the above are considered limitations of the MERGE INTO command.

7.6%

Databricks Certified Data Engineer - Professional