70-467 Question #118: Real Exam Question with Answer & Explanation

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

Explanation

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.

Common mistakes.

B. 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.
C. 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.
D. 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

Reference. https://learn.microsoft.com/en-us/sql/reporting-services/report-server-sharepoint/add-reporting-services-content-types-to-a-sharepoint-library

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice