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

Demo Question 3.

You are the administrator of EliteCertify.com's Microsoft Enterprise Project Management solution. You are preparing to partition the database for a new installation. You create a new database named "ProjectServer_Views" on EliteCertify B. You plan to connect Microsoft Office Project Server 2003 to an existing Project Server database for the main database on EliteCertify

A. You plan to partition the Views Processing Tables to a newly created database named "ProjectServer_Views" on EliteCertify
B. You create the Microsoft SQL Server 2000 logins MSProjectViews and MSProjectServerViews on EliteCertify You execute the script PSRoles.sql on EliteCertify You add the MSProjectViews login to the MSProjectServerUser role in ProjectServer_Views. You add the MPSProjectServerViews login to the MSProjectServerUser role in ProjectServer_Views. You execute the scripts ViewsTabls.sql ad ViewsPs.sql against the ProjectServer_Views database on EliteCertify During installation, you choose to connect to an existing database on EliteCertify A named "ProjectServer" for the main Project Server database. You choose to partition the Views Tables to ProjectServer_Views on EliteCertify You are prompted by a dialog box that says, "Database server: EliteCertify The server you entered is not responding. Check that the name is valid and try again." You validate that you can physically connect to EliteCertify You verify that the Microsoft SQL Server 2000 is running correctly on EliteCertify You need to ensure that Project Server can use EliteCertify B to host its Views tables. What should you do? Change the name of the ProjectServer_Views database on EliteCertify B to "ProjectServer" to match the name of the database on EliteCertify Return to the Connection Information for Views Tables screen. Add the address of EliteCertify B to the hosts file on the Web EliteCertify
C. Add the SQL accounts MSProjectServer User and MS ProjectUser with identical passwords to those accounts on EliteCertify A to EliteCertify Add MSProjectUser to the MSProjectRole and MSProjectServerUser to the MSProjectServerRole in the ProjectServer_Views database.
D. Stop and Restart the SQLServer service on EliteCertify B.


Display Answer

Answer: C

Explanation: Views, like the views in Microsoft Project, are a collection of Microsoft Project fields, groups and filters, or charts. To provide users or groups access to a view, define the view as a category and then grant permissions to the category for the users or groups. You can define views for the Project Center, Resource Center, and Portfolio Analyzer pages. The information you enter in the Enter connection information for Views tables installs the Project Server 2003 View Tables in the main Project Server 2003 database. This option allows the Project Server database to be installed across two physical SQL Server 2000 database servers for scalability and better performance. 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. 6