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. Modify the dataset to use the Table query type.
• B. Add a default value to all parameters
• C. Move the queries to the stored procedures and use the stored procedures to populate and filter the datasets of the report.
• D. Remove the filters from the dataset queries and use the parameters to filter the data source.

You administer a SQL Server 2008 Reporting Services (SSRS) instance.
The instance contains several reports that use stored credentials to access data from a SQL Server 2008 instance.
A computer that hosts the instance recovers from a hardware failure and has a newly installed SSRS instance.
You need to ensure that the reports hosted on the instance continue to function correctly.
What should you do?

• A. Recreate the encryption keys.
• B. Restore the encryption keys.
• C. Recreate the Report Server database.
• D. Reinitialize the Report Server.

You are developing a SQL Server 2008 Reporting Service (SSRS) report for a DotNetNuke (DNN) application. The DNN application and SSRS are located on the same server. A custom module has been built in DNN to display the reports.
You need to enable the DNN application to connect to the report.
What should you do?

• A. Deploy the report to the Report Server.
• B. Modify the properties of ServerURL.
• C. Modify the RSReportServer.config file.
• D. Use the SSRS Web service.

You are developing a SQL Server 2008 Integration Services (SSIS) project in Business Intelligence
Development Studio.
You configure the project properties as shown in the following image.
You need to create a deployment manifest for all packages in the project.
What should you do?

• A. Build the Integration Services project.
• B. View the code of each Data Transformation Services (DTS) package. Copy the first <DTS:Property> xml node to a file with a .SSISDeploymentManifest file extension.
• C. Copy each package. Rename each copy with a .SSISDeploymentManifest file extension.
• D. Modify the AllowConfigurationChanges property of the project.

You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a dimension named
Customer.
You need to configure the Dimension Data settings to meet the following requirements:
Deny access to the {[Customer].[Country].&[Germany],[Customer].[Country].&[France]} set of attribute
members.
New members added to the attribute are visible by default.
What should you do?

• A. Add the following set to the Allowed Set property. Extract({[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]} ,[Customer].[Country])
• B. Add the following set to the Denied Set property. Except([Customer].[Country].[Country] ,{[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]})
• C. Add the following set to the Denied Set property. {[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]}
• D. Add all the country members except those of France and Germany to the Allowed Set property.