How Do You Set a Partition Column in a Fabric Copy Activity?
Short answer
D Set the Destination tab Mode (Table action) to Overwrite on Table1 first, which makes the Enable partition and partition column options available.
Question
Key Takeaways
The question tests the ordering constraint inside the Copy activity's Destination tab: destination partitioning is hidden until you set the table action to Overwrite, and the classic trap is jumping straight to the partition column (B) or enabling partition discovery on the source (C).
In a Fabric Data Factory Copy activity, a destination lakehouse table can only be partitioned by a source column after the table action is switched to Overwrite. This page confirms that setting Mode to Overwrite (D) is the required first step before the partition column can be selected for Table1.
Common mistake: The most tempting wrong answer is B, selecting the partition column from the Destination tab; that is actually the step that comes after Overwrite, and the Enable partition setting is not even visible while Mode is still Append.
Expert Analysis
Why the Answer Is Correct
In Microsoft Fabric Data Factory, destination partitioning for a lakehouse table is only exposed when the table action is set to Overwrite. Table1 is currently unpartitioned, and changing its physical partition scheme means the Delta table must be re-created with the partition definition, which is precisely what Overwrite does. The documented sequence is: expand Advanced on the Destination tab, set Table action to Overwrite, select Enable partition, then Add column and pick the date column. Because the option to choose a partition column does not exist until Overwrite is selected, the first action among the four choices is setting Mode to Overwrite (D). Only after that does the Destination tab expose the partition configuration the question describes.
Why the Other Options Are Wrong
Option A (Mode = Append) cannot be right: Append only inserts rows into the existing unpartitioned Table1, so the Enable partition toggle remains hidden and any pre-existing data stays unpartitioned, as estrelle2008 observed that Append "leaves data that is already in table1 unpartitioned." Option B is the step being asked about rather than the step before it — choosing the partition column is exactly what you do after enabling partitioning, and estrelle2008 labeled it "the statement that you are asked to decide for the step before that." Option C (Enable partition discovery on the Source tab) is a source-side file/folder partition discovery feature and does not create destination Delta partition columns for Table1, so it fails the destination requirement in the question. That leaves D as the only action that unlocks the required Destination settings.
Community Comment Notes
Community consensus is unusually strong here: SamuComqi (15 likes) states that you "need to choose the Overwrite mode to make the partition option appear (not visibile in Append mode)." VAzureD and stilferx both quote the same Microsoft tutorial, spelling out the sequence — "in Table action, select Overwrite, and then select Enable partition, under Partition columns, select Add column." lengzhai reinforces that "Partition is available when Overwrite is checked." A small minority (282b85d, Momoanwar) argued for C on partition discovery, but that mixes the source-side discovery option with the Destination tab requirement the question explicitly asks about.
Official Reference
https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-lakehouse-partition
This link opens the official vendor documentation in a new tab.
Exam Strategy
When a DP-600 question asks what to do first in a Copy activity, mentally walk the Destination tab top-down: Table action first, then Enable partition, then Add column. Read the tiny ordering words ("first", "before", "then") — they usually decide between two options that are both real features.
Frequently Asked Questions
Why can't I pick the partition column while the Destination Mode is set to Append?
Is Enable partition discovery on the Source tab the same as destination partitioning?
Community Votes
100% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 15 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 15
-
SamuComqi 👍 15 Answered DD. From the Destination tabs, set Mode to Overwrite. When setting up the Copy Activity, you need to choose the Overwrite mode to make the partition option appear (not visibile in Append mode).
-
VAzureD 👍 7 Answered DD. From the Destination tabs, set Mode to Overwrite. https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-lakehouse-partition#load-data-to-lakehouse-using-partition-columns Expand Advanced, in Table action, select Overwrite, and then select Enable partition, under Partition columns, select Add column, and choose the column you want to use as the partition column. You can choose to use a single column or multiple columns as the partition column.
-
estrelle2008 👍 6 Answered DA makes no sense, it leaves data that is already in table1 unpartitioned B makes no sense, it is the statement that you are asked to decide for the step before that. C MIGHT assign date column in source data as requested partition column, but only and if source data is complete and unambiguous D re-creates table1, ensuring that the partitioning is applied consistently. Hoping that the data that is already in table1 is also in this source data, D should be recommended answer, I guess?
-
stilferx 👍 4 Answered DIMHO, the answer is "D". Because: Expand Advanced, in Table action, select Overwrite, and then select Enable partition, under Partition columns, select Add column, and choose the column you want to use as the partition column. You can choose to use a single column or multiple columns as the partition column. in https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-lakehouse-partition#load-data-to-lakehouse-using-partition-columns
-
lengzhai 👍 4 Answered DD is correct. Partition is available when Overwrite is checked
Show 10 more comments
-
282b85d 👍 3 Answered CEnable Partition Discovery: This option ensures that the Copy activity can identify the partition column and apply it correctly to the destination table. By enabling partition discovery, you make sure that the source data's partitioning information is considered during the copy process. Why Not: A. From the Destination tab, set Mode to Append: This setting controls how data is added to the existing table (whether new data is appended or existing data is overwritten). It does not directly address partitioning setup. B. From the Destination tab, select the partition column: While this is necessary to specify the partition column, it is logically the next step after enabling partition discovery. The system needs to recognize partitions before you can configure them. D. From the Destination tabs, set Mode to Overwrite: Similar to the Append mode, this setting determines how data is handled during the copy process but does not enable partitioning.
-
emmanuelkech 👍 3 Answered BFrom the Destination tab, select the partition column. This ensures that the data is partitioned based on the specified column in the destination table
-
Momoanwar 👍 3 Answered CI think its C. For partition in pipeline we have to specify column in source
-
Data_Works 👍 1 Answered DD. From the Destination tabs, set Mode to Overwrite. in the question, it is specified that "we are going to specify the partition column". Yes, we will do that, BUT before that we have to set the "Table action" option to "Overwrite". say, if you first set the partition column & after that you select the "overwrite" mode, then the selected partition column will be cleared & you will have to select that again. And "overwrite" is necessary because the table is not currently partitioned. we need to re-write the existing data leveraging partition.
-
Pegooli 👍 1 Answered CEnabling partition discovery on the Source tab allows the Copy activity to recognize the partition structure of the incoming data. This step is essential because it ensures that the data is copied into the destination table (Table1) with the correct partitions based on the specified date column.
-
Brainny 👍 1C. The "first" thing to do is to Enable Partition Discovery from the Source tab, this will enable the destination tab identify the partition column, then the destination tab can be set to overwrite. https://learn.microsoft.com/en-us/fabric/data-factory/connector-lakehouse-copy-activity
-
emboutchamani 👍 1 Answered AWhat should you do first ? Before setting partition you have to set mode toappend after you can select partition column
-
dev2dev 👍 1 Answered Dthose who still think B is the answer, emphasis on "What should you do first?"
-
David_Webb 👍 1 Answered DPartition option need to switch to Overwrite mode first.
-
Rakesh16 👍 1 Answered DFrom the Destination tabs, set Mode to Overwrite.
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.
Related Analysis
Practice All DP-600 Questions
Access 115 questions with complete answers and detailed explanations.
View Full DP-600 Practice Test →