Implementing Analytics Solutions Using Microsoft Fabric — Question 35

You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains an unpartitioned table named Table1.
You plan to copy data to Table1 and partition the table based on a date column in the source data.
You create a Copy activity to copy the data to Table1.
You need to specify the partition column in the Destination settings of the Copy activity.
What should you do first?

Answer options

• A. From the Destination tab, set Mode to Append.
• B. From the Destination tab, select the partition column.
• C. From the Source tab, select Enable partition discovery.
• D. From the Destination tabs, set Mode to Overwrite.

Correct answer: D

Explanation

The correct answer is D because setting the Mode to Overwrite in the Destination tab is necessary to allow the addition of partitioning to Table1. The other options do not initiate the correct configuration for partitioning in the Copy activity's Destination settings.