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?
A . Enable a system-assigned managed identity for VM1
B . Register VM1 to the Microsoft.Sql resource provider
C . Install an Azure virtual machine Desired State Configuration (DSC) extension on VM1
D . Register VM1 to the Microsoft.SqlVirtualMachine resource provider
Answer: B
Explanation:
Automated Patching depends on the SQL Server infrastructure as a service (IaaS) Agent Extension. The SQL
Server IaaS Agent Extension (SqlIaasExtension) runs on Azure virtual machines to automate administration tasks. The SQL Server IaaS extension is installed when you register your SQL Server VM with the SQL Server VM resource provider.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-iaas-agent-extensionautomate-management