You are a SharePoint administrator at Litware, Inc.
Excel Services is not currently able to load workbooks on the SharePoint site. The Unified
Logging Service (ULS) log contains the following error message:
System.Data.SqICIient.SqIException: Cannot open database
“WSS_Content_Portal_Content_Database” requested by the login. The login failed. Login
failed for user ‘LITWARE\svcExcelService’.
You need to grant only the minimum necessary permissions to the Excel Services account to
ensure that users can open Excel workbooks from within a browser window.
Which Windows PowerShell cmdlet or cmdlets should you run?

A SharePoint environment contains an instance of Microsoft SQL Server 2008 R2.
You plan to migrate data from the existing database to a new instance of SQL Server 2012.
You need to configure SQL Server to support the migration. You must accomplish this goal
without requiring any SharePoint application configuration changes. What should you do?

A company plans to use eDiscovery in SharePoint. The environment includes Microsoft Lync
Server 2013 and Microsoft Exchange Server 2013. Lync Server is configured to archive
conversations to Exchange Server. You configure Exchange Server for eDiscovery. You
need to complete the eDiscovery configuration. What should you do? (Each correct answer
presents part of the solution. Choose all that apply.)

You are creating a SharePoint site that will be accessed remotely. You need to optimize the
SharePoint experience for all mobile devices. What should you configure?

You perform the basic configuration of a SharePoint site to support SharePoint apps. You
need to configure policy settings for SharePoint apps to ensure that users can browse apps
in the Office Store but cannot purchase apps without approval. Which two actions should
you perform? (Each correct answer presents part of the solution. Choose two.)

You are configuring a SharePoint environment to support SharePoint apps for Litware, Inc.
The SharePoint servers use a load-balancer for incoming requests. You need to ensure that
all connections to the SharePoint servers are secure and encrypted. What should you do?
(Each correct answer presents a part of the solution. Choose all that apply.)

A company uses a data-connected Microsoft Excel workbook to build reports from external
data sources. Data is not refreshed when the workbook is displayed in a browser. You need
to ensure that users can refresh Excel workbooks that are displayed in a browser. Which two
actions should you perform? (Each correct answer presents a complete solution. Choose two.)

A SharePoint deployment includes the content source described in the following table.

You need to configure the intranet site content source to return search results without
impacting availability.
What should you do?

A company named Contoso, Ltd. has a SharePoint 2010 site collection at
www.contoso.com. You are preparing to upgrade the site collection to SharePoint 2013. The
root site collection has had extensive customizations made to pages by using SharePoint
Designer. You need to test the site collection customizations before the upgrade. What
should you do?

You are configuring a SharePoint farm in an environment that includes Microsoft Exchange
Server 2013. You need to ensure that specified SharePoint users can search the Exchange
mailboxes of all employees, place holds on mailbox data, and export mailbox data. What
should you do first?