nerdexam
Microsoft

DP-203 · Question #377

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 transformatio

Sign in or unlock DP-203 to reveal the answer and full explanation for question #377. The question stem and answer options stay visible for context.

Submitted by fatima_kr· Mar 30, 2026Develop data processing

Question

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?

Options

  • Ajoin
  • Balter row
  • Csurrogate key
  • Dselect

Unlock DP-203 to see the answer

You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#alter row transformation#data flow#upsert logic#Azure Data Factory
Full DP-203 Practice