Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
You are planning the migration of a multi-tenant SaaS application that currently runs on SQL Server 2016 Always On availability groups in your datacenter. Each tenant database is 20 GB today but could grow to 100 TB within a few years. The target service must allow up to four online readable replicas, automatically scale storage without redeployment, and retain backups for 35 days with minimal administration. Which Azure SQL deployment option should you recommend to meet these requirements?
SQL Server 2022 deployed on an Azure Virtual Machine with managed disks
Azure SQL Database elastic pool in the General Purpose tier
Azure SQL Database Hyperscale is a PaaS service that automatically expands storage up to 100 TB without requiring migration to another tier. It supports adding or removing up to four geo-replicas (and many more named replicas) online for read scale-out and high availability. The service is fully managed-Azure handles patching and OS maintenance-and includes 35-day point-in-time restore retention by default. Managed Instance and elastic pools have lower per-database size limits, while SQL Server on VMs leaves infrastructure administration and backups to you.
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?
Open an interactive chat with Bash
How does Azure SQL Database Hyperscale scale storage automatically?
Open an interactive chat with Bash
What are geo-replicas in Azure SQL Database Hyperscale?
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 .