70-466 · Question #3
You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Reports Writer is present on the server. The Reports Writer role cannot view and modify report c
The correct answer is B. Add the Manage report history task to the Reports Writer role.. To grant an SSRS native mode role the ability to view and modify report caching parameters, the Manage report history task must be added to that role.
Question
Options
- AAdd the Manage individual subscriptions task to the Reports Writer role.
- BAdd the Manage report history task to the Reports Writer role.
- CAdd the View data sources task to the Reports Writer role.
- DAdd the Manage all subscriptions task to the Reports Writer role.
How the community answered
(52 responses)- A4% (2)
- B75% (39)
- C13% (7)
- D8% (4)
Why each option
To grant an SSRS native mode role the ability to view and modify report caching parameters, the Manage report history task must be added to that role.
Manage individual subscriptions allows a user to manage only their own subscriptions, which is unrelated to report caching configuration.
In SSRS native mode, the 'Manage report history' item-level task grants permission to create and delete snapshots and to configure caching and execution properties for reports. Adding this task to the Reports Writer role enables members to view and modify the cache refresh schedule and related caching parameters through the report's execution properties page.
View data sources grants read-only access to shared data source items and has no effect on caching or execution settings.
Manage all subscriptions grants administrative control over every subscription on the server, not permission to modify caching parameters.
Concept tested: SSRS native mode item-level role task for caching
Source: https://learn.microsoft.com/en-us/sql/reporting-services/security/tasks-and-permissions-item-level-tasks
Topics
Community Discussion
No community discussion yet for this question.