A line-of-business application consists of a web/API tier on Azure App Service and a data tier on Azure SQL Database. The business requires an RPO of 5 minutes and an RTO of 15 minutes in case of a regional outage. What should you implement to meet these objectives?
Choose an answer
Tap an option to check your answer.
Correct answer: Configure an Azure SQL Database auto-failover group between two regions; deploy the App Service in both regions; front the app with Azure Front Door using health probes and automatic failover..
Why this is the answer
The correct option meets the RPO and RTO requirements. Azure SQL Database auto-failover groups provide automatic replication and failover with a 5-minute RPO and RTO typically under 60 seconds, well within the 15-minute RTO. Deploying App Service in both regions ensures application availability. Azure Front Door, with health probes and automatic failover, directs traffic to the healthy region, providing a global, highly available entry point. Incorrect options: Azure Backup with hourly backups would not meet the 5-minute RPO. Restoring App Service and database on demand would exceed the 15-minute RTO. Azure Site Recovery does not directly support Azure App Service or Azure SQL Database for replication in this manner. Manual active geo-replication for SQL Database requires manual failover, which would likely exceed the 15-minute RTO. Azure Traffic Manager provides DNS-based routing but doesn't handle the database failover itself. Availability Zones protect against datacenter failures within a region, but not against a complete regional outage, which is specified in the requirement.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed