Your company has four offices. Each office contains a server that runs SQL Server 2008. All
corporate data is stored in a central location. You need to create a reporting solution. The
solution must meet the following requirements: • Minimize hardware costs • Minimize
administrative effort • Minimize the time it takes to generate the reports • Enable users to
run reports locally, even if a WAN link fails What should you do?
A.
Implement database mirroring.
B.
Implement log shipping.
C.
Create horizontally partitioned tables and a federated database.
D.
Implement a geographically dispersed SQL Server 2008 cluster.