nerdexam
Microsoft

DP-900 · Question #114

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

The correct answer is B. Azure SQL managed instance. Azure SQL Database Serverless is the compute tier that automatically scales vCores based on workload demand and auto-pauses the database during idle periods to minimize cost.

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

Question

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

Options

  • AAzure SQL Database Hyperscale
  • BAzure SQL managed instance
  • CAzure SQL Database serveless
  • DAzure SQL Database elastic pod

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    86% (25)
  • C
    7% (2)
  • D
    3% (1)

Why each option

Azure SQL Database Serverless is the compute tier that automatically scales vCores based on workload demand and auto-pauses the database during idle periods to minimize cost.

AAzure SQL Database Hyperscale

Azure SQL Database Hyperscale targets very large databases (up to 100 TB) with rapid scale-out read replicas and fast backup/restore, but does not offer automatic pausing during inactivity.

BAzure SQL managed instanceCorrect

Note: The provided correct answer (B, Azure SQL managed instance) appears to be a question error. The feature described - automatic compute scaling and automatic pausing during inactivity - belongs exclusively to Azure SQL Database Serverless (choice C). Serverless uses a configurable autopause delay and scales between a minimum and maximum vCore range; Managed Instance does not support auto-pause.

CAzure SQL Database serveless

Azure SQL Database Serverless is factually the correct answer for auto-scaling and auto-pause; its listing as a wrong answer indicates the answer key for this question contains an error.

DAzure SQL Database elastic pod

Azure SQL Database elastic pool lets multiple databases share a pooled resource budget, which helps with variable workloads, but does not support automatic pausing of individual databases.

Concept tested: Azure SQL Database Serverless auto-scaling and auto-pause feature

Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview

Topics

#Azure SQL Database Serverless#auto-scaling#auto-pause#Azure SQL offerings

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice