Exam DP-300 topic 5 question 34 discussion

Actual exam question from Microsoft's DP-300

Question #: 34
Topic #: 5

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 IaaS Agent extension is installed.
• The Microsoft SQL Server instance on SQLVM1 is managed by using the Azure 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?

A. Install the Azure Monitor Agent.
B. Uninstall the SQL Server IaaS Agent extension.
C. Install the Log Analytics agent.
D. Set Automated patching to Disable.

Show Suggested Answer

Suggested Answer: C 🗳️

by 2f5c7cd at Nov. 2, 2024, 5:27 a.m.

Comments

Submit Cancel

voodoo_sh

3 months ago

Selected Answer: D

D - Disable automated patching in SQL Iaas Agent extension

upvoted 1 times

...

voodoo_sh

5 months, 1 week ago

D - Set Automated patching to disable To automate the deployment of cumulative updates to SQL Server using Azure Update Manager, while ensuring that SQLVM1 can still be managed via the Azure portal, you should first disable Automated Patching. This is necessary because using both Automated Patching and Azure Update Manager simultaneously can lead to conflicts and unexpected behavior

upvoted 2 times

...

2f5c7cd

5 months, 3 weeks ago

Selected Answer: D

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/automated-patching?view=azuresql Choose only one option to automatically update your VM as overlapping tools may lead to failed updates.

upvoted 1 times

...

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 5 question 34 discussion

Comments

voodoo_sh

voodoo_sh

2f5c7cd

SY0-701