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

Currently there are no comments in this discussion, be the first to comment!