Question 1

You are designing a disaster recovery solution for a mission-critical application backed by Azure SQL Database.

The requirements are:
- The database must automatically fail over to a secondary region if the primary region experiences an outage.
- The application connection string must NOT need to be updated after a failover.
- You must be able to offload read-only reporting queries to the secondary region.

Which TWO features must you configure? (Select TWO)

Accepted Answer

Identify the SQL DB features that provide cross-region replication and automatic endpoint management.

Question 2

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

Accepted Answer

Thinking Active geo-replication alone is enough. Active geo-replication requires manual failover and connection string updates unless combined with Auto-failover groups.

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam