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.

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

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *