Question 1

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?

Accepted Answer

Look for the feature that groups databases and provides a static listener endpoint for automatic cross-region failover.

Question 2

What mistakes do candidates make on this AZ-305 question?

Accepted Answer

Confusing Active Geo-Replication with Auto-failover groups. Geo-replication is per-database and requires connection string management.

How to approach this question

Full Answer

Common mistakes

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 3

More questions from this exam