ExpertMedium1 markMultiple Choice
AZ-305 · Question 18 · Domain 2.1: Relational Data Storage
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)
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)
Answer options:
A.
Active geo-replication
B.
Auto-failover groups
C.
Read-write listener endpoint
D.
Azure Traffic Manager
E.
Zone-redundant configuration
How to approach this question
Look for the SQL feature that provides automatic regional failover and abstracts the connection string.
Full Answer
To achieve automatic failover across regions for Azure SQL Managed Instance without changing application connection strings, you must use Auto-failover groups. This feature abstracts the primary and secondary instances behind a read-write listener endpoint. The application connects to this listener. If the primary region goes down, Azure automatically fails over to the secondary region and updates the listener's DNS to point to the new primary, requiring no code changes.
Common mistakes
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.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 5
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd has 50 subscriptions across 3 business units. Each business unit manages its own IT o...EasyQ02You are designing a monitoring solution for a hybrid environment. The environment consists of 200...MediumQ03Your company uses Microsoft Sentinel integrated with a Log Analytics workspace. The workspace ing...HardQ04You are designing an application monitoring strategy using Application Insights. The application ...MediumQ05A highly regulated financial institution is migrating to Microsoft 365 and Azure. They currently ...Hard