DP-300 Certification Practice Question #209

Question

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?

Accepted Answer

To migrate the patching of SQL Server on Azure VMs to Azure Update Manager, you must disable the older Automated Patching feature managed by the SQL Server IaaS Agent extension. Running both patching mechanisms simultaneously can cause update failures, unexpected restarts, and scheduling conflicts. Disabling Automated Patching (Option D) preserves the IaaS Agent extension itself, which is required to manage the SQL Server instance via the Azure portal.

More DP-300 practice questions