🔥 3-day streak
Microsoft Azure Database Administrator Associate18 / 144
Question 18 of 144

You manage an Azure SQL Database supporting an OLTP application. Users intermittently report slow response times after application deployments and statistics updates. Investigation shows that certain queries suddenly choose worse execution plans, causing CPU spikes that resolve on their own hours later. You want Azure to automatically detect these plan regressions and revert to the previously well-performing plan without manual intervention. Which configuration should you enable?

Reviewed for accuracy · Report an issueNext question