Which feature of SQL Server 2012 provides a failover environment consisting of a group of primary user databases with up to four replicas?
A)FCI
B)AG
C)ETL
D)IS

Question

Quizplus · Accepted Answer

AG (AlwaysOn Availability Groups) is a feature of SQL Server 2012 that provides a failover environment consisting of a group of primary user databases with up to four replicas. FCI (Failover Cluster Instances) is another feature that provides high availability, but it only supports two-node clusters and requires shared storage. ETL (Extract, Transform, Load) and IS (Integration Services) are not related to providing high availability or failover environments in SQL Server 2012.

Which Feature of SQL Server 2012 Provides a Failover Environment