Query Store Analysis Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Query Optimization

What you'll be asked

  1. What is the primary purpose of the Query Store feature in SQL Server?
  2. You notice a sudden performance degradation for a specific query. Which Query Store report is most effective for identifying this regression?
  3. When using Query Store, what does the 'Plan Forcing' feature allow a Database Administrator to do?
  4. A query is showing multiple execution plans in Query Store. What is the most likely reason for this 'plan instability'?
  5. You are analyzing a query in Query Store and notice that the 'Wait Stats' category shows a high percentage of 'LCK_M_X' waits. What does this indicate?

Answers and explanations come after you submit.