Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
Your company runs an OLTP workload in an Azure SQL Database single database (General Purpose, 4 vCores) that stores 2 TB of data. Workload traffic can spike unpredictably, and the database must be able to add compute capacity within seconds to maintain SLAs. Forecasts show the data volume may grow beyond 50 TB within two years. Management wants the simplest option that requires minimal application changes while providing the fastest online scaling for both compute and storage. Which Azure SQL option should you recommend?
Deploy SQL Server 2022 on Azure Virtual Machines inside an availability set and use Virtual Machine Scale Sets for compute elasticity.
Move the database to an Azure SQL Database General Purpose serverless tier inside an elastic pool with auto-pause enabled.
Migrate the database to Azure SQL Managed Instance Business Critical tier and enable an auto-failover group.
Migrate the database to Azure SQL Database in the Hyperscale service tier and use its rapid scale-up and read-scale out capabilities.
Azure SQL Database Hyperscale separates compute and storage, so adding or removing compute replicas completes in seconds without downtime. Hyperscale also supports rapid storage growth up to 100 TB per database, far exceeding the 50 TB projection. Managed Instance Business Critical is limited to 16 TB and scaling compute takes minutes. SQL Server on VMs gives full control but requires significant administrative effort and scaling involves VM resizing or scale sets, both disruptive and slower. General Purpose serverless auto-scales vCores but is capped at 4 TB of storage and resuming from auto-pause can introduce latency, so it cannot meet the 50 TB requirement or the instant scale expectations.
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 Hyperscale enable rapid scaling for compute and storage?
Open an interactive chat with Bash
Why is Hyperscale a better option than Managed Instance Business Critical for this scenario?
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 .