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.
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)- A19% (4)
- B71% (15)
- E5% (1)
- F5% (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.
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.
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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.