nerdexam
Microsoft

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.

Implement a reporting services solution

Question

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 parameters. You need to ensure that the Developer role can view and modify report caching parameters. Which task should you add to the Developer role?

Exhibit

70-466 question #68 exhibit

Options

  • AManage report history
  • BManage all subscriptions
  • CView data sources
  • DManage individual subscriptions

How the community answered

(44 responses)
  • A
    91% (40)
  • B
    5% (2)
  • C
    2% (1)
  • D
    2% (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.

AManage report historyCorrect

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.

BManage all subscriptions

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.

CView data sources

View data sources allows viewing the properties of data sources assigned to a report but provides no access to report caching settings.

DManage individual subscriptions

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

#SSRS item roles#report caching#role permissions#cache parameters

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice