DP-300 Certification Practice Question #200

Question

You have an Azure subscription.

You plan to deploy an instance of SQL Server on Azure Virtual Machines by using an Azure Marketplace image.

You need to register the SQL Server IaaS Agent extension (SqlIaasExtension). The solution must meet the following requirements:

•	Install critical updates for SQL Server automatically.
•	Minimize performance impact on the virtual machine.

Which management mode should you select?

Accepted Answer

The key requirement is "install critical updates for SQL Server automatically," which is the **Automated Patching** feature. Per MS Learn, Automated Patching **requires the SQL IaaS Agent extension to be installed** (Full mode). Lightweight mode copies extension binaries but does NOT install the agent, meaning automated patching is unavailable in that mode. Full mode installs two lightweight Windows services with minimal performance impact, which satisfies "minimize performance impact." While some commenters note that management modes were deprecated in 2023, given the exam context the answer based on the documented modes is **A — Full**. Note: if the question is encountered in a current exam, the answer should reference feature-based configuration rather than modes.

More DP-300 practice questions