Microsoft Exam DP-203 Topic 6 Question 79 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 79
Topic #: 6

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 Elke at Nov 22, 2023, 08:57 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Sharan

10 months ago

That's true, Hermila. These certification exams love to sneak in those tricky questions. But I think we're ready for them now. Bring it on, Azure overlords!

upvoted 0 times

...

Hermila

10 months ago

Haha, yes! Teamwork makes the dream work. Now, let's just hope the actual exam doesn't throw any curveballs at us.

upvoted 0 times

Lucina

10 months ago

D) alter row

upvoted 0 times

...

Jeff

10 months ago

C) surrogate key

upvoted 0 times

...

Cornell

10 months ago

A) join

upvoted 0 times

...

Anabel

10 months ago

Whew, I'm so relieved we figured this out. I was worried I might have forgotten something important, but you guys have my back. High-five for teamwork!

upvoted 0 times

...