DP-300 · Question #455
DP-300 Question #455: Real Exam Question with Answer & Explanation
Query ID 35591 is the least performant query overall because in Query Performance Insight, queries are ranked by resource consumption, and 35591 appears at the bottom of the list with the highest duration or lowest efficiency metrics, making it the worst performer overall. Query
Question
Hotspot Question You have an Azure subscription that contains an app named App and an Azure SQL database named DB1. App1 queries DB1. You use Query Performance Insight to get query details for DB1 as shown in the exhibit. (Click the Exhibit tab.) Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Answer:
Explanation
Query ID 35591 is the least performant query overall because in Query Performance Insight, queries are ranked by resource consumption, and 35591 appears at the bottom of the list with the highest duration or lowest efficiency metrics, making it the worst performer overall. Query ID 35563 consumed the most database resources because it appears at the top of the Query Performance Insight chart, indicating it has the highest cumulative CPU, duration, or execution count metrics - Query Performance Insight ranks queries by total resource impact, and the topmost query represents the greatest resource consumer over the observed time period.
Topics
Community Discussion
No community discussion yet for this question.