You develop a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a parameter named @SalesTax8ateID.
You set the value of the @SafesTaxRateID parameter in the report by selecting a specific
region.
You need to configure the report to prevent users from modifying the value of the
@SalesTaxRateID parameter.
What should you do?

You develop a SQL Server 2008 Reporting Services (SSRS) project.
The report will display data from a SQL Server 2005 Analysis Services database.
You need to ensure that the report displays member properties and extended properties.
What should you do?

You are developing a sales report by using SQL Server 2008 Reporting Services (SSRS).
The report contains a table.
You need to implement a technology that allows users to open a new report when they click
on a field in a table.
Which SSRS technology should you use?

You create a SQL Server 2008 Reporting Services (SSRS) report. The report contains a
report header and a report footer.
The report preview shows that the report is rendered correctly. You discover that when the
report is rendered as a PDF file, even-numbered pages are rendered blank.
You need to modify the report to prevent the rendering of blank pages.
What should you do?

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?

You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the
package by using your local development environment.
The package is deployed to a production server.
You need to configure the protection level of the package to ensure that only the user who
deployed the package can execute it.
Which protection level should you use?

You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the
package by using your local development environment.
You deploy the package to the file system in the production environment. The users report
that the connection strings contained in the package are blank. The package fails to execute.
You need to change the protection level of the package to ensure that users can view and
execute the package.
Which protection level should you use?

You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a dimension
named Account and a time dimension named Time. You have a fact table that contains a
column named CurrentBalance. CurrentBalance contains the current account balance.
You need to create a measure named AccountBalance from the CurrentBalance column to
display the closing account balance for a time period.
What should you do?

You create a SQL Server 2008 Analysis Server (SSAS) solution.
Your solution contains a measure group named FactMeasures with a single partition.
You need to ensure that the following requirements are met:
Queries that use FactMeasures always refer to the latest version of the source detail data.
All aggregations that are part of FactMeasures are stored in a multidimensional format.
Which storage mode should you set the ProactiveCaching property of the partition to?

You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a date
dimension named Date along with a hierarchy named Calendar. The Calendar hierarchy has
levels for the Year, Quarter, Month, and Date attributes. You need to create a named set
that refers to the first seven months of the year 2007. Which expression should you write for
the named set?