nerdexam
MicrosoftMicrosoft

DP-300 · Question #300

DP-300 Question #300: Real Exam Question with Answer & Explanation

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. https://learn.microsoft.com/en-us/azure/azure-sql/virtu

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

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 PracticeBrowse All DP-300 Questions