nerdexam
Microsoft

70-467 · Question #116

You need to prepare the infrastructure for the planned implementation of Gallery1. Which three actions should you perform? Each Answer presents part of the solution,

The correct answer is B. Run the PowerPivot Configuration Tool. C. Install the SQL Server Reporting Services add-in for SharePoint. D. Install SQL Server PowerPivot for SharePoint. Deploying a PowerPivot Gallery in SharePoint requires installing PowerPivot for SharePoint, the SSRS add-in for SharePoint, and then running the PowerPivot Configuration Tool to wire everything together.

Plan business intelligence (BI) infrastructure

Question

You need to prepare the infrastructure for the planned implementation of Gallery1. Which three actions should you perform? Each Answer presents part of the solution,

Options

  • AInstall a Database Engine instance.
  • BRun the PowerPivot Configuration Tool.
  • CInstall the SQL Server Reporting Services add-in for SharePoint.
  • DInstall SQL Server PowerPivot for SharePoint.
  • EInstall the SQL Server Reporting Services-SharePoint feature.
  • FRun the Install-SPUserSolution cmdlet.

How the community answered

(21 responses)
  • A
    19% (4)
  • B
    71% (15)
  • E
    5% (1)
  • F
    5% (1)

Why each option

Deploying a PowerPivot Gallery in SharePoint requires installing PowerPivot for SharePoint, the SSRS add-in for SharePoint, and then running the PowerPivot Configuration Tool to wire everything together.

AInstall a Database Engine instance.

A standard Database Engine instance is not required to host a PowerPivot Gallery; the gallery relies on the Analysis Services SharePoint mode instance installed by PowerPivot for SharePoint.

BRun the PowerPivot Configuration Tool.Correct

The PowerPivot Configuration Tool automates post-installation setup tasks such as registering the PowerPivot service application and configuring SharePoint integration, and must be run after the binary installation.

CInstall the SQL Server Reporting Services add-in for SharePoint.Correct

The SQL Server Reporting Services add-in for SharePoint (rsSharePoint.msi) is required to enable SSRS report rendering and the Report Viewer Web Part within the SharePoint environment that hosts the gallery.

DInstall SQL Server PowerPivot for SharePoint.Correct

SQL Server PowerPivot for SharePoint installs the Analysis Services instance in SharePoint mode and the PowerPivot System Service, which are the core server components the gallery depends on for workbook data refresh and query processing.

EInstall the SQL Server Reporting Services-SharePoint feature.

The SSRS-SharePoint feature (installed via SQL Server setup) is the server-side component needed when SSRS itself is being deployed in SharePoint integrated mode, which is not the specific requirement here.

FRun the Install-SPUserSolution cmdlet.

Install-SPUserSolution deploys SharePoint sandbox solutions and is not part of the PowerPivot Gallery infrastructure setup process.

Concept tested: PowerPivot for SharePoint Gallery infrastructure setup

Source: https://learn.microsoft.com/en-us/sql/analysis-services/power-pivot-sharepoint/power-pivot-for-sharepoint-ssas

Topics

#PowerPivot for SharePoint#SSRS add-in#BI infrastructure#SharePoint

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice