Free Microsoft Azure DP-300 Actual Exam Questions - Question 12 Discussion
SIMULATION Task 8 You plan to perform performance testing of db1. You need prevent db1 from reverting to the last known good query plan.
If the test is on SQL Server, disabling automatic plan correction might involve trace flags or certain database scoped configurations, so options mentioning those could be right. Otherwise, options about Oracle or MySQL won’t apply.
I’d rule out any options that mention “last known good plan” caching or forcing a plan freeze. Usually, you want to disable plan freezing or anything like automatic plan correction to stop it from reverting. One trap could be picking something that only updates stats but doesn’t prevent reversion. The key is to look for the setting or command that keeps the optimizer from switching back automatically during your test.