ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 4 question 64 discussion

Actual exam question from Microsoft's DP-203
Question #: 64
Topic #: 4
[All DP-203 Questions]

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?

  • A. the rows written
  • B. the sink processing time
  • C. the transformation processing time
  • D. the post processing time
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by jongert at Jan. 5, 2024, 5:57 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
imatheushenrique
1 month, 2 weeks ago
Selected Answer: B
B. the sink processing time the sink represents the final destination where data is written. Sink processing time measures how long it takes to write the data to the destination (Pool1).
upvoted 2 times
...
evangelist
9 months, 2 weeks ago
Selected Answer: B
Sink processing time: This metric measures the time taken to write the data to the sink, which in this case is Pool1. It directly answers the question about how long the write operation takes.
upvoted 2 times
...
efeee333
1 year, 2 months ago
Selected Answer: B
correct
upvoted 1 times
...
jongert
1 year, 3 months ago
Correct: 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
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago