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…

Question

Options

• AEnable a system-assigned managed identity for VM1
• BRegister VM1 to the Microsoft.Sql resource provider
• CInstall an Azure virtual machine Desired State Configuration (DSC) extension on VM1
• DRegister VM1 to the Microsoft.SqlVirtualMachine resource provider

• A
  4% (1)
• B
  7% (2)
• C
  19% (5)
• D
  70% (19)

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. To utilize the SQL IaaS Agent extension, you must first register your subscription with the Microsoft.SqlVirtualMachine provider, which gives the SQL IaaS extension the ability to create resources within that specific subscription. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-iaas- agent-extension-automate-management https://docs.microsoft.com/en-us/azure/azure-sql/virtual- machines/windows/sql-agent-extension-manually-register-single-vm?tabs=bash%2Cazure-cli

No community discussion yet for this question.