DP-300 Certification Practice Question #122

Question

You have an Azure virtual machine based on a custom image named VM1.
VM1 hosts an instance of Microsoft SQL Server 2019 Standard.
You need to automate the maintenance of VM1 to meet the following requirements:
✑ Automate the patching of SQL Server and Windows Server.
✑ Automate full database backups and transaction log backups of the databases on VM1.
✑ Minimize administrative effort.
What should you do first?

Accepted Answer

To enable automated maintenance (automated patching and automated backups) for a SQL Server instance running on an Azure Virtual Machine, you must register the VM with the SQL IaaS Agent extension. Since VM1 was created from a custom image, the VM is not automatically registered with the extension. The prerequisite first step before registering the VM with the SQL IaaS Agent extension is to register the Azure subscription to the `Microsoft.SqlVirtualMachine` resource provider.

More DP-300 practice questions