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?

Question

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?

Accepted Answer

B. Implement log shipping.

Answer

A. Implement database mirroring.

Answer

C. Create horizontally partitioned tables and a federated database.

Answer

D. Implement a geographically dispersed SQL Server 2008 cluster.

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…

Question

Options

How the community answered

Community Discussion