You are a database administrator for a Microsoft SQL Server 2012 instance.
You need to ensure that data can be replicated from a production server to two reporting
servers in real time. You also need to ensure that data on the reporting server is always
accessible.
Which solution should you use?
A.
Availability Groups
B.
Extended Events
C.
Snapshot Replication
D.
Policy Based Management
A