Microsoft Exam DP-203 Topic 2 Question 105 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 105
Topic #: 2

You are building a data flow in Azure Data Factory that upserts data into a table in an Azure Synapse Analytics dedicated SQL pool.

You need to add a transformation to the data flow. The transformation must specify logic indicating when a row from the input data must be upserted into the sink.

Which type of transformation should you add to the data flow?

Ajoin

Bselect

Csurrogate key

Dalter row

Show Suggested Answer

Suggested Answer: D

The alter row transformation allows you to specify insert, update, delete, and upsert policies on rows based on expressions. You can use the alter row transformation to perform upserts on a sink table by matching on a key column and setting the appropriate row policy

by Lavonda at Nov 19, 2024, 09:40 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Denae

2 days ago

I think B) select is the way to go. You need to select the relevant columns for the upsert, right?

upvoted 0 times

...

Providencia

11 days ago

I'm not sure about that. I think the answer might be A) join, as it helps combine data from multiple sources before upserting.

upvoted 0 times

...

Genevive

20 days ago

I agree with Elinore. Surrogate key is used to uniquely identify rows in a table, which is essential for upsert operations.

upvoted 0 times

...

Elinore

21 days ago

I think the answer is C) surrogate key.

upvoted 0 times

...

Grover

24 days ago

D) alter row is the correct choice here. The question specifically asks for a transformation that specifies the logic for upserts, and alter row is the perfect fit for that requirement.

upvoted 0 times

...