Exam DP-600 topic 1 question 38 discussion

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

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.

In Microsoft Fabric, partitioning a table during a Copy activity is only supported in "Append" mode, not "Overwrite" mode.

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.

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

From the Destination tabs, set Mode to Overwrite.

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

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.

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

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.

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.

Partition option need to switch to Overwrite mode first.

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

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

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?

D is correct. Partition is available when Overwrite is checked

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