70-243 · Question #151
You have a system Centre 2012 R2 Configuration Manager Service Pack1 (SP1) stand-alone primary site that includes the servers configured as the following: Server name: Configuration Server1…
The correct answer is D. Edit security of the report by using SSRS. To allow users to run a report but prevent them from modifying default parameter values, report-level security must be configured in SSRS to restrict user roles appropriately.
Question
You have a system Centre 2012 R2 Configuration Manager Service Pack1 (SP1) stand-alone primary site that includes the servers configured as the following:
Server name: Configuration Server1: Configuration Manager primary site server Server2: Microsoft SQL server 2012 SQL server reporting services (SSRS) reporting services point You have a custom report named Report1. Report1 has one parameter that has default value. You need to ensure that users can run Report1. But they cannot modify the default value of the parameter. What should you do?
Options
- AUpload a report model file to the report by using SSRS
- BEdit report by using the report Builder
- CEdit the report by using Business Intelligence Development Studio
- DEdit security of the report by using SSRS
How the community answered
(41 responses)- A7% (3)
- B2% (1)
- C17% (7)
- D73% (30)
Why each option
To allow users to run a report but prevent them from modifying default parameter values, report-level security must be configured in SSRS to restrict user roles appropriately.
Uploading a report model file defines data sources for model-based reports and has no effect on restricting parameter modification by end users.
Report Builder is an authoring tool used to design and edit report definitions, not to configure end-user security restrictions on report parameters.
Business Intelligence Development Studio is a development environment for creating reports and has no mechanism to enforce runtime parameter access restrictions for report consumers.
In SSRS, report-level security settings control role assignments for each report. Assigning users the Browser role permits them to view and run the report but prevents them from altering parameter values or the report definition. This configuration is applied directly in the SSRS Report Manager under the security settings for Report1.
Concept tested: SSRS report-level security role assignment
Source: https://learn.microsoft.com/en-us/sql/reporting-services/security/granting-permissions-on-a-native-mode-report-server
Topics
Community Discussion
No community discussion yet for this question.