nerdexam
Microsoft

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.

Submitted by kevin_r· Mar 30, 2026Identify considerations for relational data on Azure

Question

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?

Options

  • AAzure SQL Database
  • BSQL Server on Azure Virtual Machines
  • CAzure SQL Managed Instance
  • DAzure SQL Edge

How the community answered

(39 responses)
  • A
    92% (36)
  • B
    3% (1)
  • C
    5% (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.

AAzure SQL DatabaseCorrect

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.

BSQL Server on Azure Virtual Machines

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.

CAzure SQL Managed Instance

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.

DAzure SQL Edge

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

#PaaS#Azure SQL Database#autoscaling#managed relational database

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice