Bitzu

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

Single choice

How is compute billed in the serverless compute tier of Azure SQL Database?

  1. Per hour for the maximum vCores configured
  2. Per second for the compute actually used
  3. Per day for the DTUs allocated
  4. 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.

Select all that apply

Which statements about the serverless compute tier of Azure SQL Database are correct?

  1. It is available in the General Purpose and Hyperscale tiers
  2. It is available in the Business Critical tier
  3. While paused, only storage is billed
  4. It can be used with the DTU purchasing model
  5. 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.

True or false

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.

Download on the App StoreGet it on Google Play

More AZ-305 topics in this module