🔥 3-day streak
Microsoft Azure Database Administrator Associate84 / 144
Question 84 of 144

You manage an Azure SQL Database at compatibility level 160. A frequently executed stored procedure filters an Orders table by CustomerId. A few customers have millions of rows while most have only a handful. Users report that the procedure sometimes runs fast and sometimes very slowly depending on which plan happens to be cached. You want the engine to automatically maintain multiple cached plans suited to different predicate value distributions without you having to force plans or rewrite the query. Which capability addresses this?

Reviewed for accuracy · Report an issueNext question