dp-300 Practice Question 2011
Exam: dp-300
Domain: Plan and implement High Availability and Disaster Recovery
Topic: Recommend an HADR strategy
Difficulty: medium
Your company operates a global application with a primary SQL Server database in the US East region and a secondary database in the Europe West region. The primary database is experiencing high read traffic, and you need to ensure that the secondary database can take over as the primary in case of a failure in the US East region. Which HADR strategy should you recommend to meet these requirements?
Answer Options
A
Active Geo-Replication
B
Failover Groups
C
Automated Point-in-Time Restore
D
Long-term Retention
Correct Answer
B: Failover Groups
Explanation
Failover groups allow you to create a group of databases that can fail over to each other in case of a failure, ensuring high availability and disaster recovery. Active Geo-Replication provides a way to replicate data between regions but does not support automatic failover. Automated Point-in-Time Restore (PITR) allows you to restore a database to a specific point in time but does not provide a failover mechanism. Long-term Retention (LTR) is used for archiving data and does not support failover or replication.