In a Copy Data activity, which Destination setting ensures the destination table is replaced with the source data?

In a Copy Data activity, which Destination setting ensures the destination table is replaced with the source data?

• A. Append
• B. Update
• C. Overwrite
• D. Upsert

Answer: (C)

Overwrite means replacing the destination with the source data. In this mode, the destination table is cleared (often truncated or dropped and recreated) and then the data from the source is loaded, so the final contents match the source exactly. This is why it’s the correct choice when you want a full replacement rather than preserving existing rows. Append would keep existing data and add the new rows, so it doesn’t replace. Update would modify existing rows in place based on keys, not replace all data. Upsert would insert new rows and update existing ones, again not a full replacement.

Overwrite means replacing the destination with the source data. In this mode, the destination table is cleared (often truncated or dropped and recreated) and then the data from the source is loaded, so the final contents match the source exactly. This is why it’s the correct choice when you want a full replacement rather than preserving existing rows.

Append would keep existing data and add the new rows, so it doesn’t replace. Update would modify existing rows in place based on keys, not replace all data. Upsert would insert new rows and update existing ones, again not a full replacement.