70-466 · Question #68
You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Developer is present on the server. The Developer role cannot view and modify report caching…
The correct answer is A. Manage report history. Viewing and modifying report caching parameters in SSRS is controlled by the 'Manage report history' item-level task, which covers cached instances and snapshot management.
Question
Exhibit
Options
- AManage report history
- BManage all subscriptions
- CView data sources
- DManage individual subscriptions
How the community answered
(44 responses)- A91% (40)
- B5% (2)
- C2% (1)
- D2% (1)
Why each option
Viewing and modifying report caching parameters in SSRS is controlled by the 'Manage report history' item-level task, which covers cached instances and snapshot management.
In SSRS, the 'Manage report history' item-level task grants permission to configure and manage cached report instances along with report history snapshots, including setting cache expiration and history limits. Caching parameters such as cache refresh options and expiration policies are part of the report execution and history configuration surfaces, all gated behind this single task.
Manage all subscriptions grants the ability to manage subscriptions created by any user on the server, and does not provide access to caching or execution parameters.
View data sources allows viewing the properties of data sources assigned to a report but provides no access to report caching settings.
Manage individual subscriptions lets users manage only their own subscriptions and has no relationship to report caching or execution history parameters.
Concept tested: SSRS item-level task controlling report caching parameters
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.
