nerdexam
Microsoft

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.

Implement a reporting services solution

Question

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 caching parameters. You need to ensure that the Reports Writer role can view and modify report caching parameters. What should you do?

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)
  • A
    4% (2)
  • B
    75% (39)
  • C
    13% (7)
  • D
    8% (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.

AAdd the Manage individual subscriptions task to the Reports Writer role.

Manage individual subscriptions allows a user to manage only their own subscriptions, which is unrelated to report caching configuration.

BAdd the Manage report history task to the Reports Writer role.Correct

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.

CAdd the View data sources task to the Reports Writer role.

View data sources grants read-only access to shared data source items and has no effect on caching or execution settings.

DAdd the Manage all subscriptions task to the Reports Writer role.

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

#item roles#task permissions#report caching#native mode security

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice