nerdexam
Microsoft

70-332 · Question #1

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

The correct answer is D. Download and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 SP1 Feature Pack webpage. SharePoint 2013 requires PowerPivot from the SQL Server 2012 SP1 Feature Pack because it aligns with the supported SQL Server version and service pack level for that SharePoint release.

Configure and manage service applications

Question

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

Options

  • ADownload and install PowerPivot for SharePoint from the PowerPivot SQL Server 2008 R2 SP1 Feature Pack webpage.
  • BRun the SQL Server 2008 setup package.
  • CDownload and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 Feature Pack webpage.
  • DDownload and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 SP1 Feature Pack webpage.

How the community answered

(60 responses)
  • A
    2% (1)
  • B
    3% (2)
  • C
    5% (3)
  • D
    90% (54)

Why each option

SharePoint 2013 requires PowerPivot from the SQL Server 2012 SP1 Feature Pack because it aligns with the supported SQL Server version and service pack level for that SharePoint release.

ADownload and install PowerPivot for SharePoint from the PowerPivot SQL Server 2008 R2 SP1 Feature Pack webpage.

The SQL Server 2008 R2 SP1 Feature Pack targets SharePoint 2010, not SharePoint 2013, making it incompatible with the newer farm version.

BRun the SQL Server 2008 setup package.

Running the SQL Server 2008 setup package installs an unsupported SQL Server version for SharePoint 2013 and does not install the PowerPivot for SharePoint add-in correctly.

CDownload and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 Feature Pack webpage.

The SQL Server 2012 base Feature Pack (without SP1) lacks the required updates and is not the supported release for PowerPivot integration with SharePoint 2013.

DDownload and install PowerPivot for SharePoint from the PowerPivot SQL Server 2012 SP1 Feature Pack webpage.Correct

SharePoint 2013 was designed to work with SQL Server 2012 SP1, and the PowerPivot for SharePoint add-in must come from the matching SQL Server 2012 SP1 Feature Pack to ensure compatibility. Using the SP1 version provides the necessary updates and fixes required for integration with SharePoint 2013. Earlier feature packs or base releases do not meet the version requirements for SharePoint 2013 BI scenarios.

Concept tested: PowerPivot for SharePoint 2013 version compatibility

Source: https://learn.microsoft.com/en-us/sql/analysis-services/instances/install-windows/install-analysis-services-in-power-pivot-mode

Topics

#PowerPivot#SQL Server integration#BI service installation#feature pack

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-332 Practice