Question 1

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

The business requires an RPO (Recovery Point Objective) of less than 5 seconds and an RTO (Recovery Time Objective) of less than 1 hour. In the event of a primary region failure, the database failover must happen automatically without requiring connection string changes in the application code.

Which TWO features must you configure? (Select TWO)

Accepted Answer

Look for the SQL feature that provides automatic regional failover and abstracts the connection string.

Question 2

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

Accepted Answer

Selecting Active geo-replication. While it replicates data, it requires manual failover and the application must be updated to point to the new server name.

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam