Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
You administer a business-critical line-of-business application that uses an Azure SQL Database single database deployed in the General Purpose tier (Gen5) in the East US region. Management requires the database to remain available even if any one Azure datacenter in East US becomes unavailable. The recovery point objective is zero and failover must occur automatically within seconds. You want the simplest solution with the least additional management effort or licensing cost. What should you do?
Configure active geo-replication to a secondary database in West US and enable automatic failover.
Upgrade the database to the Business Critical service tier and enable zone-redundant configuration for the database.
Switch the database to the serverless compute tier and enable auto-pause with minimum capacity.
Migrate the workload to SQL Server on two Azure virtual machines in an availability set and configure an Always On availability group.
Enabling zone redundancy on a Business Critical (or Premium) tier Azure SQL Database keeps multiple synchronous replicas across three separate availability zones within the same region. If any single datacenter (zone) fails, the service automatically fails over to a healthy replica in another zone within seconds, meeting an RPO of zero and very low RTO. Moving to the Business Critical tier is required because the General Purpose tier does not support zone-redundant replicas or automatic in-region failover. Active geo-replication and auto-failover groups protect primarily against regional outages and use asynchronous replication, which risks data loss and higher latency; they do not guarantee intra-region resiliency. Deploying SQL Server on VMs with an availability set would add significant management overhead and still not protect against a zone-level outage. Serverless auto-pause provides cost savings for idle periods but offers no high-availability benefits. Therefore, upgrading the database to Business Critical and enabling zone redundancy is the best choice.
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 the difference between General Purpose and Business Critical tiers in Azure SQL Database?
Open an interactive chat with Bash
What is zone redundancy in Azure SQL Database?
Open an interactive chat with Bash
Why is active geo-replication not suitable for intra-region high availability?
Open an interactive chat with Bash
Microsoft Azure Solutions Architect Expert AZ-305
Design business continuity 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 .