nerdexam
Microsoft

70-466 · Question #65

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role named Folder Access Controller is present on the server. The Folder Access Controller role consists of only…

The correct answer is B. Manage folders. To allow role members to view folders in Report Manager, the role must include the 'Manage folders' task, which grants the ability to create, view, and navigate folder items.

Implement a reporting services solution

Question

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role named Folder Access Controller is present on the server. The Folder Access Controller role consists of only the Set security for individual items task. When role members open Report Manager, they cannot view folders. You need to modify the Folder Access Controller role so that the role members can view folders. Which task should you add to the Folder Access Controller role?

Options

  • AManage data sources
  • BManage folders
  • CView models
  • DView reports

How the community answered

(26 responses)
  • A
    8% (2)
  • B
    88% (23)
  • D
    4% (1)

Why each option

To allow role members to view folders in Report Manager, the role must include the 'Manage folders' task, which grants the ability to create, view, and navigate folder items.

AManage data sources

Manage data sources controls creation and modification of shared data sources, not the visibility of folders in Report Manager.

BManage foldersCorrect

The 'Manage folders' task is the item-level task in SSRS that grants permission to add, view, and delete folders within Report Manager. Without it, users can only perform security operations via 'Set security for individual items' but cannot see or navigate the folder hierarchy. Adding 'Manage folders' directly enables folder visibility in the Report Manager interface.

CView models

View models grants permission to see report models in the catalog but does not affect folder visibility.

DView reports

View reports grants access to view published reports, but does not grant the ability to see or navigate folders.

Concept tested: SSRS item-level role task for folder visibility

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

Topics

#SSRS roles#folder permissions#item-level security#Report Manager

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice