Data Engineering on Microsoft Azure — Question 88

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?

Answer options

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

Correct answer: B

Explanation

The 'alter row' transformation is specifically designed to define the upsert logic for rows in a data flow. The other options like 'join', 'surrogate key', and 'select' do not provide the functionality needed to specify conditions for upserting data.