Home » Microsoft » 70-473 v.2 » Which disaster recovery solution should you implement?
You need to implement a disaster recovery solution that meets the technical requirements. The solution must NOT require customers to modify their connection strings.
Which disaster recovery solution should you implement?
A. Transactional Replication to Azure
B. AlwaysOn Availability Groups
C. Transaction Log Shipping
D. Failover cluster instances
Correct Answer: B
Explanation/Reference:
Scenario: Technical requirements
Relecloud identifies the following technical requirements:
• If ServerDB0 and ServerDB2 fail, AzDB01 must be able to respond to customer requests for data.
The Always On availability groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012 (11.x), Always On availability groups maximizes the availability of a set of user databases for an enterprise. An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of read-write primary databases and one to eight sets of corresponding secondary databases.
Reference: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server?view=sql-server-2017
