You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package contains 20 Data Flow tasks. After executing the package, you notice an unexpected distribution of values in a table. You need to generate a histogram and view the histogram after each transformation. What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package contains a Data Flow task with a Fuzzy Grouping transformation that creates data. The output of the Fuzzy Grouping transformation is incorrect. You need to view the output data of the Fuzzy Grouping transformation to debug the package. What should you do?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report uses a dataset that is based on a Data Mining Extensions (DMX) prediction query. The query forecasts the probability of purchases for buyers when specific inputs are given. Users want to select the values at runtime that might be used to forecast the probability of a purchase. You need to implement two report parameters named @buyer and @probability that will be used to control the DMX query at report runtime. Which DMX WHERE clause should you use?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The execution of the report must trigger an event for Notification Services by using a custom assembly. You need to write a custom code function named RSNotify that will parse the data from a field named ProductValue and execute the custom assembly within the report. Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report has three columns in a table. The columns are named MachineName, MachineMfr, and MachineModel. The report navigation options must allow users to click on a row from the MachineName column and drill through to another report, and then pass the contents of the MachineName column as a parameter named MachineName. You need to configure the report navigation options to satisfy the user requirements. Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)

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 Reporting Services (SSRS) report. The report has a column of data that must be displayed and printed by using a strikethrough text. You need to modify the appropriate property of a text field to represent the proper text formatting. What should you do?

You administer a Microsoft SQL Server 2005 Reporting Services (SSRS) instance. You have remote access to e-mail and HTTP only. A user must create a report based on a Microsoft SQL Server 2005 Analysis Services (SSAS) cube. No report model is currently available for the cube. The user can access the cube through the Microsoft Office Excel application and is a member of the System User role. You need to help the user create a report by using the SSRS Report Builder utility. What should you do?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report uses a dataset that calls a Microsoft SQL Server stored procedure. The stored procedure requires three input parameters that cannot be Null.

The report must meet the following requirements when it runs:

Each of the stored procedure input parameters must be used. All parameter values must be selected from the drop-down lists. Only valid values must be used for input parameters.

You need to set the Report Parameters dialog box configurations to meet the outlined requirements.

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

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) matrix report. You use the SSRS Report Wizard to create the report. The report is based on a Microsoft SQL Server 2005 Analysis Services (SSAS) dataset. The dataset consists of a single measure named Total Sales, and two dimension attributes named Store Name and Month. You need to drag the Total Sales measure to a report section to display a table with values for Total Sales for each month. Which report section should you use?