dp-300 Practice Question 2012
Exam: dp-300
Domain: Plan and implement High Availability and Disaster Recovery
Topic: Recommend an HADR strategy
Difficulty: medium
Your organization has a SQL Server database in the Azure environment that needs to maintain data consistency across multiple regions to ensure business continuity. You want to implement a solution that can replicate data from the primary region to a secondary region and automatically recover the secondary region if the primary fails. Which HADR strategy would you recommend?
Answer Options
A
Failover Groups
B
Active Geo-Replication
C
Automated Point-in-Time Restore
D
Long-term Retention
Correct Answer
B: Active Geo-Replication
Explanation
Active Geo-Replication is designed to replicate data between Azure regions and supports automatic failover in case of a failure in the primary region. Failover groups are not suitable for cross-region replication, PITR is for restoring to a specific point in time, and LTR is for long-term data retention and does not support failover or replication.