Data Engineering on Microsoft Azure — Question 82

You have an Azure subscription that contains an Azure Synapse Analytics workspace name workspace1, workspace1 contains an Azure Synapse Analytics dedicated SQL pool named Pool1.

You create a mapping data flow in an Azure Synapse pipeline that writes data to Pool1.

You execute the data flow and capture the execution information.

You need to identify how long it takes to write the data to Pool1.

Which metric should you use?

Answer options

• A. the rows written
• B. the sink processing time
• C. the transformation processing time
• D. the post processing time

Correct answer: B

Explanation

The correct answer is B, the sink processing time, as it specifically measures the duration taken to write data to the destination, which in this case is Pool1. The other options, while related to the data flow execution, do not provide the relevant timing information for the writing process.