• Description:Microsoft 70-441 Designing Database Solutions by Using MS SQL Serv 2005
• Passing Score:75%
• Practice Test - Number of questions:71 questions
• Simulation Test - Number of questions:71 questions
• Simulation Test Duration:41 minutes
• Has explanations:Yes

You need to provide a scalability and load balancing plan for the company's growth. Your solution must fulfill all business and technical requirements. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

Answer(s)

1. Plan for the servers at each office to store all data for only that office.
2. Plan to horizontally partition tables by office, and create a federated database that includes one server in each office, with each server storing the data for that office.
3. Plan to implement a clustered SQL Server 2005 computer by using Microsoft Cluster Service (MSCS), and to store data for all of the offices on that cluster.
4. Plan to implement one server for each office, and to implement replication between all of these servers.
5. Use SQL Server 2005 to partition the database server so that data for each office is stored on a separate partition.

Plan to horizontally partition tables by office, and create a federated database that includes one server in each office, with each server storing the data for that office.

Plan to implement one server for each office, and to implement replication between all of these servers.