DP-203 Certification Practice Question #191

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?

Accepted Answer

In mapping data flows, the transformation that specifies whether a row should be inserted, updated, deleted, or upserted in the sink is Alter Row. The other listed transformations help shape or combine data, but they do not mark rows with upsert policy logic.

More DP-203 practice questions