Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Azure SQL Database in the Hyperscale service tier is the best fit. Hyperscale supports up to 128 TB for a single database and can add or remove compute replicas in roughly a minute because replicas share the same distributed storage layer, so no data movement is involved. It is a fully managed PaaS offering and includes automated snapshot-based backups with a configurable point-in-time restore window of 1-35 days (7 days by default).

General Purpose elastic pools are limited to 1 TB per database, so they cannot accommodate the current or projected size. Azure SQL Managed Instance Business Critical supports up to 16 TB and allows online compute scaling, but adding vCores typically takes longer than a few minutes and incurs a brief connectivity interruption; it therefore does not meet the rapid, promotion-driven burst requirement as well as Hyperscale. Running SQL Server on an Azure VM could provide the required capacity, but it is an IaaS solution that lacks the fully managed PaaS benefits the scenario requires.