70-467 · Question #118
You need to configure Library1 to support the planned self-service reports. What is the best configuration you should add to Library1? More than one answer choice may achieve the goal. Select the…
The correct answer is A. The Report Builder report content type. To enable self-service reporting in a SharePoint library integrated with SSRS, the Report Builder report content type must be added so users can launch Report Builder from the browser and save reports directly to the library.
Question
You need to configure Library1 to support the planned self-service reports. What is the best configuration you should add to Library1? More than one answer choice may achieve the goal. Select the BEST answer.
Options
- AThe Report Builder report content type
- BThe PowerPivot Gallery Document content type
- CThe Report Builder Model content type
- DThe Report content type
How the community answered
(56 responses)- A88% (49)
- B4% (2)
- C7% (4)
- D2% (1)
Why each option
To enable self-service reporting in a SharePoint library integrated with SSRS, the Report Builder report content type must be added so users can launch Report Builder from the browser and save reports directly to the library.
The Report Builder report content type, when added to a SharePoint document library, activates the 'New Document' menu option that launches Report Builder in the browser, allowing end users to create and save .rdl reports directly - this is the specific content type purpose-built to support self-service ad hoc reporting in SharePoint integrated mode SSRS.
The PowerPivot Gallery Document content type is designed for storing PowerPivot-enabled Excel workbooks and SSAS tabular data models, not for enabling Report Builder self-service report creation.
The Report Builder Model content type is used for semantic model files (.smdl) that serve as data sources for Report Builder, not for enabling users to create and save self-service reports.
The Report content type is used for deploying pre-built SSRS reports (.rdl) published from developer tools like Visual Studio, not for enabling end-user self-service authoring workflows.
Concept tested: SharePoint SSRS integration Report Builder content type
Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-server-sharepoint/add-reporting-services-content-types-to-a-sharepoint-library
Topics
Community Discussion
No community discussion yet for this question.