Microsoft
70-243 · Question #134
70-243 Question #134: Real Exam Question with Answer & Explanation
The correct answer is D: On Server1, assign user1 a security role by using the Configuration Manager Console.. In SCCM 2012 R2, report access for users is granted through security roles assigned in the Configuration Manager Console, not directly in SQL Reporting Services.
Question
You manage a system Centre 2012 R2 Configuration Manager Service Pack1 (SP1) stand-alone primary site that includes the servers configured as shown in the following table: You need to provide a user named User1 with the ability to run reports. What should you do?
Exhibit
Options
- AOn Server2, modify the permission of the reporting services folder by using Report Manager.
- BOn Server2, modify the Configuration Report Users security role by using Report Managers.
- COn Server3, modify the database permission by using SQL server Management Studio.
- DOn Server1, assign user1 a security role by using the Configuration Manager Console.
Explanation
In SCCM 2012 R2, report access for users is granted through security roles assigned in the Configuration Manager Console, not directly in SQL Reporting Services.
Common mistakes.
- A. Modifying SSRS folder permissions via Report Manager bypasses SCCM's role-based access control and is not the supported method for managing report access in Configuration Manager.
- B. The 'Configuration Report Users' role does not exist as a standard Report Manager security role; SCCM reporting access is managed through the Configuration Manager Console, not Report Manager.
- C. Modifying SQL Server database permissions directly would grant database-level access, not SCCM report-running rights, and violates SCCM's intended administrative model.
Concept tested. SCCM role-based administration for report access
Reference. https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/reporting
Community Discussion
No community discussion yet for this question.