Administering Relational Databases on Microsoft Azure — Question 14

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?

Answer options

• A. Enable a system-assigned managed identity for VM1
• B. Register the Azure subscription to the Microsoft.Sql resource provider
• C. Install an Azure virtual machine Desired State Configuration (DSC) extension on VM1
• D. Register the Azure subscription to the Microsoft.SqlVirtualMachine resource provider

Correct answer: D

Explanation

The correct answer is D because registering the Azure subscription with the Microsoft.SqlVirtualMachine resource provider is essential for enabling the management of SQL Server on Azure virtual machines, which includes automation features. Options A, B, and C do not directly provide the necessary capabilities for automating SQL Server maintenance tasks on VM1.