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

You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You have a machine named COMPANYCUBE for a SSAS instance. The COMPANYCUBE machine hosts a SSAS database that has a cube named HR. You need to restrict the local administrators from accessing any data stored in the HR 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?

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 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 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. You need to ensure that the package came from a trusted source. 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 model. Users must develop their own SSRS reports by using your report model in the Report Builder tool. The data source for the report model is a Microsoft SQL Server 2000 database that contains 900 tables and 700 views. You need to build a report model that allows users access to only the 10 tables that they require for reporting. What should you do?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. You create a report parameter named DisplayCol that contains the following properties: Data Type: Integer Prompt: Display Column Available Values: Non-queried with the following Label/Value pairs: oYes/1 oNo/0 Default Values: Null The report parameter is used to control the visibility of the column. You need to use the appropriate expression in the Hidden property for the column. Which expression should you use?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report that supports drilldown. You need to modify the report so that the detailed data is hidden when the report is initially rendered. What should you do?