AZ-305 ยท Relational data design
SQL Database purchasing models and vCore service tiers
DTU vs vCore models, General Purpose vs Business Critical vs Hyperscale tiers (storage architecture, latency, HA replicas, max size), Azure Hybrid Benefit.
Key points
- DTU: blended unit in preconfigured bundles; no Azure Hybrid Benefit or reservations.
- vCore (recommended): compute and storage chosen separately; both apply.
- General Purpose: remote Azure Blob storage, 5-10 ms, up to 4 TB, no read replica.
- Business Critical: local SSD, 1-2 ms, three HA replicas (one free for reads), 4 TB, In-Memory OLTP.
- Hyperscale: up to 128 TB, 0-4 HA replicas, billed for allocated storage; no AHB for new databases.
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore
Practice questions
Which Azure SQL Database purchasing model expresses performance as a single blended measure of CPU, memory, reads and writes?
- The vCore-based model
- The DTU-based model
- The serverless compute tier
- The provisioned compute tier
Show answer
Answer: B. The DTU-based model
The DTU model bundles compute, storage and I/O into database transaction units (eDTUs for elastic pools). The vCore model is the opposite approach: you pick compute and storage independently. Serverless and provisioned are compute tiers inside the vCore model, not purchasing models.
Which statements about the Hyperscale service tier of Azure SQL Database are correct?
- A database can grow up to 128 TB
- You can configure from 0 to 4 high availability replicas
- In-Memory OLTP tables are supported
- You are billed for allocated storage, not a configured maximum size
- New databases can use Azure Hybrid Benefit
Show answer
Answer: A. A database can grow up to 128 TB, B. You can configure from 0 to 4 high availability replicas, D. You are billed for allocated storage, not a configured maximum size
Hyperscale storage grows to 128 TB, you choose 0 to 4 high availability replicas, and you pay for allocated data storage rather than a configured maximum. In-memory tables are not supported in Hyperscale (they need Business Critical), and since December 2023 Azure Hybrid Benefit is not available for new Hyperscale databases.
A company with SQL Server licenses covered by Software Assurance can apply Azure Hybrid Benefit to a database in the DTU-based Standard tier.
Show answer
Answer: False
False. For Azure SQL Database, Azure Hybrid Benefit applies only to the provisioned compute tier of the vCore model. DTU databases (and serverless ones) cannot use it, so a customer who wants the license discount must move to vCore 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.
