Microsoft-TS Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance Set 3

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. 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 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 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 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) 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?

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 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 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 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?