Microsoft DP-300 Exam - Topic 8 Question 107 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 107
Topic #: 8

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVM1. SQLVM1 has the following configurations:

* Automated patching is enabled.

* The SQL Server laaS Agent extension is installed.

* The Microsoft SQL Server instance on SQLVM1 is managed by using the Azuie portal.

You need to automate the deployment of cumulative updates to SQLVM1 by using Azure Update Manager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed by using the Azure portal.

What should you do first on SQLVM1?

AInstall the Azure Monitor Agent.

BUninstall the SQL Server laaS Agent extension.

CInstall the Log Analytics agent.

DSet Automated patching to Disable

Show Suggested Answer

Suggested Answer: B

by Marisha at Dec 11, 2024, 07:39 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Sabina

3 months ago

Installing the Log Analytics agent sounds like a good move too!

upvoted 0 times

...

Colette

4 months ago

I thought you had to disable automated patching first?

upvoted 0 times

...

Sarah

4 months ago

Wait, why would you uninstall the SQL Server laaS Agent? That seems risky.

upvoted 0 times

...

Levi

4 months ago

Definitely agree with that!

upvoted 0 times

...

Marcelle

4 months ago

I think you need to install the Azure Monitor Agent first.

upvoted 0 times

...

Izetta

5 months ago

Setting automated patching to disable seems counterintuitive, so I doubt that’s the right answer.

upvoted 0 times

...

Twanna

5 months ago

I’m leaning towards uninstalling the SQL Server laaS Agent extension, but I’m not confident about that choice.

upvoted 0 times

...

Erick

5 months ago

I remember a practice question where we had to manage SQL Server instances, and I feel like the Log Analytics agent was involved somehow.

upvoted 0 times

...

Reita

5 months ago

I think we need to install the Azure Monitor Agent first, but I'm not entirely sure if that's the right step.

upvoted 0 times

...

Bulah

5 months ago

I'm pretty confident I know the right answer here. The SQL Server IaaS Agent extension is already installed, so I just need to make sure it's compatible with Azure Update Manager.

upvoted 0 times

...

Minna

5 months ago

Okay, I think I've got it. The key is to ensure the SQL Server instance can still be managed through the Azure portal, so I'll focus on that as I evaluate the options.

upvoted 0 times

...

Mica

5 months ago

Hmm, I'm a bit confused about the relationship between the SQL Server IaaS Agent extension and the Azure Update Manager. I'll need to think this through carefully.

upvoted 0 times

...

Essie

5 months ago

This question seems straightforward, but I want to make sure I understand the requirements correctly before answering.

upvoted 0 times

...

Bronwyn

1 year ago

I see your point, but I believe installing the Log Analytics agent is the right choice to ensure Azure Update Manager can automate the deployment of cumulative updates.

upvoted 0 times

...

Paulina

1 year ago

But wouldn't it be better to uninstall the SQL Server IaaS Agent extension?

upvoted 0 times

...

Irma

1 year ago

This is a tricky one, but I reckon B is the best choice. Gotta love those SQL Server puns, though. 'SQL Server IaaS Agent' - sounds like a secret agent in a spy movie!

upvoted 0 times

Chantay

1 year ago

C) Install the Log Analytics agent.

upvoted 0 times

...

Anabel

1 year ago

B) Uninstall the SQL Server IaaS Agent extension.

upvoted 0 times

...

Kelvin

1 year ago

The question doesn't mention anything about the Log Analytics agent, so I'm ruling out C. I agree with Devora and India - B is the way to go.

upvoted 0 times

...

India

1 year ago

I'm not sure about this one. Disabling Automated patching seems risky, so I'm gonna go with B as well.

upvoted 0 times

Refugia

1 year ago

I'm not sure about this one. Disabling Automated patching seems risky, so I'm gonna go with B as well.

upvoted 0 times

...

Nakisha

1 year ago

Yeah, that sounds like the right move to me.

upvoted 0 times

...

Pearly

1 year ago

I think we should uninstall the SQL Server laaS Agent extension.

upvoted 0 times

...

Devora

1 year ago

Hmm, I think B is the right answer. Uninstalling the SQL Server IaaS Agent extension seems like the logical first step to switch to Azure Update Manager.

upvoted 0 times