Exam DP-600 topic 1 question 35 discussion

Actual exam question from Microsoft's DP-600

Question #: 35
Topic #: 1

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

Suggested Answer: B 🗳️

by IshtarSQL at Feb. 9, 2024, 8:36 p.m.

...

stilferx

1 year 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, 1 month 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, 2 months 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, 3 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, 1 month ago

this answer option is not available. Additionally, truncate a table does only delete the data but does not touch schema.

upvoted 3 times

...