Exam DP-300 topic 3 question 8 discussion

Actual exam question from Microsoft's DP-300

Question #: 8
Topic #: 3

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 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

Show Suggested Answer

Suggested Answer: D 🗳️
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.
Reference:
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

by learnazureportal at Aug. 24, 2021, 7:53 a.m.

Comments

Submit Cancel

learnazureportal

Highly Voted 2 years, 6 months ago

correct answer. the correct link is https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-agent-extension-manually-register-single-vm?tabs=bash%2Cazure-cli

upvoted 7 times

...

jddc

Highly Voted 2 years, 3 months ago

Answer is D: https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview

upvoted 7 times

...

voodoo_sh

Most Recent 2 months, 1 week ago

Selected Answer: D

When you deploy a SQL Server VM from the Azure Marketplace, your subscription is automatically registered with the Microsoft.SqlVirtualMachine resource provider. This automatic registration ensures that the SQL IaaS Agent extension is enabled, allowing you to manage SQL Server features like automated patching and backups. However, if you deploy a VM and then manually install SQL Server, you will need to register the SQL IaaS Agent extension manually.

upvoted 1 times

...

igorclapa

6 months ago

To register your SQL Server VM with the extension, you'll need: An Azure subscription. An Azure Resource Model supported Windows Server virtual machine with a supported SQL Server version deployed to the public or Azure Government cloud. The client credentials used to register the virtual machine exists in any of the following Azure roles: Virtual Machine contributor, Contributor, or Owner. The latest version of Azure CLI or Azure PowerShell (5.0 minimum). A minimum of .NET Framework 4.5.1 or later. To verify that none of the limitations apply to you. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-agent-extension-manually-register-single-vm?view=azuresql&tabs=azure-portal

upvoted 1 times

...

louisaok

1 year, 1 month ago

To register your SQL Server VM with the SQL IaaS Agent extension, you must first register your subscription with the Microsoft.SqlVirtualMachine resource provider (RP).

upvoted 2 times

...

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam