DP-300 Certification Practice Question #171

Question

You have an Azure SQL database.
Users report that the executions of a stored procedure are slower than usual. You suspect that a regressed query is causing the performance issue.
You need to view the query execution plan to verify whether a regressed query is causing the issue. The solution must minimize effort.
What should you use?

Accepted Answer

To identify a regressed query and view its query execution plan with minimal effort, you should use Query Store in Microsoft SQL Server Management Studio (SSMS) (Option C). The "Regressed Queries" view in Query Store is specifically designed to pinpoint queries with degraded performance, showing their historical execution plans and runtime statistics. While Query Performance Insight in the Azure portal (Option D) displays database query telemetry, it does not support viewing or comparing query execution plans. Extended Events (Option B) require significant custom configuration, and Performance Recommendations (Option A) only provide automated recommendations rather than raw plan troubleshooting.

More DP-300 practice questions