"Query Store: Your First Stop"

1. What is the default state of Query Store in SQL Server 2022 for new databases?

ON OFF READ_ONLY READ_WRITE

2. Which SQL command is used to enable Query Store for a database?

ENABLE QUERY STORE; ALTER DATABASE [YourDatabase] SET QUERY_STORE = ON; START QUERY STORE; SET QUERY STORE ON;

3. What should you check if actual_state_desc is READ_ONLY with a non-zero readonly_reason?

Query Store is running correctly Query Store is disabled Query Store has storage issues Query Store is set to auto mode

4. What is the primary purpose of the Query Store according to this lesson?

To collect statistics on disk usage To analyze server performance To capture query performance and plans To manage database user permissions