Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Azure SQL Database Hyperscale is engineered for very large databases-supporting up to 128 TB-and separates compute from storage so that compute replicas can be scaled up or down in minutes without requiring downtime or application changes. It also lets you provision up to 30 named read-only replicas that automatically replicate from the primary node, enabling you to off-load intensive read workloads during traffic surges. Business Critical on Azure SQL Managed Instance and Premium elastic pools are limited to much smaller storage capacities and require longer maintenance windows when scaling. The serverless tier is restricted to the General Purpose and Hyperscale tiers, but it does not provide built-in read-scale replicas and has lower maximum storage limits in General Purpose, so it cannot meet the 70 TB target or read-scaling requirement. Therefore, Hyperscale is the only option that satisfies all scalability and availability needs with minimal operational overhead.