nerdexam
Microsoft

DP-300 · Question #455

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…

The correct answer is Query ID 35591 is the least performant query overall. = Yes; Query ID 35563 consumed the most database resources. = Yes. 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…

Submitted by andreas_gr· Mar 6, 2026Monitor and optimize Azure resources - specifically monitoring Azure SQL Database query performance using Query Performance Insight to identify resource-intensive and least performant queries, which aligns with the Azure Administrator (AZ-104) or Azure DBA (DP-300) monitoring and optimization domain.

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:

Exhibits

DP-300 question #455 exhibit 1
DP-300 question #455 exhibit 2

Answer Area

  • Query ID 35591 is the least performant query overall.Yes
  • Query ID 35563 consumed the most database resources.Yes

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

#Azure SQL Database#Query Performance Insight#Database Monitoring#Performance Tuning

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice