Fabric Copy Activity Partitioning Prerequisites

DP-600 By islever Editorial Last updated

Get data

Short answer

D Set the Mode to Overwrite in the Destination tab to enable partition column selection.

Question

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?
  1. From the Destination tab, set Mode to Append.
  2. From the Destination tab, select the partition column.
  3. From the Source tab, select Enable partition discovery.
  4. From the Destination tabs, set Mode to Overwrite. Correct Answer

Key Takeaways

The exam tests the specific dependency between the Table Action (Overwrite) and the visibility of the Partition Columns configuration in the Destination tab.

In Microsoft Fabric, configuring partition columns in a Copy activity requires the table action to be set to Overwrite. This question establishes that Overwrite mode is the mandatory prerequisite for accessing partition settings.

Common mistake: Many learners choose Append because they associate partitioning with incremental data loads, but Fabric's Copy activity only exposes partition options when Overwrite is selected.

Expert Analysis

Why the Answer Is Correct

To specify a partition column in the Destination settings of a Copy activity in Microsoft Fabric, you must first set the Table action to Overwrite. According to official documentation, the 'Enable partition' option and the ability to select partition columns are only available under Advanced settings when Overwrite is chosen. This ensures the entire dataset is re-partitioned consistently.

Why the Other Options Are Wrong

Append mode does not expose partition column selection in the UI; it simply adds data without restructuring existing partitions in the same way. Selecting the partition column directly is impossible until the correct mode (Overwrite) is active. Enable partition discovery is a source-side feature for detecting folder structures, not a prerequisite for defining destination partition columns in this context.

Community Comment Notes

Community consensus strongly favors D, with users noting that the partition option remains hidden or disabled unless Overwrite is selected. One user clarified that while Append is common for partitions in other tools, Fabric's implementation here specifically requires Overwrite to apply the partition structure during the copy.

Official Reference

https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-lakehouse-partition#load-data-to-lakehouse-using-partition-columns

This link opens the official vendor documentation in a new tab.

Exam Strategy

Always verify if the tool requires a specific mode (like Overwrite vs. Append) to unlock advanced features like partitioning. In Fabric Data Factory, assume Overwrite is needed for complex schema or partition modifications unless stated otherwise.

Frequently Asked Questions

Why can't I use Append mode for partitioning?

In Microsoft Fabric Copy activities, partition column configuration is only exposed when the Table action is set to Overwrite.

Is partition discovery needed for Lakehouse tables?

Partition discovery helps identify source folder structures, but it is not the primary step for defining destination partition columns.

More DP-600 FAQ →

Discussion 28 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 28

  1. SamuComqi 👍 15 Answered 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).
  2. VAzureD 👍 7 Answered 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.
  3. estrelle2008 👍 6 Answered 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?
  4. stilferx 👍 4 Answered 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
  5. Pegooli 👍 4 Answered A
    In Microsoft Fabric, partitioning a table during a Copy activity is only supported in "Append" mode, not "Overwrite" mode.
Show 23 more comments
  1. lengzhai 👍 4 Answered D
    D is correct. Partition is available when Overwrite is checked
  2. 282b85d 👍 3 Answered 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.
  3. emmanuelkech 👍 3 Answered 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
  4. Momoanwar 👍 3 Answered C
    I think its C. For partition in pipeline we have to specify column in source
  5. praticewizards 👍 2 Answered A
    To partition data in a destination table, you need to ensure that new data is appended. Setting the mode to "Append" is the first step because: Partitioning requires Append mode. Overwrite mode would replace the entire table, negating any partitioning structure you aim to achieve. Once Append mode is set, you can specify the partition column in the Destination settings. Why not the other options? B. From the Destination tab, select the partition column: You cannot select the partition column until the mode is set to Append first. C. From the Source tab, select Enable partition discovery: This option is useful for discovering partitions in source data, but it is unrelated to configuring partitioning in the destination table. D. From the Destination tab, set Mode to Overwrite: Overwrite mode deletes existing data in the table, which contradicts the goal of appending and partitioning the data.
  6. dee2593 👍 1 Answered A
    In Fabric Data Pipeline’s Copy activity, when you load data into a Delta table (like your Lakehouse table), partitioning settings for the destination are only available in Append mode. If the mode is Overwrite, partition settings won’t appear because the table would be fully replaced. Once you set Mode = Append, you’ll see the option to specify a partition column in the Destination tab. Why not the others? B. From the Destination tab, select the partition column → You can’t select it until you switch to Append mode. C. From the Source tab, select Enable partition discovery → That’s for reading partitioned data from the source, not for writing with partitioning in the destination.
  7. Data_Works 👍 1 Answered 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.
  8. evest 👍 1 Answered A
    In the info i next to Enable partitions is said "Create partitions in folder structure based on one or multiple columns. Each distinct column value (pair) will be a new partition (e.g. year=2000/month=01/file). It supports insert-only mode and requires an empty directory in sink." In this case there is a Table1 and it is not mentioned that it is empty. But we want a working solution that is why Append seams to be more certain answer.
  9. Pegooli 👍 1 Answered 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.
  10. 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
  11. a2675f7 👍 1
    only when the source table is partitioned first... Enable partition discovery: For files that are partitioned, specify whether to parse the partitions from the file path and add them as extra source columns, in this case source is unpartitioned
  12. ViniciusPA 👍 1 Answered A
    Quando o modo está como Sobrescrever, o particionamento fica desabilitado, porque sobrescrever recria a tabela inteira e ignora partições. Portanto, o correto é A. Na aba Destino, definir o Modo como Anexar.
  13. snowq 👍 1 Answered A
    The key detail is that Table1 is currently unpartitioned. In Fabric Copy Activity, you cannot select a partition column until the destination table is already configured to append data into partitions.
  14. dee2593 👍 1
    correction is: Option D; https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-lakehouse-partition#load-data-to-lakehouse-using-partition-columns
  15. 8b9f9a0 👍 1 Answered A
    In Fabric’s Copy activity, the option to specify a partition column in the Destination settings is only available when the write mode is set to “Append”.
  16. emboutchamani 👍 1 Answered A
    What should you do first ? Before setting partition you have to set mode toappend after you can select partition column
  17. KitHsia 👍 1
    It will goes C if the source data is a file, you must first select 'Enable partitions' in the Source section.
  18. KitHsia 👍 1 Answered D
    I'll go with A or D. I just found that 'Enable partitions' is available in both Overwrite and Append modes.
  19. dev2dev 👍 1 Answered D
    those who still think B is the answer, emphasis on "What should you do first?"
  20. David_Webb 👍 1 Answered D
    Partition option need to switch to Overwrite mode first.
  21. Bharat 👍 1
    The table is unpartitioned to begin with.
  22. Sowwy1 👍 1 Answered D
    I think it s D
  23. emboutchamani 👍 1
    correction: D

Reader comments & corrections

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

Log in to comment, report an error, or add a note about this question.

Fabric Deployment Pipeline Folder Structure Behavior

S-grade

Accessing OneLake Shortcuts in Fabric Notebooks

S-grade

Direct Lake Fallback to DirectQuery with Row-Level Security

S-grade

Displaying All Rows in Power BI Python Visuals

S-grade

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