PrepAway - Latest Free Exam Questions & Answers

what action should you perform?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. 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?

PrepAway - Latest Free Exam Questions & Answers

A.
You should assign the user to the Content Manager and the Report Builder roles

B.
You should assign the user to the Publisher role.

C.
You should assign the user to the My Reports role

D.
You should assign the user to the Content Manager and the Browser roles.

Explanation:
http://msdn.microsoft.com/en-us/library/ms156338.aspx
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 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.


Leave a Reply