You are a database developer. You plan to design a database solution by using SQL Server
2008. Your company has a main office in New York and several branch offices globally. All
the offices use databases on their local SQL Server 2008 servers to support trading
applications. A low-bandwidth WAN link connects the offices. The WAN link is subject to
interruptions. You plan to implement a reporting instance that will be deployed in the main
office. You need to design a solution to transfer data from all offices to the reporting
instance in the main office. You also need to ensure that the solution has minimum effect on
the performance of all trading servers. What should you do?

A.
use distributed transactions in the branch offices to write the trade information to the local
trading systems and the main office trading system.

B.
Create a mirrored database solution in high-safety mode in each branch office. Place the
mirrored databases in the main office.

C.
Create a warm standby server in the main office by using log shipping from the branch
offices.

D.
Create a publication by using transactional replication in each branch office. Create
subscriptions in the main office.

Explanation: