🔥 3-day streak
Microsoft Azure Database Administrator Associate92 / 144
Question 92 of 144

You manage an Azure SQL Database supporting an order-entry application. Users report that a specific reporting stored procedure sometimes returns in under a second and other times takes over 30 seconds, with no code changes deployed. You have Query Store enabled and want to confirm whether the intermittent slowness is caused by the query executing under different execution plans. Which Query Store view or feature should you use to identify a query that has multiple plans with significantly different runtime performance?

Reviewed for accuracy · Report an issueNext question