You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) accounting report.
Every other line of output in the report table must have a green background. You need to use the appropriate expression for the BackgroundColor property of the table. Which expression should you use?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. You need to ensure that the package came from a trusted source. What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS)package.The OLE DB

data source for the package is a database that is updated frequently.You need to create a package that

accomplishes the following tasks:

Implement the IRowsetFastLoad interface.Support various data flow destinations. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.

The package uses at least one sequence container in one transaction. Each transaction controls a Data Flow task and a Control Flow task. Each Data Flow task has a Success constraint.

The Control Flow task follows the Success constraint. The package must include the following requirements:

Each Data Flow task must use its own transaction.
The Control Flow task and the Data Flow task that precedes it must succeed or fail as an atomic unit.

A restart point must restart each Data Flow task and the Control Flow task that follows it as an atomic unit.

You need to make changes in the control flow designer to meet the outlined requirements.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report.

The report must meet the following specifications:

When the report is run from a Helpdesk application, the report toolbar must not be displayed. When the report is run from an Intranet Portal application, the report toolbar must display the list of parameters only on the request of the user.

You need to provide the report URL for each application.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package must be deployed on 10 servers. You do not have access to the file system on any of these 10 servers. You need to set different package configuration properties at the package run time. What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.

The project has the following objects:

A cube named SalesData for a database named SalesDB.
Two dimensions named Region and Gender.
A role named Employee that has the Read permission set for the cube.

You need to modify the Employee role definition to allow the SalesData cube to be browsed only by using the Region dimension.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.

While testing, a Transact-SQL user-defined function causes duplicate key values that stop the transformation.

To permit the transformation to continue, the package must perform the following tasks:

1 Ascertain which rows are affected.
2 Insert the rows that fail into a table.
3 Continue with the process.

You need to change certain properties in the package to meet the requirements.

Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)

You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You have a cube in an SSAS instance. You notice that the queries run slowly. You need to identify the queries that run slowly and change the storage configuration of the cube. What should you do?

You create a package by using 47 Execute SQL Control Flow tasks. The Execute SQL task returns an error during a calculation of a percentage change over time. You need to add an event handler to the package that processes all of the messages that are returned from each task. Which event handler should you use?