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…

Submitted by brentm· Mar 6, 2026Monitor and optimize SQL Server performance - specifically configuring the Query Store to capture query execution data for performance analysis and troubleshooting (maps to DP-300: Administering Relational Databases on Microsoft Azure or equivalent SQL Server administration certification).

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. Answer:

Exhibit

Explanation

Setting the Query Store Operation Mode to 'Read Write' is the correct configuration because it enables SQL Server to actively capture and store query execution data, including runtime statistics and query plans. Without 'Read Write' mode, the Query Store is either disabled (Off) or in a read-only state where it cannot capture new queries. This setting is accessible through SQL Server Management Studio via Database Properties > Query Store page, and ensures all queries against db1 are captured as required.

Topics

#Query Store#SQL Server Performance Monitoring#Database Configuration#SSMS Administration

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice