nerdexam
Microsoft

70-448 · Question #50

You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL…

The correct answer is C. You should assign the user to the My Reports role. SQL Server 2008 R2 Other Versions The My Reports role is a predefined role that includes a set of tasks that are useful for users of the My Reports feature. This role definition includes tasks that grant administrative permissions to users over the My Reports folder that they…

Implement a Reporting Services Solution

Question

You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. Now you are responsible for the security in SQL Server 2008 Reporting Services (SSRS). After a new user is assigned to a role, you should give the permissions to the user, making the user publish reports and manage content only in a private folder. So what action should you perform?

Options

  • AYou should assign the user to the Content Manager and the Report Builder roles
  • BYou should assign the user to the Publisher role.
  • CYou should assign the user to the My Reports role
  • DYou should assign the user to the Content Manager and the Browser roles.

How the community answered

(40 responses)
  • A
    8% (3)
  • B
    5% (2)
  • C
    85% (34)
  • D
    3% (1)

Explanation

SQL Server 2008 R2 Other Versions The My Reports role is a predefined role that includes a set of tasks that are useful for users of the My Reports feature. This role definition includes tasks that grant administrative permissions to users over the My Reports folder that they own. Although you can choose another role to use with the My Reports feature, it is recommended that you choose one that is used exclusively for My Reports security. For more information, see Securing My Reports.

Topics

#My Reports role#SSRS security#private folder#role assignment

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice