AZ-305 ยท Relational data design
Provisioned vs serverless compute, and elastic pools
Provisioned vs serverless compute (auto-pause, auto-scale, billing per second), elastic pools for many databases with variable usage.
Key points
- Provisioned: fixed compute, billed per hour; steady, higher usage.
- Serverless (vCore; General Purpose, Hyperscale): autoscales min to max vCores, billed per second.
- Auto-pause: 15 min to 7 days (General Purpose), -1 disables; then only storage billed; login resumes.
- Serverless: higher vCore price, no Azure Hybrid Benefit.
- Elastic pool: databases on one logical server share eDTUs or vCores; low average use, spikes at different times.
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview
Practice questions
How is compute billed in the serverless compute tier of Azure SQL Database?
- Per hour for the maximum vCores configured
- Per second for the compute actually used
- Per day for the DTUs allocated
- Per query executed against the database
Show answer
Answer: B. Per second for the compute actually used
Serverless bills for the compute actually used, per second, between the configured minimum and maximum vCores, and charges no compute while paused. Provisioned compute is the one billed per hour for the capacity you allocate, whether you use it or not.
Which statements about the serverless compute tier of Azure SQL Database are correct?
- It is available in the General Purpose and Hyperscale tiers
- It is available in the Business Critical tier
- While paused, only storage is billed
- It can be used with the DTU purchasing model
- Compute is billed per hour at a fixed rate
Show answer
Answer: A. It is available in the General Purpose and Hyperscale tiers, C. While paused, only storage is billed
Serverless is offered in the General Purpose and Hyperscale tiers, and while a database is paused its compute cost is zero, so only storage is billed. It is not available in Business Critical, is not part of the DTU model, and bills compute per second rather than per hour.
For the same number of vCores running all the time, serverless compute is cheaper than provisioned compute.
Show answer
Answer: False
False. The vCore unit price is lower in the provisioned tier than in serverless. Serverless saves money only when usage is intermittent, so the database scales down or pauses for long periods. A busy database that runs flat out 24/7 is usually cheaper on provisioned compute.
Practice 8 questions on this topic in Bitzu
Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.
