ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam
Go to Exam

Exam DP-600 topic 1 question 35 discussion

Actual exam question from Microsoft's DP-600
Question #: 35
Topic #: 1
[All DP-600 Questions]

You have a Fabric tenant that contains a lakehouse named Lakehouse’. Lakehouse1 contains a table named Tablet.
You are creating a new data pipeline.
You plan to copy external data to Table’. The schema of the external data changes regularly.
You need the copy operation to meet the following requirements:
Replace Table1 with the schema of the external data.
Replace all the data in Table1 with the rows in the external data.
You add a Copy data activity to the pipeline.
What should you do for the Copy data activity?

  • A. From the Source tab, add additional columns.
  • B. From the Destination tab, set Table action to Overwrite.
  • C. From the Settings tab, select Enable staging.
  • D. From the Source tab, select Enable partition discovery.
  • E. From the Source tab, select Recursively.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by IshtarSQL at Feb. 9, 2024, 8:36 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Momoanwar
Highly Voted 1 year, 2 months ago
Selected Answer: B
Replace all with overwrite
upvoted 8 times
...
Egocentric
Most Recent 3 months, 1 week ago
Selected Answer: B
Destination tab set table action to overwrite
upvoted 1 times
...
NRezgui
4 months ago
Selected Answer: B
From the Destination tab, set Table action to Overwrite.
upvoted 1 times
...
Rakesh16
5 months, 1 week ago
Selected Answer: B
From the Destination tab, set Table action to Overwrite.
upvoted 1 times
...
2dc6125
11 months, 3 weeks ago
B Since the plan is to drop the destination schema and replace it with data source schema.
upvoted 2 times
...
stilferx
11 months, 3 weeks ago
Selected Answer: B
IMHO, B and only B. Not D, because it is about partitions, not A, C, D - because of completely different purpose. A may be, generally, but it is not what a question about.
upvoted 1 times
...
VAzureD
1 year ago
Selected Answer: B
Overwrite https://learn.microsoft.com/en-us/fabric/data-factory/copy-data-activity#configure-your-source-under-the-source-tab Expand Advanced for more advanced settings.
upvoted 1 times
...
a_51
1 year, 1 month ago
Selected Answer: B
B, the tool tip for Overwrite tells you: "Enable overwrite table option to overwrite the existing data and schema in the table using the new values"
upvoted 1 times
...
IshtarSQL
1 year, 2 months ago
Selected Answer: B
Correct: Enable "Truncate table" option: This option truncates the target table before copying data, ensuring that all existing data is replaced with the new data from the external source.
upvoted 2 times
Nefirs
1 year ago
this answer option is not available. Additionally, truncate a table does only delete the data but does not touch schema.
upvoted 3 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago