Designing Database Solutions for Microsoft SQL Server — Question 18

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.

Answer options

Correct answer: A

Explanation

The correct answer, AlwaysOn availability groups, provides both high availability and the ability to read from secondary replicas, which meets the requirement for running reports. Database mirroring does not support reporting on a secondary, log shipping requires manual intervention for failover, and failover clustering does not allow for reporting on a separate server.