DP-300 · Question #407
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…
The correct answer is The peak DTU consumption is 4 percent. = No; The peek consumption of the query that has ID 3964 is 4 percent. = Yes; The query that has ID 21195 has a duration of 00:00:01.180 every time it runs. = Yes. 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…
Question
Exhibits
Answer Area
- The peak DTU consumption is 4 percent.No
- The peek consumption of the query that has ID 3964 is 4 percent.Yes
- The query that has ID 21195 has a duration of 00:00:01.180 every time it runs.Yes
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.