Query Store Analysis Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Query Optimization

Query Store Analysis Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    What is the primary purpose of the Query Store feature in SQL Server?

  2. 2

    You notice a sudden performance degradation for a specific query. Which Query Store report is most effective for identifying this regression?

  3. 3

    When using Query Store, what does the 'Plan Forcing' feature allow a Database Administrator to do?

  4. 4

    A query is showing multiple execution plans in Query Store. What is the most likely reason for this 'plan instability'?

  5. 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?