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
It should be C
0
2
Snapshot replication is not designed to provide “real time”. To achieve requested one may use availability group with readable secondary replicas used for reporting. So it is A.
1
0
This wouldn’t be a job for Snapshot Replication, rather Transactional Replication.
The answer is A.
1
0
A is correct
https://msdn.microsoft.com/en-us/library/ff878253(v=sql.110).aspx
1
0