APICS Certified Supply Chain Professional (CSCP) — Question 342

In which of the following scenarios should a data engineer use the MERGE INTO command instead of the INSERT INTO command?

Answer options

• A. When the location of the data needs to be changed
• B. When the target table is an external table
• C. When the source table can be deleted
• D. When the target table cannot contain duplicate records
• E. When the source is not a Delta table

Correct answer: D

Explanation

The MERGE INTO command is ideal for scenarios where the target table must maintain unique records, as it allows for conditional updates or inserts based on existing data. Options A, B, C, and E do not specifically address the need for preventing duplicates, making D the only correct choice in this context.