AZ-305 Azure SQL Database failover groups Practice Question
Which TWO actions should you take to ensure business continuity for an Azure App Service web app that uses Azure SQL Database? (Choose two.)
⚠ Common exam trap
The trap is selecting options that provide high availability within a single region (like auto-healing) or backup/restore (geo-restore) instead of true cross-region redundancy with automatic failover, which is required for business continuity.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Configure Azure SQL Database failover groups with automatic failover.
Option A is correct because Azure SQL Database failover groups provide automatic geo-failover of the database to a secondary region, ensuring the data tier remains available during a regional outage without manual intervention. Option C is correct because deploying the App Service app in two regions, each with its own App Service plan, and using Azure Traffic Manager for global traffic distribution provides a multi-region, highly available web tier that can route users to a healthy region if one fails. Option B is not correct because auto-healing and retry logic only address transient application-level faults, not regional or infrastructure-level failures required for business continuity. Option D is not correct because Azure Front Door with a single App Service instance still leaves a single point of failure in one region. Option E is not correct because Azure Backup and geo-restore are for data recovery/restore scenarios, not continuous availability or automatic failover.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Configure Azure SQL Database failover groups with automatic failover.
Why this is correct
Failover groups with automatic failover replicate Azure SQL Database to a paired secondary region and provide a listener endpoint, so the database recovers without manual intervention. This addresses the data-tier continuity requirement of the business continuity scenario.
- ✗
Enable auto-healing in the App Service and modify the application code to handle retries.
Why it's wrong here
Auto-healing and retry logic are for transient failures, not regional outages.
- ✓
Deploy the App Service app in two regions using separate App Service plans and use Azure Traffic Manager for global traffic distribution.
Why this is correct
Deploying the App Service plan across two regions with Traffic Manager provides geographic redundancy, so the web app survives a regional outage. Traffic Manager routes users to the healthy region, satisfying the business continuity requirement for the compute tier, though the database tier still needs separate resilience.
- ✗
Use Azure Front Door with a single App Service instance.
Why it's wrong here
Single instance does not provide regional redundancy.
- ✗
Configure Azure Backup for the App Service and enable geo-restore.
Why it's wrong here
Backup is for data recovery, not automated failover.
Go deeper
Related to this question
About these practice questions
Courseiva writes every AZ-305 question from scratch — 795 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This AZ-305 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AZ-305 exam.