Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
You are designing the data tier for a SaaS application that processes financial transactions per minute. The workload currently runs on a single Azure SQL Database in West Europe. Business requirements are: the database must come back online within 60 seconds during any unplanned outage; if the entire West Europe region is lost, the application must continue from North Europe with an RPO of under five seconds; and the operations team must not manage operating systems or database software. Which solution best meets these requirements?
Migrate to Azure SQL Managed Instance (Business Critical) and configure an auto-failover group between West Europe and North Europe.
Configure an Azure SQL Database in the Business Critical tier with zone redundancy enabled in West Europe.
Deploy SQL Server 2022 on two Azure virtual machines in different availability zones in West Europe and configure Always On availability groups.
Upgrade to Azure SQL Database Premium tier and create an active geo-replica in North Europe; perform manual failover when needed.
Azure SQL Managed Instance in the Business Critical tier combined with an auto-failover group between West Europe (primary) and North Europe (secondary) satisfies all three constraints. Within a region, the Business Critical tier uses synchronous replication and automatic failover, enabling recovery in roughly 30-60 seconds, staying inside the 60-second RTO. Cross-region replicas are updated asynchronously with an RPO target of five seconds or less, limiting data loss during a regional failure. Because SQL Managed Instance is a fully managed PaaS service, Microsoft handles operating-system and database-engine maintenance, removing operational overhead.
A zone-redundant single-region database protects only against datacenter failures; active geo-replication that lacks automatic failover relies on manual intervention, making a 60-second RTO unlikely; and SQL Server on Azure virtual machines requires OS and SQL maintenance and does not inherently provide cross-region protection.
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 Azure SQL Managed Instance Business Critical tier?
Open an interactive chat with Bash
What is an auto-failover group in Azure SQL Managed Instance?
Open an interactive chat with Bash
Why is the solution of using SQL Server on VMs with Always On availability groups incorrect?
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 .