Microsoft
70-243 · Question #151
70-243 Question #151: Real Exam Question with Answer & Explanation
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
Explanation
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.
Common mistakes.
- A. Uploading a report model file defines data sources for model-based reports and has no effect on restricting parameter modification by end users.
- B. Report Builder is an authoring tool used to design and edit report definitions, not to configure end-user security restrictions on report parameters.
- C. Business Intelligence Development Studio is a development environment for creating reports and has no mechanism to enforce runtime parameter access restrictions for report consumers.
Concept tested. SSRS report-level security role assignment
Community Discussion
No community discussion yet for this question.