New Year Sale 2026! 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
Mary
12 days 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
17 days 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
22 days 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
28 days 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
1 month 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
1 month 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
1 month 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
2 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
2 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
2 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
2 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
2 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