You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The source of the SSRS report data is a Transact-SQL stored procedure. The procedure does not have any input parameters and returns all records in a set of tables. Three other applications that run on Microsoft SQL Server also use the stored procedure. You need to limit the amount of data that is displayed on the report without affecting any other applications that use the stored procedure. What should you do?

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 Reporting Services (SSRS) report. The report dataset consists of a WHERE clause: WHERE machineID IN (@machineID). The values in the machineID column change constantly. When the report is run, users must be prompted to use a list of valid values for the @machineID parameter. When the report is run, a list of valid values for the @machineID parameter must be made available to populate the @machineID dataset parameter. You need to create a Multi-value report parameter that will meet the requirement. What should you do?

You have designed and saved 35 Microsoft SQL Server 2005 Integration Services (SSIS) packages.
The packages are stored in a single folder on the network. All the team members can view the packages but not the property values. You need to ensure that the property values are password protected. What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. A task processes rows of data from a table in the package. You decide to log the number of processed rows to Windows Event Log. You need to set a logging property on the task to ensure that the number of processed rows is logged each time the package runs. Which property should you use?

You create a Microsoft SQL Server 2005 Integration Services (SSIS) project by using Business Intelligence Development Studio (BIDS). The project contains 75 SSIS packages stored in the file system that perform various maintenance tasks. The SSIS packages must be available to the Quality Assurance (QA) team to test the packages on the test server. You need to create a package deployment utility that allows the QA team to deploy each of these packages on the test server. 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 is named UpdateTable.dtsx and contains a variable named runID. The package must run by using the dtexec utility. The runID variable must be set at runtime to a value of 5. You need to meet the outlined requirements. What should you do?

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 designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is connected to a database on your development server by using a connection manager. You decide to use the DTExecUI utility to run the package. You need to change the connection of the connection manager to a different server at run time without using a package configuration file. What should you do?

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

You have a cube named SalesCube that contains the following objects:

A measure group named Sales that contains a measure named Internet Sales Amount.
A dimension named DimProduct that contains a hierarchy named Product Category. The hierarchy contains the Category attribute on the first level, the Subcategory attribute on the second level, and the Product attribute on the third level.
You need to write a Multidimensional Expressions (MDX) query that displays only the product names and the Internet sales amount for each product.

Which query should you use?