Quiz on Automatic Tuning in SQL Server

Q1. Automatic Plan Correction works at the…

  •  Instance level
  •  Object level
  •  Database level
  •  Schema level
Database level

Q2. You can use the ‘Queries with High Variation Query Store Report’ in Standard Edition.

  • True
  • False
True

Q3. You can see suggestions in sys.dm_db_tuning_recommendations in Standard Edition.

  • True
  • False
False

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).

  • True
  • False
True

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
Yes, but it may be auto-tuned again in the future

Q6. Automatic Plan Correction may force a plan for a query with a recompile hint.

  • True
  • False
False

Q7. You may manually force a plan in Query Store for a query with a recompile hint.

  • True
  • False
True
Lesson tags: Auto Tuning with Automatic Plan Correction In Query Store, Query Store
Back to: Auto Tuning with Automatic Plan Correction In Query Store (1 hour 8 minutes) > Quiz

Share a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Menu