DRAG DROP
You plan to deploy three highly available SQL Server environments that will use SQL Server 2014.
You identify the following specifications for each environment as shown following table.
You need to recommend which high-availability feature is required for each environment.
Which features should you identify?
To answer, drag the appropriate feature to the correct requirement in the answer area.
Answer: 
Explanation:
* Always on availability groups
he 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.
Deploying AlwaysOn Availability Groups requires a Windows Server Failover Clustering
(WSFC) cluster.
Database Mirroring
AlwaysOn Avaibility groups
AlwaysOn Avaibility groups
0
0
Database Mirroring
AlwaysOn Avaibility groups
AlwaysOn Avaibility groups
0
0
Mirroring for ENV1 (Sql version is Standard, so only mirroring met condition – servers will be witness, principal and mirror);
AlwaysOn for ENV2 and 3 (Sql version is Enterprise, so AlwaysOn feature is available)
Log shipping and peer to peer replication have no automatic failover, so cannot candidate for correct answers.
0
0