Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 1 Question 123 Discussion

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVMI. SQLVMI hosts a database named OBI.You need to retrieve query plans from the Query Store on DBI.What should you do first?
B) From Microsoft SQL Server Management Studio, modify the properties of the SQL Server instance.
A) On SQLVM1, install the SQL Server laaS Agent extension.
C) From Microsoft SQL Server Management Studio, modify the properties of DB 1.
D) On SQLVM1, install the Azure Monitor agent for Windows.

Microsoft DP-300 Exam - Topic 1 Question 123 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 123
Topic #: 1
[All DP-300 Questions]

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVMI. SQLVMI hosts a database named OBI.

You need to retrieve query plans from the Query Store on DBI.

What should you do first?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Hermila at Jan 05, 2026, 05:16 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Yong
3 months ago
I feel like D could be useful for monitoring.
upvoted 0 times
...
Alexis
4 months ago
Option C makes sense too, but I’m not sure.
upvoted 0 times
...
Lashonda
4 months ago
Really? I was leaning towards option B.
upvoted 0 times
...
Cammy
4 months ago
I think option A is the best choice.
upvoted 0 times
...
Jacklyn
4 months ago
I’m not sure about D), isn’t that for monitoring, not for Query Store?
upvoted 0 times
...
Noemi
4 months ago
Totally agree with Salome, A) is essential for this task!
upvoted 0 times
...
Arlene
4 months ago
Wait, can you really get query plans without the agent? Seems off.
upvoted 0 times
...
Rickie
5 months ago
I think B) makes more sense, modifying instance properties could help.
upvoted 0 times
...
Salome
5 months ago
A) is the right choice, you need that agent for Query Store.
upvoted 0 times
...
Barrie
5 months ago
I bet the query plans are hiding in the Azure SQL Server's secret underground lair. Better bring a flashlight!
upvoted 0 times
...
Mary
6 months ago
C) Modifying the database properties doesn't seem like the right approach to retrieve query plans from the Query Store.
upvoted 0 times
...
Vincenza
6 months ago
D) Installing the Azure Monitor agent could be useful, but I don't think that's the immediate solution here.
upvoted 0 times
...
Billy
6 months ago
B) Modifying the SQL Server instance properties might be a good idea, but I'm not sure if that's the first step.
upvoted 0 times
...
Terina
6 months ago
A) Sounds like the right move to me. The SQL Server IaaS Agent extension should help with retrieving the query plans.
upvoted 0 times
...
Carin
6 months ago
I thought we had to install the SQL Server IaaS Agent extension to enable certain features, but I’m not confident if that’s the first step here.
upvoted 0 times
...
Felton
7 months ago
This question feels similar to one we practiced about enabling Query Store. I think we had to check the instance settings first, but I can't remember the exact option.
upvoted 0 times
...
Cherry
7 months ago
I remember something about needing to install an agent for monitoring, but I can't recall if it's the SQL Server IaaS Agent or the Azure Monitor agent.
upvoted 0 times
...
Audria
7 months ago
I think we might need to modify the properties of the database first, but I'm not entirely sure if that's the right step.
upvoted 0 times
...
Sunshine
7 months ago
I'm feeling pretty confident about this one. The question states we need to retrieve query plans from the Query Store on DB1, so the obvious first step is to install the SQL Server IaaS Agent extension on the SQLVM1 instance.
upvoted 0 times
...
Franklyn
7 months ago
Okay, I've got it! We need to enable the Query Store at the SQL Server instance level, not the database level. So the correct answer is to modify the properties of the SQL Server instance from SSMS.
upvoted 0 times
...
Barabara
7 months ago
Hmm, I think the key here is that we need to access the Query Store, which is a database-level feature. So I'm leaning towards modifying the properties of the DB1 database from SSMS to enable the Query Store.
upvoted 0 times
...
Queenie
8 months ago
I'm a bit confused about the difference between the SQL Server IaaS Agent extension and the Azure Monitor agent for Windows. I'll need to review the details of each to determine which one is needed to retrieve the query plans.
upvoted 0 times
Charlena
2 months ago
True, but for query plans, the IaaS Agent might be the way to go.
upvoted 0 times
...
Aileen
3 months ago
Yeah, but the Azure Monitor agent helps with overall monitoring.
upvoted 0 times
...
Audra
3 months ago
I think the SQL Server IaaS Agent extension is more focused on SQL features.
upvoted 0 times
...
...

Save Cancel