For a Copy data activity that replaces Table1 with the schema of external data and replaces all data, which option should you set?

For a Copy data activity that replaces Table1 with the schema of external data and replaces all data, which option should you set?

• A. Upsert
• B. Append
• C. Create new table
• D. Overwrite

Answer: (D)

When you want the destination to be exactly what the source provides, you control this with the sink’s write behavior. Overwrite clears the destination and then loads the new data, effectively replacing both the content and, if supported, the destination’s schema to match the source. This is why it’s the right choice for replacing Table1 with the external data’s schema and data. Upsert would update or insert rows based on keys, not remove everything. Append would add data without removing existing rows. Creating a new table doesn’t replace the existing one.

When you want the destination to be exactly what the source provides, you control this with the sink’s write behavior. Overwrite clears the destination and then loads the new data, effectively replacing both the content and, if supported, the destination’s schema to match the source. This is why it’s the right choice for replacing Table1 with the external data’s schema and data.

Upsert would update or insert rows based on keys, not remove everything. Append would add data without removing existing rows. Creating a new table doesn’t replace the existing one.