nerdexam
Microsoft

70-466 · Question #67

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server. Members of the Developer Support role cannot modify the

The correct answer is D. Manage report server properties. The report execution timeout period is a server-wide property, so modifying it requires the system-level task 'Manage report server properties', which controls site-wide configuration settings.

Implement a reporting services solution

Question

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server. Members of the Developer Support role cannot modify the report execution timeout period. You need to enable members of the Developer Support role to modify the report execution timeout period. Which task should you add to the Developer Support role?

Options

  • AExecute report definitions
  • BManage shared schedules
  • CManage jobs
  • DManage report server properties

How the community answered

(35 responses)
  • B
    3% (1)
  • C
    3% (1)
  • D
    94% (33)

Why each option

The report execution timeout period is a server-wide property, so modifying it requires the system-level task 'Manage report server properties', which controls site-wide configuration settings.

AExecute report definitions

Execute report definitions allows users to run ad-hoc report definitions uploaded directly, and has no relation to modifying server-wide timeout properties.

BManage shared schedules

Manage shared schedules controls creation and modification of shared report schedules, not server configuration properties like execution timeouts.

CManage jobs

Manage jobs allows cancellation of running report jobs but does not provide access to server-level configuration settings such as execution timeout.

DManage report server propertiesCorrect

The 'Manage report server properties' system-level task grants the ability to view and modify server-wide settings including the report execution timeout, memory management thresholds, and logging options. Because the execution timeout is a global server property - not a per-item setting - it can only be controlled through a system role task, making this the correct task to assign.

Concept tested: SSRS system-level task for server property management

Source: https://learn.microsoft.com/en-us/sql/reporting-services/security/tasks-and-permissions-system-level-tasks

Topics

#SSRS system roles#execution timeout#server properties#role tasks

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice