nerdexam
Microsoft

DP-300 · Question #300

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…

The correct answer is A. full. Full mode installs the SQL IaaS Agent to the VM to deliver full functionality. Use it for managing a SQL Server VM with a single instance. Full mode installs two Windows services that have a minimal impact to memory and CPU…

Submitted by daniela_cl· Mar 6, 2026Plan and implement data platform resources

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?

Options

  • Afull
  • Blightweight
  • CNoAgent

How the community answered

(30 responses)
  • A
    93% (28)
  • B
    3% (1)
  • C
    3% (1)

Explanation

Full mode installs the SQL IaaS Agent to the VM to deliver full functionality. Use it for managing a SQL Server VM with a single instance. Full mode installs two Windows services that have a minimal impact to memory and CPU. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-iaas- agent-extension-automate-management?view=azuresql&tabs=azure-powershell#management-

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice