You are configuring SharePoint 2013 to support business intelligence.
You need to install PowerPivot for SharePoint.
What should you do?

You are configuring SharePoint 2013 to support business intelligence.
You need to install PowerPivot for SharePoint.
What should you do?

You are configuring SharePoint 2013 to support business intelligence.
You need to install PowerPivot for SharePoint.What should you do?

You are a SharePoint developer at Contoso, Ltd. The Contoso finance department is developing a reporting
application that displays financial information from an internal application on the SharePoint Business
Intelligence (BI) site.
You must configure a single server SharePoint environment to support Reporting Services. You must validate
that the installation works correctly.
You need to build and test the environment. Which five actions should you perform in sequence? To answer,
move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

You have a SharePoint Server 2013 server farm.
You need to configure per-user authentication for PerformancePoint dashboards.
What should you use?

You have a custom solution named SalesSolution deployed to the URL http://site.contoso.com/sites/sales.
You need to deploy a new version of the solution without retracting the previous version.
How should you complete the Windows PowerShell cmdlet? (To answer, drag the appropriate terms to the
correct location or locations in the answer area. Each term may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.)
Select and Place:

You deploy SharePoint Server 2013.
You need to install a SharePoint hosted app named App1 in a site.
Which Windows PowerShell cmdlet should you run?

A company has a SharePoint 2013 farm in an Active Directory Domain Services (AD DS) domain. The
company uses a third-party application to process payroll data and view payroll reports.
The third-party application uses SQL Authentication. Payroll administrators currently use custom credentials to
sign in to the payroll application.
You have the following requirements:
Payroll administrators must use Microsoft Excel and Excel Services to access payroll data and view reports
from within SharePoint.
Payroll administrators must not be required to enter credentials when accessing payroll data.
The Secure Store must be configured for high security and high process isolation.
You need to configure the Secure Store to meet the requirements.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.)
Select and Place:

You are a SharePoint administrator at Litware, Inc. A Business Data Connectivity service application has
recently been deployed.
Users report that they cannot create external lists that contain the external content types, and they receive the
following error message when they try to open existing external lists: “Access Denied by Business Data
Connectivity”.
You need to configure the minimum permissions required so that users can create external lists and read data
in external lists.
On the Set Object Permissions page, which permissions should you select? (To answer, select the appropriate
permissions in the answer area.)
Hot Area:

You plan to create two external content types named ECT1 and ECT2. ECT1 will retrieve data from a database
hosted on a Microsoft SQL Server server. ECT2 will retrieve data from a database hosted on an Oracle server.
ECT1 and ECT2 will be deployed at the server farm-level.
You need to recommend a tool to create the external content types. The solution must minimize
development effort.
Which tool should you recommend? (To answer, drag the appropriate tools to the correct external content
types. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between
panes or scroll to view content.)
Select and Place: