Microsoft Exam DP-600 Topic 3 Question 28 Discussion

Actual exam question for Microsoft's DP-600 exam

Question #: 28
Topic #: 3

[All DP-600 Questions]

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains a table named Table1.

You are creating a new data pipeline.

You plan to copy external data to Table1. 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?

AFrom the Source tab, add additional columns.

BFrom the Destination tab, set Table action to Overwrite.

CFrom the Settings tab, select Enable staging

DFrom the Source tab, select Enable partition discovery

EFrom the Source tab, select Recursively

Show Suggested Answer

Suggested Answer: B

For the Copy data activity, from the Destination tab, setting Table action to Overwrite (B) will ensure that Table1 is replaced with the schema and rows of the external data, meeting the requirements of replacing both the schema and data of the destination table. Reference = Information about Copy data activity and table actions in Azure Data Factory, which can be applied to data pipelines in Fabric, is available in the Azure Data Factory documentation.

by Pete at Nov 19, 2024, 04:24 AM

Limited Time Offer

25%

Off

Get Premium DP-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Christiane

2 months ago

B is definitely the way to go. Overwrite is the only option that fully meets the requirements. Although, I'd be tempted to try the 'Enable staging' option just to see if it can do a better job of handling the schema changes. You know, for science!

upvoted 0 times

Val

1 months ago

Yeah, 'Overwrite' seems like the most straightforward way to handle the data copy operation.

upvoted 0 times

...

Evangelina

1 months ago

I think sticking with B is the safest option to ensure the requirements are met.

upvoted 0 times

...

Socorro

2 months ago

I agree, 'Enable staging' might be worth a try to handle schema changes more efficiently.

upvoted 0 times

...

Nelida

2 months ago

B is the best choice. Overwrite will replace the table and data with the external data.

upvoted 0 times

...

Dolores

2 months ago

I'd go with B as well. Replacing the entire table is the key requirement here, and Overwrite is the logical choice. Although, I'm curious if anyone's tried the 'Recursively' option for a laugh.

upvoted 0 times

Una

1 months ago

Yeah, it could be fun to experiment with different options, but for production, sticking with Overwrite is the safest bet.

upvoted 0 times

...

Tricia

1 months ago

I haven't tried the 'Recursively' option, but it sounds interesting. Maybe worth a try in a test environment.

upvoted 0 times

...

Bulah

2 months ago

I agree, B is the most logical choice to meet the requirements.

upvoted 0 times

...

Joaquin

2 months ago

I think B is the best option. Overwriting the table is necessary for this scenario.

upvoted 0 times

...

Yaeko

2 months ago

Hmm, I'm not sure about this one. Maybe C would work too, as enabling staging could help with the schema changes, but B sounds like the most straightforward solution.

upvoted 0 times

Brittani

2 months ago

C) From the Settings tab, select Enable staging.

upvoted 0 times

...

Lashawn

2 months ago

B) From the Destination tab, set Table action to Overwrite.

upvoted 0 times

...

Alexis

2 months ago

A) From the Source tab, add additional columns.

upvoted 0 times

...

Fabiola

2 months ago

I'm not sure about that. Shouldn't we also enable staging from the Settings tab to ensure a smooth copy operation?

upvoted 0 times

...

Tien

3 months ago

I think the correct answer is B. The question clearly states that the requirement is to replace the entire Table1 with the external data, so setting the Table action to Overwrite is the right choice.

upvoted 0 times