A team wants to migrate a large on-premises SQL Server database to Azure and needs a very large database with rapid on-demand scaling up to about 100 TB. Which Azure SQL Database service tier should it consider?
- ABasic (DTU)
- BAn elastic pool of small databases
- CHyperscale
- DServerless
The Hyperscale service tier of Azure SQL Database supports very large databases up to about 100 TB with rapid on-demand scaling and fast backup and restore. Basic is small, elastic pools share resources, and serverless targets intermittent use.
Why each option is right or wrong.
- C (correct). The Hyperscale service tier supports very large databases up to about 100 TB with rapid on-demand scaling and fast backups.
- A. The Basic DTU tier is a small, low-cost bundle, not suited to very large databases.
- B. An elastic pool shares resources across many databases but does not by itself provide the Hyperscale very-large-database architecture.
- D. Serverless auto-scales and auto-pauses compute for intermittent use, not specifically very large databases.
Reference: Azure SQL Database, Hyperscale; DP-900 Domain 2 (Relational data on Azure).