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.
Question
Options
- AAzure SQL Database Hyperscale
- BAzure SQL managed instance
- CAzure SQL Database serveless
- DAzure SQL Database elastic pod
How the community answered
(29 responses)- A3% (1)
- B86% (25)
- C7% (2)
- D3% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.