DP-600 · Question #32
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 co
The correct answer is 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).
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?
Options
- AFrom the Destination tab, set Mode to Append.
- BFrom the Destination tab, select the partition column.
- CFrom the Source tab, select Enable partition discovery.
- DFrom the Destination tabs, set Mode to Overwrite.
How the community answered
(32 responses)- A9% (3)
- B3% (1)
- C13% (4)
- D75% (24)
Explanation
When setting up the Copy Activity, you need to choose the Overwrite mode to make the partition option appear (not visibile in Append mode).
Topics
Community Discussion
No community discussion yet for this question.