You work as the Senior Database Administrator (DBA) at ABC.com. The company has a main office
and 10 branch offices. Each branch office contains a single database server running Microsoft SQL
Server 2012. The main office has multiple clustered servers running Microsoft SQL Server 2012.
Your role includes the management of the entire Microsoft SQL Server 2012 infrastructure.
The company runs a custom application that stores data in a large Microsoft SQL Server 2012
database.
The primary database is hosted in the main office. Each branch office SQL Server hosts a copy of the
database.
You need to configure a solution that will replicate the entire primary database from the main office
SQL Server every weekend.
What should you include in your solution?
A.
Transactional Replication
B.
Log Shipping
C.
Snapshot Replication
D.
SQL Server Availability Group
C
C
https://msdn.microsoft.com/en-us/library/ms151832.aspx