You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVMI. SQLVM1 hosts a database named DB1. You need to retrieve query plans from the Query Store on…

The correct answer is C. From Microsoft SQL Server Management Studio, modify the properties of DB1. Enable the Query Store Use the Query Store page in SQL Server Management Studio 1. In Object Explorer, right-click a database, and then select Properties. 2. In the Database Properties dialog box, select the Query Store page. 3. In the Operation Mode (Requested) box, select…

Submitted by hans_de· Mar 6, 2026Optimize query performance

Question

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVMI. SQLVM1 hosts a database named DB1. You need to retrieve query plans from the Query Store on DB1. What should you do first?

Options

AOn SQLVM1, install the SQL Server laaS Agent extension.
BFrom Microsoft SQL Server Management Studio, modify the properties of the SQL Server instance.
CFrom Microsoft SQL Server Management Studio, modify the properties of DB1.
DOn SQLVM1, install the Azure Monitor agent for Windows.

How the community answered

(28 responses)

B
7% (2)
C
89% (25)
D
4% (1)

Explanation

Enable the Query Store Use the Query Store page in SQL Server Management Studio 1. In Object Explorer, right-click a database, and then select Properties. 2. In the Database Properties dialog box, select the Query Store page. 3. In the Operation Mode (Requested) box, select Read Write. https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance- by-using-the-query-store

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice