What should you do use?

You have five servers that run Microsoft SQL Server, Each server hosts multiple databases. You plan to implement fault tolerance.

You need lo implement a fault tolerance solution that meets the following requirements:

– Each database must use a separate fault tolerance configuration.

– The solution must support three or more copies of each database.

– Failover of database must be automatic.

What should you do use?
A . Always On availability groups
B . database mirroring
C . transactional replication
D . log shipping

View Answer

Answer: A

Explanation:

An availability group supports a replicated environment for a discrete set of user databases, known as availability databases. You can create an availability group for high availability (HA) or for read-scale. An HA availability group is a group of databases that fail over together.

Each set of availability database is hosted by an availability replica. Two types of availability replicas exist: a single primary replica. which hosts the primary databases, and one to eight secondary replicas, each of which hosts a set of secondary databases and serves as a potential failover targets for the availability group.

References: https://docs.microsoft.com/en-us/sql/database-engine/availability­groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-2017