Microsoft Certified: Azure Solutions Architect ExpertDesign business continuity solutionsMedium
A company is designing a highly available solution for a critical web application. The application consists of stateless web servers and a stateful database. The web servers are deployed across multiple Azure regions using Azure Front Door for global traffic distribution. The database is an Azure SQL Database. To ensure high availability for the database with automatic failover across regions, which Azure SQL Database feature should be implemented?
- APoint-in-time restore
- BActive geo-replication
- CZone-redundant configuration
- DAutomated backups
Show answer & explanationAnswer & explanation
Correct answer: B. Active geo-replication
Active geo-replication for Azure SQL Database provides a continuously synchronized readable secondary database in a different Azure region, enabling manual or automatic failover for regional disaster recovery.
Why the other options are wrong
- A. Point-in-time restore is a recovery feature for restoring a database to a specific point in time, not for real-time cross-region high availability and automatic failover.
- C. Zone-redundant configuration provides high availability within a single region by spreading replicas across Availability Zones, not across regions.
- D. Automated backups are for data recovery and retention, not for continuous cross-region synchronization and automatic failover for high availability.
Azure SQL Database Active Geo-replication
A feature that allows you to create up to four readable secondary databases in different Azure regions for disaster recovery and global distribution.
- Provides continuous asynchronous replication of transactions.
- Supports manual or automatic failover via failover groups.
- Secondaries are readable, enabling offloading read workloads.
Memory trick: Globally Syncing Data Keeps SQL Always Alive.