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).
There is a folder named Supervision Reports in the report server. Reports in any folder can be viewed and modified by all groups.
Now you receive an e-mail from the company CIO, according to his requirement, only the Managers group is allowed to view and modify reports in the Supervision Reports folder.
The company assigns this task to you. So what action should you perform to make sure of this?
A.
First the Managers group should be added to the root folder. Then you should assign the Content Manager role. At last, from the Management Reports folder, remove all groups.
B.
From the Management Reports folder, remove all groups. Then the Managers group should be added to the folder and assign the Content Manager role
C.
First a Managers role should be created. Then the Managers role should be assigned to the root folder. At last, from the Management Reports folder, remove all groups
D.
First a Managers role should be created. Then the Managers role should be assigned to the Management Reports folder. At last, from the Management Reports folder, remove all other groups.