Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
You are designing a new relational data tier for a multi-tenant SaaS application running in Azure. The workload is read-heavy, experiences unpredictable spikes, and is forecast to grow from 1 TB today to more than 15 TB over the next 18 months. The solution must allow rapid, non-blocking compute scale-out for reporting queries and must let you increase storage capacity on demand without lengthy migrations. Which Azure SQL deployment option meets the requirements?
Use an Azure SQL Managed Instance in the Business Critical tier with read-scale-out enabled.
Deploy a single Azure SQL Database in the Hyperscale service tier.
Deploy a single Azure SQL Database in the Premium tier and configure active geo-replication.
Place the database in an Azure SQL elastic pool using the General Purpose serverless tier.
Azure SQL Database in the Hyperscale service tier is purpose-built for very large and quickly growing databases. Hyperscale supports up to 100 TB of storage that expands automatically as data is inserted, so no manual size-increase operations or data migrations are required. It can provision as many as 30 named read-scale replicas, which can be added or removed in minutes to provide rapid, non-blocking compute scale-out for read-intensive workloads. General Purpose serverless tops out at 4 TB and offers no read replicas. Managed Instance Business Critical provides only a single built-in read-only replica and allows a maximum of 8 TB per database. The Premium tier of single databases is limited to 4 TB (and uses geo-replication primarily for DR, not fast scale-out) and therefore cannot accommodate growth beyond 15 TB. Consequently, Hyperscale is the only option that satisfies both the storage and read-scale requirements.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Azure SQL Database Hyperscale tier?
Open an interactive chat with Bash
How do read-scale replicas work in Hyperscale?
Open an interactive chat with Bash
Why is Hyperscale better for large databases compared to other Azure SQL tiers?
Open an interactive chat with Bash
Microsoft Azure Solutions Architect Expert AZ-305
Design data storage solutions
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .