Grab a pen and notepad, and jot down your answers as you go, then check your answers at the key at the bottom of the page.
Q1. Automatic Plan Correction works at the…
- Instance level
- Object level
- Database level
- Schema level
Q2. You can use the ‘Queries with High Variation Query Store Report’ in Standard Edition.
Q3. You can see suggestions in sys.dm_db_tuning_recommendations in Standard Edition.
Q4. You can see suggestions in sys.sys.dm_db_tuning_recommendations in Enterprise Edition if you have Query Store Enabled, but do not SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN = ON).
Q5. Can you manually un-force a query plan that has been forced with Automatic Plan Correction?
- No, you cannot un-force it
- Yes, but it may be auto-tuned again in the future
- Yes, and it will never be auto-tuned again in the future
Q6. Automatic Plan Correction may force a plan for a query with a recompile hint.
Q7. You may manually force a plan in Query Store for a query with a recompile hint.
Scroll down for the answer key 👇
- A1: Database level
- A2: True
- A3: False
- A4: True
- A5: Yes, but it may be auto-tuned again in the future
- A6: False
- A7: True