You plan to copy data to an unpartitioned Table1 and partition by a date column. What should you configure first in the Copy activity's Destination settings?

You plan to copy data to an unpartitioned Table1 and partition by a date column. What should you configure first in the Copy activity's Destination settings?

• A. Create a new dataset
• B. Set the batch size
• C. Configure the integration runtime
• D. From Destination tabs, set Mode to Overwrite

Answer: (D)

Write mode in the Destination settings is what controls how the sink handles existing data when you copy new rows. If you’re planning to partition by a date column, you want the incoming data to define the target storage cleanly and avoid mixing old data with the new partitions. Setting the destination to Overwrite ensures the copy operation replaces the existing data for the target, effectively aligning the data with the new partition structure as the data is written. Other options don’t address how data is written into the sink. Creating a new dataset is about mapping, batch size affects throughput, and configuring the integration runtime deals with compute resources. None of those change how existing data is treated in the destination or support partitioned writes in the way Overwrite does.

Write mode in the Destination settings is what controls how the sink handles existing data when you copy new rows. If you’re planning to partition by a date column, you want the incoming data to define the target storage cleanly and avoid mixing old data with the new partitions. Setting the destination to Overwrite ensures the copy operation replaces the existing data for the target, effectively aligning the data with the new partition structure as the data is written.

Other options don’t address how data is written into the sink. Creating a new dataset is about mapping, batch size affects throughput, and configuring the integration runtime deals with compute resources. None of those change how existing data is treated in the destination or support partitioned writes in the way Overwrite does.