What should you include in the design?

You have four databases that are accessed by using an Online Transaction Processing (OLTP) application.

The databases are stored on a server named SQL1 that has SQL Server 2014 installed. You plan to deploy an additional server that has SQL Server 2014 installed. You need to design a high-availability solution for the databases that meets the following requirements:

If SQL1 fails, the databases must be available.

Users must be able to run reports against a secondary copy of the databases.

What should you include in the design? More than one answer choice may achieve the goal. Select the BEST answer.
A . AlwaysOn availability groups
B . Database mirroring
C . Log shipping
D . Failover Clustering

View Answer

Answer: A

Explanation:

The AlwaysOn 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, AlwaysOn 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.