Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-600 Exam - Topic 3 Question 28 Discussion

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?
B) From the Destination tab, set Table action to Overwrite.
A) From the Source tab, add additional columns.
C) From the Settings tab, select Enable staging
D) From the Source tab, select Enable partition discovery
E) From the Source tab, select Recursively

Microsoft DP-600 Exam - 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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Hector
8 months ago
D seems irrelevant here, not sure why it's an option.
upvoted 0 times
...
Sheridan
9 months ago
Wait, can you really just overwrite like that? Sounds risky!
upvoted 0 times
...
Shawnta
9 months ago
Overwrite is a must for this scenario, right?
upvoted 0 times
...
Owen
9 months ago
I think A might be necessary too.
upvoted 0 times
...
Paulina
9 months ago
B is definitely the way to go!
upvoted 0 times
...
Jeannetta
10 months ago
I’m not entirely confident, but I feel like enabling staging might help with data integrity. However, I’m not sure if it’s necessary for this specific requirement.
upvoted 0 times
...
Shawnda
10 months ago
I think we did a similar question where we had to replace data in a table. If I remember correctly, setting the table action to Overwrite was the key step.
upvoted 0 times
...
Dean
10 months ago
I'm a bit unsure about the options. I feel like overwriting the table is crucial, but I can't recall if that's done in the Source or Destination tab.
upvoted 0 times
...
Zoila
10 months ago
I remember we discussed how to handle schema changes in our last practice session. I think we might need to focus on the destination settings for this one.
upvoted 0 times
...
Ettie
10 months ago
Hmm, I'm not sure about the "additional columns" option. Wouldn't that just add new columns to the table, rather than replacing the entire schema? I think I'll go with option B as well.
upvoted 0 times
...
Jill
10 months ago
I'm pretty confident that option B is the right answer. Overwriting the table will ensure that the new data completely replaces the old data, which is exactly what the requirements are asking for.
upvoted 0 times
...
Keshia
10 months ago
I'm a bit confused by the options. Do we need to enable staging or partition discovery? Those seem like they might be relevant, but I'm not sure how they fit into the requirements.
upvoted 0 times
...
Lashawn
10 months ago
Okay, the key here is that the schema of the external data changes regularly, and we need to replace the entire table with the new data. I think option B, setting the Table action to Overwrite, is the way to go.
upvoted 0 times
...
Susana
10 months ago
Hmm, this looks like a tricky one. I'll need to carefully read through the requirements and options to make sure I understand exactly what I need to do.
upvoted 0 times
...
Christiane
2 years 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
2 years ago
Yeah, 'Overwrite' seems like the most straightforward way to handle the data copy operation.
upvoted 0 times
...
Evangelina
2 years ago
I think sticking with B is the safest option to ensure the requirements are met.
upvoted 0 times
...
Socorro
2 years ago
I agree, 'Enable staging' might be worth a try to handle schema changes more efficiently.
upvoted 0 times
...
Nelida
2 years ago
B is the best choice. Overwrite will replace the table and data with the external data.
upvoted 0 times
...
...
Dolores
2 years 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
2 years 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
2 years 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 years ago
I agree, B is the most logical choice to meet the requirements.
upvoted 0 times
...
Joaquin
2 years ago
I think B is the best option. Overwriting the table is necessary for this scenario.
upvoted 0 times
...
...
Yaeko
2 years 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 years ago
C) From the Settings tab, select Enable staging.
upvoted 0 times
...
Lashawn
2 years ago
B) From the Destination tab, set Table action to Overwrite.
upvoted 0 times
...
Alexis
2 years ago
A) From the Source tab, add additional columns.
upvoted 0 times
...
...
Fabiola
2 years 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
2 years 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
Dalene
2 years ago
Yes, selecting Overwrite will meet the requirements mentioned in the question.
upvoted 0 times
...
Tequila
2 years ago
That makes sense, we need to ensure the schema and data in Table1 are completely replaced.
upvoted 0 times
...
Pete
2 years ago
I agree, setting the Table action to Overwrite will replace all the data in Table1 with the external data.
upvoted 0 times
...
Annamae
2 years ago
I think the correct answer is B.
upvoted 0 times
...
...
Mel
2 years ago
I agree with Charlene. Overwriting the table will replace the schema and data with the external data.
upvoted 0 times
...
Charlene
2 years ago
I think we should set Table action to Overwrite from the Destination tab.
upvoted 0 times
...

Save Cancel