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

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
Lashonda
3 hours ago
Really? I was leaning towards option B.
upvoted 0 times
...
Cammy
5 days ago
I think option A is the best choice.
upvoted 0 times
...
Jacklyn
10 days ago
I’m not sure about D), isn’t that for monitoring, not for Query Store?
upvoted 0 times
...
Noemi
16 days ago
Totally agree with Salome, A) is essential for this task!
upvoted 0 times
...
Arlene
21 days ago
Wait, can you really get query plans without the agent? Seems off.
upvoted 0 times
...
Rickie
26 days ago
I think B) makes more sense, modifying instance properties could help.
upvoted 0 times
...
Salome
1 month ago
A) is the right choice, you need that agent for Query Store.
upvoted 0 times
...
Barrie
1 month 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
2 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
2 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
2 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
2 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
3 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
3 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
3 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
3 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
3 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
3 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
4 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
4 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
...

Save Cancel