Exam DP-203 topic 2 question 120 discussion

Actual exam question from Microsoft's DP-203

Question #: 120
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?

A. join
B. alter row
C. surrogate key
D. select

Show Suggested Answer

Suggested Answer: B 🗳️

by warre at Jan. 8, 2024, 7:58 p.m.

Comments

Submit Cancel

Alongi

10 months ago

correct

upvoted 1 times

...

tung_dao

10 months, 4 weeks ago

Selected Answer: B

Use the Alter Row transformation to set insert, delete, update, and upsert policies on rows. Ref: https://learn.microsoft.com/en-us/azure/data-factory/data-flow-alter-row

upvoted 1 times

...

warre

1 year ago

correct, chatGPT: For upsert operations (insert or update), you typically need to determine whether a record already exists in the destination table based on some condition. In Azure Data Factory's data flow, you would use the "Alter Row" transformation for this purpose.

upvoted 3 times

...