You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You plan to deploy three new servers running SQL Server 2012 Standard Edition.
You need to configure the three servers to host databases that must be highly available.
Automatic failover is required in the event of a server failure.
Which of the following SQL Server features should you configure?
A.
Peer-to-Peer Transactional Replication.
B.
AlwaysOn Availability Groups.
C.
Database Mirroring.
D.
Transaction Log Shipping.
Explanation:
Database mirroring is being deprecated so this question is not quite valid anymore.
0
0
>= 2 servers should use AlwaysOn, answer is B
0
0
Says Standard Edition, so it’s Database Mirroring.
0
0
C is right – Standard Edition
0
0
May be B or C
https://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx#High_availability
0
0