nerdexam
Microsoft

70-339 · Question #100

You have an on-premises SharePoint 2016 environment. You want to use Power View and PowerPivot features including Power View reports that are embedded in Microsoft Excel workbooks. You need to…

The correct answer is B. Install SQL Server 2016 Reporting Services (SSRS) in SharePoint integrated mode. C. Install an Office Online server. Enabling Power View and PowerPivot features in SharePoint 2016 requires SQL Server Reporting Services in SharePoint integrated mode and Office Online Server.

Install and configure SharePoint

Question

You have an on-premises SharePoint 2016 environment. You want to use Power View and PowerPivot features including Power View reports that are embedded in Microsoft Excel workbooks. You need to deploy the new features. Which two actions should you perform? Each correct answer presents part of the solution.

Options

  • AInstall PerformancePoint Services.
  • BInstall SQL Server 2016 Reporting Services (SSRS) in SharePoint integrated mode.
  • CInstall an Office Online server.
  • DInstall SQL Server 2016 Reporting Services (SSRS) in native mode.

How the community answered

(42 responses)
  • A
    14% (6)
  • B
    79% (33)
  • D
    7% (3)

Why each option

Enabling Power View and PowerPivot features in SharePoint 2016 requires SQL Server Reporting Services in SharePoint integrated mode and Office Online Server.

AInstall PerformancePoint Services.

PerformancePoint Services provides KPI dashboards and scorecards and has no role in enabling Power View or PowerPivot functionality.

BInstall SQL Server 2016 Reporting Services (SSRS) in SharePoint integrated mode.Correct

SQL Server 2016 Reporting Services in SharePoint integrated mode is required because Power View is delivered as an SSRS feature and must be configured in SharePoint integrated mode to render Power View reports directly within SharePoint pages and document libraries.

CInstall an Office Online server.Correct

Office Online Server is required to render Power View reports embedded in Excel workbooks, as it handles the in-browser rendering of Excel content including embedded Power View sheets when accessed through SharePoint.

DInstall SQL Server 2016 Reporting Services (SSRS) in native mode.

SSRS in native mode operates as a standalone report server independent of SharePoint and cannot integrate with SharePoint to deliver Power View reports within the SharePoint user interface.

Concept tested: Deploying Power View and PowerPivot in SharePoint 2016

Source: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services-sharepoint-mode

Topics

#Power View#PowerPivot#SSRS SharePoint mode#Office Online Server

Community Discussion

No community discussion yet for this question.

Full 70-339 Practice