70-281 Planning, Deploying, and Managing an Enterprise Project Management Solution Practice Exams

Demo Question 2.

You are the administrator of the Microsoft Enterprise Project Management solution for EliteCertify.com. You install the Enterprise Project Management solution for EliteCertify.com. You install Microsoft SQl Server 2000 on EliteCertify 1. You install Views Processing, Analysis Services, and Session Management on EliteCertify 2. You install Microsoft Project Server 2003 on EliteCertify 3. The company's 2000 employees all use Project Server timesheets to report actual hours worked daily. Project managers update their projects weekly. Users report that they are sometimes unable to connect to the project server during peak times. You must ensure that users can connect to the project server reliably. Your solution should optimize your servers for future growth. What should you do?

A. Install the Views Processing tables to another SQl Server on fourth server, EliteCertify 4. Configure the Views Processing Services on EliteCertify 2 to connect to this separate database on Server 4.
B. Install five instances of Project Server to different virtual sites on the Project Server computer, EliteCertify 3. Connect each site to the SQL Server on EliteCertify 1. Instruct groups of 400 users to connect to one of the virtual sites on EliteCertify 3.
C. Install a second network adapter on the SQL Server computer EliteCertify 1. Connect EliteCertify 3 to one of the network adapters. Connect EliteCertify 2 to the other network adapter.
D. Install a second instance of the SQL Server on EliteCertify 1. Move the Analysis Server database repository to the second instance of the SQL Server. Connect Analysis Server to the repository on the second instance.


Display Answer

Answer: A

Explanation: One of the tasks prior to building a Portfolio Analyzer View, is to set up views processing on a separate server. When projects are published to the Microsoft Project Server, a copy of the project is uploaded and is used to create project view data. This process is consumes a large share of network resources because it must open the project in the Microsoft Project OLE DB provider and save data from which views will be built. You can offload this service to improve the scalability and performance of a single IIS-based server running Microsoft Project Server, or of a farm of IISbased servers. If the Project Server 2003 front end computer is deployed in a Network Load Balancing cluster then this service must be moved to a computer outside the Network Load Balancing cluster. Thus by installing Views Processing tables to SQ1 Server, EliteCertify 4, and configure Views Processing Services on EliteCertify 2 to connect to this separate database on EliteCertify 4, you will ensure that users can connect to the project server reliably. Reference: Microsoft Training and Certification: Microsoft Official Curriculum: Planning, Deploying, and Managing an Enterprise Project Management solution; Delivery Guide, Course Number 2732A, Module 4: Implementing Project Server, Microsoft Press, Redmond, 2003, p. 4 and Module 9: Configuring and Managing Views and Security, Microsoft Press, Redmond, 2003, pp. 39-40