70-473 · Question #92
You have a Microsoft Azure SQL database named DB1. You need to monitor DB1 to identity all regressed queries. Which command should you use?
The correct answer is B. ALTER DATABASE DB1 SET QUERY_STORE (OPERATION_MODE READ_WRITE). To identify regressed queries in an Azure SQL database, Query Store must be enabled and configured to collect query execution data.
Question
Options
- Aselect *
- BALTER DATABASE DB1 SET QUERY_STORE (OPERATION_MODE READ_WRITE)
- Cselect *
- DALTER DATABASE DB1 SET QUERY_SSTORE (QUERY_CAPTURE_MODE All) GO
How the community answered
(38 responses)- A3% (1)
- B87% (33)
- C8% (3)
- D3% (1)
Why each option
To identify regressed queries in an Azure SQL database, Query Store must be enabled and configured to collect query execution data.
`SELECT *` is a data retrieval command and does not configure monitoring for regressed queries.
The `ALTER DATABASE SET QUERY_STORE (OPERATION_MODE = READ_WRITE)` command enables Query Store for the specified database, allowing it to collect query runtime statistics necessary for identifying regressed queries.
`SELECT *` is a data retrieval command and does not configure monitoring for regressed queries.
This command contains a typo ('QUERY_SSTORE') and, while `QUERY_CAPTURE_MODE` is a Query Store setting, `OPERATION_MODE = READ_WRITE` is the primary command to enable data collection.
Concept tested: Azure SQL Database Query Store management
Source: https://learn.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store?view=sql-server-ver16#best-practice-with-query-store
Topics
Community Discussion
No community discussion yet for this question.