When should a data engineer choose the `MERGE INTO` command over the `INSERT INTO` command?

Exam-Like

A

When the location of the data needs to be changed

2.8%

B

When the target table is an external table

3.6%

C

When the source table can be deleted

1.6%

D

When the target table cannot contain duplicate records

88.7%

E

When the source is not a Delta table

3.2%

Powered ByGPT-5.2

Databricks Certified Data Engineer - Associate