How Do You Set a Partition Column in a Fabric Copy Activity?

Get data

Answer Correct answer: D — Set the Destination tab Mode (Table action) to Overwrite on Table1 first, which makes the Enable partition and partition column options available.

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?

From the Destination tab, set Mode to Append.
From the Destination tab, select the partition column.
From the Source tab, select Enable partition discovery.
From the Destination tabs, set Mode to Overwrite. Correct Answer

fabric copy activity partition column lakehouse table partitioning dp-600 copy activity overwrite enable partition fabric lakehouse

Community Votes

100%

100% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

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.

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.

Community Discussion (15 comments)

SamuComqi 👍 15 Selected: D

D. 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 Selected: D

D. 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.

emboutchamani 👍 1 Selected: A

What should you do first ? Before setting partition you have to set mode toappend after you can select partition column

Rakesh16 👍 1 Selected: D

From the Destination tabs, set Mode to Overwrite.

Brainny 👍 1

C. 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

Pegooli 👍 1 Selected: C

Enabling 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.

dev2dev 👍 1 Selected: D

those who still think B is the answer, emphasis on "What should you do first?"

Data_Works 👍 1 Selected: D

D. 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.

282b85d 👍 3 Selected: C

Enable 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.

David_Webb 👍 1 Selected: D

Partition option need to switch to Overwrite mode first.

stilferx 👍 4 Selected: D

IMHO, 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

emmanuelkech 👍 3 Selected: B

From the Destination tab, select the partition column. This ensures that the data is partitioned based on the specified column in the destination table

estrelle2008 👍 6 Selected: D

A 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?

lengzhai 👍 4 Selected: D

D is correct. Partition is available when Overwrite is checked

Momoanwar 👍 3 Selected: C

I think its C. For partition in pipeline we have to specify column in source

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

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

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?

Append only inserts rows into the existing unpartitioned Table1, so the Enable partition option stays hidden. Fabric lets you define partition columns only when Overwrite re-creates the Delta table with that partition scheme.

Is Enable partition discovery on the Source tab the same as destination partitioning?

No. Source partition discovery reads partition folders from the source files, while destination partitioning for Table1 is configured on the Destination tab under Advanced, after Table action is set to Overwrite.

Related Analysis

Practice All DP-600 Questions

Access 115 questions with complete answers and detailed explanations.

View Full DP-600 Practice Test →

← Back to DP-600 Study Guide