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

View Answer

Answer: B

Explanation:

Explanation Scenario: Technical requirements Relecloud identifies the following technical requirements:

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