PrepAway - Latest Free Exam Questions & Answers

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.

PrepAway - Latest Free Exam Questions & Answers

A.
AlwaysOn availability groups

B.
Database mirroring

C.
Log shipping

D.
Failover Clustering

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.
Failover and Failover Modes (AlwaysOn Availability Groups)


Leave a Reply