Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Go to Exam

Exam DP-900 topic 1 question 54 discussion

Actual exam question from Microsoft's DP-900

Question #: 54
Topic #: 1

[All DP-900 Questions]

HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:

Show Suggested Answer

Suggested Answer:

SQL Server on Azure VM -
SQL Server on Azure VM falls into the industry category Infrastructure-as-a-Service (IaaS) and allows you to run SQL Server inside a fully managed virtual machine (VM) in Azure.
The most significant difference from SQL Database and SQL Managed Instance is that SQL Server on Azure Virtual Machines allows full control over the database engine. You can choose when to start maintenance/patching, change the recovery model to simple or bulk-logged, pause or start the service when needed, and you can fully customize the SQL Server database engine. With this additional control comes the added responsibility to manage the virtual machine.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql

by fusioner at Sept. 3, 2022, 4:55 a.m.

Comments

Submit Cancel

AndreLima

Highly Voted 2 years ago

Said VM, said IAAS.

upvoted 25 times

...

PatYeo

Highly Voted 2 years ago

d is correct. In Iaas, you need to manage the VM and OS.

upvoted 9 times

...

AGTraining

Most Recent 7 months, 4 weeks ago

virtual m

upvoted 1 times

...

akhil5432

1 year, 2 months ago

IN IAAS WE MANAGE virtual machine

upvoted 1 times

...

chiiiweiii

1 year, 7 months ago

Correct Answer

upvoted 3 times

...

Dewonnaluv

1 year, 10 months ago

This also validates the community answer to an earlier question that assigned this as Software as a service(SaaS)

upvoted 2 times

...

Anumani

2 years, 1 month ago

d is correct

upvoted 4 times

...