ExpertMedium1 markMultiple Choice
Domain 2.1: Design a data storage solution for relational dataDomain 2Relational DataAzure SQLDisaster Recovery
AZ-305 · Question 17 · Domain 2.1: Design a data storage solution for relational data
You are designing the disaster recovery strategy for a mission-critical application backed by Azure SQL Database.
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 regional outage, the database failover must happen automatically without requiring application connection strings to be updated.
Which feature should you implement?
You are designing the disaster recovery strategy for a mission-critical application backed by Azure SQL Database.
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 regional outage, the database failover must happen automatically without requiring application connection strings to be updated.
Which feature should you implement?
Answer options:
A.
Auto-failover groups
B.
Active geo-replication
C.
Zone-redundant configuration
D.
Geo-restore from backups
How to approach this question
Identify the requirement for 'automatic failover' and 'no connection string updates'. Auto-failover groups provide listener endpoints that abstract the underlying primary/secondary roles.
Full Answer
A.Auto-failover groups✓ Correct
Auto-failover groups
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. They provide read-write and read-only listener endpoints that remain unchanged during failover. This means your application does not need to change its connection string after a failover. Active geo-replication requires manual failover and connection string updates.
Common mistakes
Confusing Active geo-replication with Auto-failover groups. Geo-replication is database-level and manual; Failover groups are server-level and automatic.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 1
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd is a global financial institution with 80 Azure subscriptions spread across 4 managem...MediumQ02Fabrikam Inc. operates a hybrid cloud environment with 500 on-premises VMware virtual machines ru...HardQ03A startup company has a single Azure subscription with a monthly budget of $5,000.
The CFO want...EasyQ04You are designing an Azure Sentinel architecture for a Managed Security Service Provider (MSSP). ...MediumQ05A healthcare enterprise is migrating its infrastructure to Azure. They have strict compliance req...Hard