exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 301 discussion

Actual exam question from Microsoft's DP-900
Question #: 37
Topic #: 1
[All DP-900 Questions]

You need to implement an Azure platform as a service (PaaS) service that will host a relational database. The solution must support built-in autoscaling.

Which service should you implement?

  • A. Azure SQL Database
  • B. SQL Server on Azure Virtual Machines
  • C. Azure SQL Managed Instance
  • D. Azure SQL Edge
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
man5484
3 months, 1 week ago
Selected Answer: A
Azure SQL Database Correct. Azure SQL Database is a fully managed Platform as a Service (PaaS) offering for hosting relational databases. It supports built-in autoscaling to automatically adjust compute resources based on demand, making it ideal for dynamic workloads. SQL Server on Azure Virtual Machines Incorrect. This is an Infrastructure as a Service (IaaS) option where you have to manage the underlying virtual machine, database software, and scaling manually. Azure SQL Managed Instance Incorrect. While Managed Instance is a PaaS service, it does not natively support autoscaling in the same way as Azure SQL Database. You must adjust resources manually. Azure SQL Edge Incorrect. This is a lightweight database engine designed for IoT and edge computing scenarios, not for autoscaling relational database hosting.
upvoted 1 times
...
MAKI911
7 months ago
Selected Answer: A
A. Azure SQL Database the reason: Azure SQL Database is a relational database-as-a-service PaaS from Microsoft Azure, and it supports the autoscaling feature that allows system resources to be automatically scaled based on load.
upvoted 4 times
...
gaurav3010
8 months, 2 weeks ago
Selected Answer: A
Azure SQL Database
upvoted 2 times
...
TKC_2023
8 months, 2 weeks ago
Selected Answer: A
Azure SQL Database
upvoted 1 times
...
TKC_2023
8 months, 2 weeks ago
Azure SQL Database
upvoted 1 times
...
Jeevi0905
9 months ago
The answer is Azure SQL Database
upvoted 1 times
...
Nilesh_Desai
11 months, 2 weeks ago
A. There is no direct auto-scaling of Azure SQL Managed Instance. For auto-scaling the Azure SQL Managed Instance we can use the PowerShell scripts.
upvoted 1 times
...
chahay
11 months, 2 weeks ago
Selected Answer: A
I think it's A
upvoted 2 times
...
subhayu.biswas12
11 months, 2 weeks ago
A. Azure SQL Database is correct answer. PaaS + Relational DBaaS = Azure SQL Database.
upvoted 2 times
...
Selected Answer: A
I think it's A: Azure SQL Database
upvoted 4 times
...
jeevanss
1 year ago
Option B is wrong as its IAAS. For PAAS - Option A is correct.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago