Advanced Solutions of Microsoft SharePoint Server 2013 — Question 1

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

Answer options

• A. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2008 R2 SP1 Feature Pack webpage.
• B. Run the SQL Server 2008 setup package.
• C. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 Feature Pack webpage.
• D. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 SP1 Feature Pack webpage.

Correct answer: D

Explanation

The correct answer is D because PowerPivot for SharePoint requires the specific version from the SQL Server 2012 SP1 Feature Pack to function correctly with SharePoint 2013. Option A is incorrect as it references an outdated version (SQL Server 2008 R2), while option B doesn't address PowerPivot installation at all, and option C, although close, does not specify the SP1 update which is necessary for compatibility.