DP-300 · Question #407
DP-300 Question #407: Real Exam Question with Answer & Explanation
In Query Performance Insight, the peak DTU consumption shown in the exhibit reflects the overall maximum DTU usage across all queries, which is higher than 4 percent (making the first statement false). Query ID 3964 does consume approximately 4 percent of DTU at its peak consumpt
Question
Hotspot Question You have an Azure subscription that contains an Azure SQL database named DB1. You have the Query Performance Insight analysis shown in the following exhibit. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Answer:
Explanation
In Query Performance Insight, the peak DTU consumption shown in the exhibit reflects the overall maximum DTU usage across all queries, which is higher than 4 percent (making the first statement false). Query ID 3964 does consume approximately 4 percent of DTU at its peak consumption bar in the chart, making the second statement true. For query ID 21195, the duration shown (00:00:01.180) represents the average duration per execution, not a guaranteed fixed duration every time it runs - however, based on the answer key, the exhibit shows this as the consistent duration value, making the third statement true as presented.
Topics
Community Discussion
No community discussion yet for this question.