You are managing the security in SQL Server 2008 Reporting Services (SSRS).
You assign a new user to a role.
You need to grant the permissions to the user to publish reports and manage content only in a private folder.
What should you do?

• A. Assign the user to the Content Manager and the Report Builder roles.
• B. Assign the user to the My Reports role.
• C. Assign the user to the Publisher role.
• D. Assign the user to the Content Manager and the Browser roles.

You maintain a SQL Server 2008 Integration Services (SSIS) instancE.The instance stores packages in
a SQL Server 2008 instance.
You need to deploy the package of an instance of SSIS to another SSIS instance that stores its packages in
a shared directory.
What should you do?

• A. Execute the dtexec command.
• B. Execute the dtutil command.
• C. Execute the dtexecui command.
• D. Execute the dtswizard command.

You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instance.
The report contains query parameters that allow users to filter the contents of the report.
The report requires users to enter parameter values before it will run.
The users wish to simplify the process so that the report will run without input.
You need to enable this functionality.
What should you do?

• A. Move the queries to the stored procedures and use the stored procedures to populate and filter the datasets of the report.
• B. Modify the dataset to use the Table query type.
• C. Add a default value to all parameters
• D. Remove the filters from the dataset queries and use the parameters to filter the data source.

You create a SQL Server 2008 R2 Analysis Services (SSAS) solution.
You are configuring security settings for a new database role with the following requirements:
Only the West member can be viewed by the database role. All other existing members and any newly
added members of the Region attribute will not be visible. Members in attribute hierarchies that include a
member of the Region attribute remain visible. The members in other attribute hierarchies remain visible.
The state of Washington is visible.
The aggregated totals for the ALL Level and Region attributes include only the values for members that are
visible.
You need to ensure that the database role has these security settings.
What should you do? (Each correct answer presents part of the solution. Choose two.)

• A. Set the Region attribute's IsAllowed = True, DeniedSet = "Except(Region..Members,{West})", ApplyDenied = False, and VisualTools = True.
• B. Set the State attribute's IsAllowed = True, AllowedSet = "Except(Region..Members,{West} + {Washington})", ApplyDenied = False, and VisualTools = False.
• C. Set the State attribute's IsAllowed = True, AllowedSet = "Except(Region..Members,{West})", ApplyDenied = True, and VisualTools = False.
• D. Set the Region attribute's IsAllowed = False, DeniedSet = "Except(Region..Members,{West})", ApplyDenied = False, and VisualTools = False.