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 SQ

L 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 off

ice. 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 R

eplication

B. Log Shipping

C. Snapshot Replication

D. SQL Server Availability Group