PrepAway - Latest Free Exam Questions & Answers

Which three actions should you perform in sequence?

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.)
Select and Place:

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:
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


Leave a Reply