Your Microsoft Office Project Server 2007 environment includes the servers shown in the following table.
You configure the Analysis Services repository by using a Microsoft Office Access MDB file.

You attempt to build an online analysis processing (OLAP) cube. You receive the following error message: Error: The Microsoft Jet database engine cannot open the file ‘C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\DSO9\msmdrep.mdb’. It is already opened exclusively by another user, or you need permission to view its data.

You need to resolve the error.

What should you do?

You have a Microsoft Office Project Server 2007 environment. Microsoft SQL Server Reporting Services (SSRS) is installed on one server. SQL Server Analysis Services 2005 is installed on another server. You need to deploy the Project Server 2007 Report Pack.What should you do?

You use the default project workspace template in Microsoft Office Project
Server 2007. You need to back up a project workspace. What should you do?

You are deploying Microsoft Office Project Server 2007. The Microsoft SQL Server 2005 database is on a separate server. You need to configure the database to support remote users. How should you configure the surface area settings?

You have a Microsoft Office Project Server 2007 environment. You need to move the transaction log files for the Project Server databases to a dedicated drive. What should you do?

Your Microsoft Office Project Server 2007 environment includes an Analysis Services Repository in Microsoft SQL Server 2005. In Project Web Access (PWA), you initiate a build of an online analytical processing (OLAP) cube. You receive the following error message: A connection cannot be made. Ensure that the server is running. You need to resolve this specific error. What should you do?

You have a Microsoft Office Project Server 2007 environment. You have users assigned to the Team Members security group. You need to ensure that users in the Team Members security group are not able to assign their tasks in Project Web Access (PWA) to another user. You need to achieve this goal without affecting other users permissions. What should you do?

You have a Microsoft Office Project Server 2007 environment. A project manager reports that when she adds a specific resource to tasks, the tasks appear in her My Tasks page and not in the My Tasks page of the resource. You need to ensure that future tasks appear in the My Tasks page of the resource. What should you do?

You create a Resource Breakdown Structure (RBS) in your Microsoft Office Project Server 2007 environment. You assign each resource to be directly under its project manager. You need to configure the My Organization category to allow project managers to modify the settings for their own resources. What should you do?

You have a Microsoft Office Project Server 2007 environment. You need to ensure that task updates for a specific project are routed to a new project manager. What should you do?