DP-300 Certification Practice Question #155

Question

SIMULATION
 -

You need to ensure that all queries executed against db1 are captured in the Query Store.

To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

Accepted Answer

To ensure that all queries executed against the database `db1` are captured, you need to enable the Query Store and configure its capture mode. By default, Query Store may use the `AUTO` capture mode, which filters out infrequent or low-resource queries. To capture every single query, you must set the `QUERY_CAPTURE_MODE` to `ALL` and ensure the `OPERATION_MODE` is set to `READ_WRITE`. This can be done via SSMS by opening database properties, navigating to the Query Store page, and setting the capture mode to All, or by executing the Transact-SQL command: `ALTER DATABASE [db1] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, QUERY_CAPTURE_MODE = ALL);`.

More DP-300 practice questions