DRAG DROP
You have a SharePoint Server 2013 server farm that has the Excel Services Application service
application deployed. The farm uses a database server that has Microsoft SQL Server 2012 installed.
You need to implement PowerPivot for Excel Services in a basic configuration.
Which three actions should you perform in sequence? (To answer, move the appropriate three actions
from the list of actions to the answer area and arrange them in the correct order.)
Answer: See the explanation
Explanation:
Box 1:Box 2:
Box 3:
Note:
* Step 1: Need to upgrade SQL server.
* Step 2: On the Setup Role page, select SQL Server PowerPivot for SharePoint. This option installs
Analysis Services in SharePoint mode.
Optionally, you can add an instance of the Database Engine to your installation. You might add the
Database Engine when setting up a new farm and need a database server to run the farm’s
configuration and content databases. This option also installs SQL Server Management Studio.
* Step 3: Configure Excel Services for Analysis Services integration
In SharePoint Central Administration, in the Application Management group, click Manage Service
Applications.
Click the name of your service application, the default is Excel Services Application.
On the Manage Excel Services Application page, click Data Model Settings.
Click Add Server.
In Server Name, type the Analysis Services server name and the PowerPivot instance name. For example
MyServer\\POWERPIVOT. The PowerPivot instance name is required.
Type a description.
Click Ok. PowerPivot for SharePoint 2013 Installation
