DP-900 · Question #322
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?
The correct answer is A. Azure SQL Database. Azure SQL Database is a fully managed PaaS offering that provides built-in autoscaling via the serverless compute tier and Hyperscale service tier, requiring no infrastructure management.
Question
Options
- AAzure SQL Database
- BSQL Server on Azure Virtual Machines
- CAzure SQL Managed Instance
- DAzure SQL Edge
How the community answered
(39 responses)- A92% (36)
- B3% (1)
- C5% (2)
Why each option
Azure SQL Database is a fully managed PaaS offering that provides built-in autoscaling via the serverless compute tier and Hyperscale service tier, requiring no infrastructure management.
Azure SQL Database is a PaaS service where Microsoft manages the underlying infrastructure. Its serverless compute tier automatically scales compute resources up and down based on workload demand, and the Hyperscale tier provides automatic storage scaling - both without manual intervention or downtime.
SQL Server on Azure Virtual Machines is an IaaS offering, not PaaS; the customer manages the OS and SQL Server instance and must configure autoscaling manually.
Azure SQL Managed Instance is a PaaS service but is designed for near-100% SQL Server compatibility for lift-and-shift migrations and does not offer the same serverless autoscaling capability as Azure SQL Database.
Azure SQL Edge is a lightweight relational engine optimized for IoT and edge computing scenarios, not a general-purpose cloud PaaS database with built-in autoscaling.
Concept tested: Azure SQL Database PaaS autoscaling
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview
Topics
Community Discussion
No community discussion yet for this question.