You configure a SharePoint Server 2010 Service Pack 1 (SP1) server farm. You need to perform
backup and restore of a site collection and its content database by using Windows PowerShell.
Which command should you run to restore the content database?

You configure a SharePoint Server 2010 Service Pack 1 (SP1) farm. You create a SharePoint site
collection named http://www.contoso.com that has a subsite named
http://www.contoso.com/sales. You need to break the permissions inheritance for the subsite. You
also need to ensure that the groups from the parent site are retained. What should you do?

You have a SharePoint Server 2010 Service Pack 1 (SP1) server farm that contains a Web server and a
database server. You have a SharePoint Web site that contains large multimedia files. The
multimedia files are accessed frequently by a large number of users. You need to minimize the
amount of traffic between the Web server and the database server. What should you do?

HOTSPOT
You configure a SharePoint Server 2010 Service Pack 1 (SP1) server farm. You need to enable the
cache profile for anonymous users on internal collaboration sites for the site collection. You also
need to allow administrators to choose a different page output cache profile for page layouts. What
should you do? (To answer, configure the appropriate option or options in the dialog box in the
answer area.)

DRAG DROP
You want to configure a Shared Service Provider (SSP) for a SharePoint Server 2010 Service Pack l
(SP1) farm. Which type of account meets each of the requirements? (To answer, drag the
appropriate account or accounts to the correct location or locations in the answer area.)

You have a SharePoint Online environment that contains one site collection. You need to prevent
users in the Members group from publishing documents from Microsoft Office Word to SharePoint
sites. Users in the Members group must be able to upload documents from a Web browser to
SharePoint sites. What should you do?

You have a SharePoint Server 2010 Service Pack 1 (SP1) server farm that contains a Web server
named Server1. You have a file server named Server2. You discover that Server1 cannot render
Microsoft Office Excel workbooks that are stored on Server2 and that are larger than 10 MB. Server1
can render Excel workbooks that are stored on Server2 and that are smaller than 10 MB. You need
to ensure that Server1 can render all Excel workbooks stored on Server2. What should you do?

Your company has a SharePoint Server 2010 Service Pack 1 (SP1) server farm. You configure search
to index the content of several Web sites. You need to ensure that all of the Web sites are crawled,
including those whose certificates are expired. What should you do?

You have a SharePoint Server 2010 Service Pack 1 (SP1) 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 login named Excel1. 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?

DRAG DROP
You configure a SharePoint Server 2010 Service Pack 1 (SP1) farm. You need to provision user profile
synchronization. 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.)