You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
A server named ABC-SQL1 hosts multiple databases that are accessed using OLTP (Online
Transaction Processing) applications.
You are concerned about the lack of redundancy provided by this single server solution.
You want to configure a solution that ensures high-availability for the databases while
minimizing costs. You need to ensure that the databases remain online in the event of a
hardware failure of ABC-SQL1.
You configure a second server named ABC-SQL2 and install SQL Server 2012.
Which of the following solutions would provide the high-availability and enable users to
run reports on both copies of the databases?
A.
AlwaysOn availability groups
B.
A failover cluster
C.
Database mirroring
D.
Transaction log shipping
Explanation:
The Question says “high-availability for the databases while minimizing costs”, which would mean “Mirroring”, but it also says “run reports on both copies”, so it must be “AlwaysOn Availability Groups” since “Mirroring” doesn’t allow querying on the replica.