ExpertMedium1 markMultiple Choice
AZ-305 · Question 17 · Domain 2.1: Relational Data Storage
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)
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)
Answer options:
A.
Auto-failover groups
B.
Active geo-replication
C.
Zone-redundant configuration
D.
Azure Traffic Manager
E.
Always Encrypted
How to approach this question
Identify the SQL DB features that provide cross-region replication and automatic endpoint management.
Full Answer
Auto-failover groups, Active geo-replication
To meet the requirements, you need Auto-failover groups. This feature builds on top of Active geo-replication. Active geo-replication provides the readable secondary database for reporting. Auto-failover groups provide the automatic failover capability and read/write listener endpoints (e.g., failover-group-name.database.windows.net) so the application connection string remains unchanged during a regional failover.
Common mistakes
Thinking Active geo-replication alone is enough. Active geo-replication requires manual failover and connection string updates unless combined with Auto-failover groups.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 2
55 questions · hints · full answers · grading
More questions from this exam
Q01Fabrikam Inc. is a global financial services company with 200 Azure subscriptions managed via a c...HardQ02A healthcare organization has 500 on-premises Windows Server VMs and 300 Azure VMs. They are impl...HardQ03You are designing a security monitoring solution using Microsoft Sentinel.
The compliance depar...EasyQ04Your company has a microservices application deployed across multiple Azure App Service instances...MediumQ05A defense contractor is migrating to Microsoft 365 and Azure. They have a strict security policy ...Hard