DP-300 Certification Practice Question #177

Question

You have an Azure SQL Database managed instance.
The instance starts experiencing performance issues.
You need to identify which query is causing the issue and retrieve the execution plan for the query. The solution must minimize administrative effort.
What should you use?

Accepted Answer

To identify which query is causing performance issues and retrieve its execution plan while minimizing administrative effort, Query Store (Option C) is the ideal solution. In SSMS, Query Store provides built-in, easy-to-use graphical reports (such as "Top Resource Consuming Queries") that let you immediately identify high-impact queries and view their plans with a single click. While Dynamic Management Views (Option D) can locate active performance bottlenecks, they require writing and executing complex T-SQL queries joining multiple DMV/DMF structures (like `sys.dm_exec_requests` and `sys.dm_exec_query_plan`), resulting in higher administrative overhead.

More DP-300 practice questions