Home » Microsoft » 70-764 v.2 » What should you use?
You have five servers that run Microsoft SQL Server. Each server hosts multiple databases. You plat to implement fault tolerance.
You need to 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 databases must be automatic.
What should you use?
A. Always On availability groups
B. database mirroring
C. transactional replication
D. log shipping
Correct Answer: A
Explanation/Reference:
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