Correct Answer:
Explanation/Reference:
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 MyServerPOWERPIVOT. The PowerPivot instance name is required.
Type a description.
Click Ok.
Reference: PowerPivot for SharePoint 2013 Installation