DP-203 · Question #397
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…
The correct answer is B. the sink processing time. Each transformation stage includes a total time for that stage to complete with each partition execution time totaled together. When you select the Sink, you see "Sink Processing Time". This time includes the total of the transformation time plus the I/O time it took to write…
Question
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?
Options
- Athe rows written
- Bthe sink processing time
- Cthe transformation processing time
- Dthe post processing time
How the community answered
(24 responses)- A4% (1)
- B75% (18)
- C17% (4)
- D4% (1)
Explanation
Each transformation stage includes a total time for that stage to complete with each partition execution time totaled together. When you select the Sink, you see "Sink Processing Time". This time includes the total of the transformation time plus the I/O time it took to write your data to your destination store. The difference between the Sink Processing Time and the total of the transformation is the I/O time to write the data. https://learn.microsoft.com/en-us/azure/data-factory/concepts-data-flow-monitoring#total-sink- processing-time-vs-transformation-processing-time
Topics
Community Discussion
No community discussion yet for this question.