ExpertMedium1 markMultiple Choice
AZ-305 · Question 19 · Domain 2.1: Relational Data Storage
You are designing the high availability architecture for a mission-critical application backed by Azure SQL Database.
The application requires:
- Automatic failover to a secondary region if the primary region goes down.
- The application connection string must NOT require updating after a failover occurs.
- Multiple databases must fail over together simultaneously.
Which feature should you implement?
You are designing the high availability architecture for a mission-critical application backed by Azure SQL Database.
The application requires:
- Automatic failover to a secondary region if the primary region goes down.
- The application connection string must NOT require updating after a failover occurs.
- Multiple databases must fail over together simultaneously.
Which feature should you implement?
Answer options:
A.
Active Geo-Replication
B.
Auto-failover groups
C.
Zone-redundant configuration
D.
Azure Traffic Manager with SQL Data Sync
How to approach this question
Look for the feature that groups databases and provides a static listener endpoint for automatic cross-region failover.
Full Answer
B.Auto-failover groups✓ Correct
Auto-failover groups allow you to manage the replication and failover of a group of databases on a server or all databases in a managed instance to another region. It provides a static read-write listener endpoint. When a failover occurs, DNS is automatically updated to point the listener to the secondary region, meaning application connection strings do not need to change.
Common mistakes
Confusing Active Geo-Replication with Auto-failover groups. Geo-replication is per-database and requires connection string management.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 3
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd is a global manufacturing company with 50,000 employees across 30 countries. They cur...MediumQ02Fabrikam Inc. is a Managed Service Provider (MSP) managing Azure environments for 50 different en...HardQ03A financial institution generates 5 TB of telemetry and audit logs daily across its Azure environ...MediumQ04A retail company has recently migrated several workloads to Azure. The IT Director wants a centra...EasyQ05A healthcare organization with 10,000 employees uses on-premises Active Directory. They are migra...Hard