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…

The correct sequence of actions to implement PowerPivot for Excel Services is: 1. Upgrade SQL Server 2012 to Service Pack 1 (SP1). 2. Install SQL Server Analysis Services (SSAS) in SharePoint integrated mode. 3. Add the SQL Server Analysis Services (SSAS) server to the Excel…

Configure and manage service applications

Question

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.)

Explanation

The correct sequence of actions to implement PowerPivot for Excel Services is:

Upgrade SQL Server 2012 to Service Pack 1 (SP1).
Install SQL Server Analysis Services (SSAS) in SharePoint integrated mode.
Add the SQL Server Analysis Services (SSAS) server to the Excel Services Application data model.

Topics

#PowerPivot#Excel Services#SQL Server Analysis Services#service application configuration

Community Discussion

No community discussion yet for this question.

Full 70-332 Practice