You have a deployment of Microsoft Office SharePoint Server 2007 Service Pack 2 (SP2).

The deployment includes the following servers:

* One Microsoft SQL Server 2005 server named Server1
* One SharePoint server named Server2.

All servers run the 64-bit edition of Windows Server 2003 Service Pack 2 (SP2).

You need to ensure that you can perform an in-place upgrade of SharePoint Server 2010.

What should you do?

You have a SharePoint Server 2010 server farm.

The farm contains the servers configured as shown in the following table:

Server1 Database
Server2 Web, query
Server3 Crawl

You need to ensure that users can perform searches if a single server fails.

What should you do?

You have a Microsoft Office SharePoint Server 2007 Service Pack 1 (SP1) server farm.

All servers in the farm run the 64-bit version of windows server 2003 Service Pack 2 (SP2).

You plan to perform an in-place upgrade to SharePoint Server 2010.

You need to ensure that you can successfully run the SharePoint Server 2010 Pre-Upgrade Checker.

What should you do?

You have a SharePoint Server 2010 server farm.

You configure a Microsoft Office Excel workbook to connect to a database.

All connections to the database must use a Microsoft SQL Server user named User1. You publish the workbook to a SharePoint site.

You need to ensure that users can access the database via the published workbook.

What should you configure?

You have a SharePoint Server 2010 server farm.

You have a Web application that is accessed by using the URL https://portal.contoso.com.

You need to add a new site collection to the Web application. Users must be able to access the site collection by using the URL https://hrweb.contoso.com.

What should you do?

You have two SharePoint Server 2010 server farms named Farm1 and Farm2.

You create a Taxonomy Term Store on Farm1.

You need to ensure that Farm2 can access the Taxonomy Term store on Farm1.

What should you do on Farm1?

You have a SharePoint Server 2010 server farm. A full crawl is scheduled to run every day.

You have a Web application that has several document libraries.

Each library contains a column named Division.

You need to ensure that users can search for all documents that contain a specific value in the Division columns.

What should you create?

You have a SharePoint Server 2010 server farm. You configure a User Profile service application.

You need to ensure a group named Group1 can manage user profiles.

What should you do?

You have a SharePoint Server 2010 server farm.

You have a team site named Site1. You create a new SharePoint group named Group1.

You need to configure the permissions of Site1 to meet the following requirements:

* Allow the members of Group1 to add Items.
* Prevent the members of Group1 from deleting Items.

What should you do?

You have a SharePoint Server 2010 server farm.

You create a new page. You need to prevent site members from modifying the page.

You must achieve this goal without changing the permissions currently assigned to other pages.

What should you do first?