DRAG DROP
You have a SharePoint Server 2010 Service Pack 1 (SP1) server farm. The farm contains an
Excel Services service application.
You plan to display a Microsoft Excel file in a Web Part. The Excel file will be stored on a file server
and will contain custom calculations written in Microsoft Visual Studio.
You need to identify which Excel Services configuration must be configured to display the Excel file.
What should you configure?
To answer, drag the appropriate configuration to the correct location in the answer area.

HOTSPOT
Your company plans to deploy three SharePoint Server 2010 Service Pack 1 (SP1) server farms
named Farm1, Farm2, and Farm3.
During the initial planning phase, you identify the following high-level requirements for each farm:
Farm1 will host shared service applications.
Farm2 will host content for the human resources department. The farm content will be searchable.
Farm3 will host content for all users. The users will be able to open Microsoft Word documents
stored in the farm directly from a web browser.
You identify the following deployment requirements:
Server virtualization will not be used.
Farm1 must host service applications whenever possible.
The service applications must not run on servers that host webpages for end users.
The users must be able to access all services and all content in all of the farms if a single server fails.
You need to identify the minimum number of SharePoint servers required for each farm. How many
servers should you identify?
To answer, configure the appropriate number of servers for each farm in the answer area.

DRAG DROP
You have a SharePoint Server 2010 Service Pack l (SP1) server farm.
You need to recommend which tools must be used to recover deleted pages, deleted document
libraries, and deleted permission levels. The solution must use the minimum amount of
administrative effort.
Which tool should you use for each type of content?
To answer, drag the appropriate tool to the correct recovery task in the answer area.

You have a SharePoint Server 2010 Service Pack 1 (SP1) server farm. The farm contains a site
collection named Collection1. You need to recommend a strategy to remove the draft versions from
documents that were not modified for six months. What should you include in the
recommendation?

You are planning a SharePoint Server 2010 Service Pack 1 (SP1) server farm. You need to recommend
which editions of Microsoft SQL Server 2008 R2 must be deployed to support online index
rebuilding. Which editions should you recommend? (Each correct answer presents a complete
solution. Choose all that apply.)

DRAG DROP
You are the administrator for a SharePoint Server 2010 Service Pack 1 (SP1) farm. You need to
deploy a custom site to the top site of a site collection on the production farm. What should you do?
(To answer, move the appropriate actions from the list of actions to the answer area and arrange
them in the correct order.)

You have a SharePoint Server 2010 Service Pack 1 (SP1) server farm. The farm contains three servers
named WFE1, WFE2, and APP1.
User requests are load balanced by using a hardware load balancer.
The farm contains a Business Data Connectivity Service service application. The service application is
configured to run on APP1.
You plan to add a new server named APP2 to the farm.
You need to ensure that all requests to the Business Data Connectivity Service service application are
load balanced between APP1 and APP2.
What should you do?

You have a SharePoint Server 2010 Service Pack 1 (SP1) deployment. You need to write a report that
uses Microsoft SQL Server Reporting Services to monitor feature usage. The solution must minimize
the amount of development effort. Which data source should you use?

DRAG DROP
You have two SharePoint Server 2010 Service Pack 1 (SP1) server farms named Farm1 and
Farm2.
You plan to implement a hierarchical classification for the two farms.
You need to recommend a solution to meet the following requirements:
All classifications must be created and managed in Farm1.
Farm2 must be able to consume the classifications in Farm1.
What should you recommend?
To answer, move the appropriate actions from the list of actions to the answer area and arrange
them in the correct order.

DRAG DROP
You are the administrator for a SharePoint Server 2010 Service Pack 1 (SP1) farm. The farm topology
is as shown in the following table.

You want to improve the performance of the search.
You need to add an Application Server.
Which component should you place on each of the three servers? (To answer, drag the appropriate
server or server to the correct location or locations in the answer area.)