Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 5 question 23 discussion

Actual exam question from Microsoft's DP-300

Question #: 23
Topic #: 5

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?

A. full
B. lightweight
C. NoAgent

Show Suggested Answer

Suggested Answer: A 🗳️

by licna at Jan. 30, 2023, 7:44 a.m.

Comments

Submit Cancel

KIET2131

Highly Voted 1 year, 2 months ago

B. lightweight

upvoted 6 times

...

Hgreg

Highly Voted 9 months ago

It seems that this question is now obsolete. Since April 2023 there are no management modes for the agent. "Going forward, customers register with the SQL IaaS Agent extension and enable the required features they would like for their SQL Server on Azure virtual machines. Based on the features selected, the SQL IaaS agent extension would assume only the permissions required on the SQL Server to enable those features. " Source: https://techcommunity.microsoft.com/t5/sql-server-blog/announcement-new-features-and-changes-to-sql-iaas-agent/ba-p/3791548

upvoted 5 times

voodoo_sh

3 months, 4 weeks ago

The management modes (full, lightweight) for the SQL Server IaaS Agent extension have been deprecated as of March 2023. Now, when you register the SQL Server IaaS Agent extension, you simply enable the specific features you need for your SQL Server on Azure virtual machines. This approach ensures that only the necessary permissions and services are used based on the features you select

upvoted 1 times

...

vcloudpmp

Most Recent 10 months, 2 weeks ago

Answer is correct. Lightweight mode: in this mode, the extension binary files are copied to the virtual machine, but no agent is installed and the SQL Server service running on the VM is not restarted. By adopting this mode, you can only change the type of license and the edition of SQL Server, in addition to having a limited set of management options. This is the default management mode when using the automatic registration feature which can be activated from the Azure portal or through manual registration.

upvoted 1 times

...

JG1984

1 year, 1 month ago

Selected Answer: A

https://youtu.be/ckSvoe6Ho3g

upvoted 3 times

OBIJUAN88

1 year ago

God Saves King Savill in our path through the Azure desert.

upvoted 3 times

...

louisaok

1 year, 3 months ago

Lightweight mode is recommended for the SQL Server IaaS Agent extension (SqlIaasExtension) in order to meet the requirements of automatically installing critical updates for SQL Server and minimizing performance impact on the virtual machine.

upvoted 4 times

...

licna