Consider a scenario where you need to upsert batch data into a Delta Lake. The data includes customer profiles that are updated frequently. How would you structure your upsert operation to ensure data consistency and minimize performance impact?

Simulated

Use a MERGE statement with a unique identifier in the Delta Lake to perform the upsert operation.

100.0%

Delete the existing data and insert the new data each time to ensure consistency.

0.0%

Perform the upsert operation using a Python script that checks for duplicates before inserting.

0.0%

Manually compare the new data with the existing data in the Delta Lake and update records one by one.

0.0%

Microsoft Azure Data Engineer Associate - DP-203