DP-300 Certification Practice Question #53

Question

SIMULATION
 -

You plan to perform performance testing of db1.

You need prevent db1 from reverting to the last known good query plan.

To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

Accepted Answer

To prevent Azure SQL Database from automatically forcing the last known good plan when it detects a performance regression (which is useful during performance testing to ensure custom plans or regressions are visible and not auto-corrected), the `FORCE_LAST_GOOD_PLAN` option of `AUTOMATIC_TUNING` must be turned `OFF`. This can be done via the Azure Portal under the Automatic Tuning blade for `db1` or via T-SQL using `ALTER DATABASE CURRENT SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN = OFF);`.

More DP-300 practice questions