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

8 months, 1 week ago

correct

upvoted 1 times

...

tung_dao

9 months 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

11 months, 1 week 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

...