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 are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package includes five Data Flow tasks and three Control Flow tasks. You need to modify the package so that two Control Flow tasks and one Data Flow task fail or succeed as a unit. What should you do?

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. 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 create a dimension that contains a parent-child hierarchy. The dimension has a key attribute named Employee and a parent attribute named Employees. You need to ensure that the dimension identifies the topmost employee member of the hierarchy as the root member. What should you do?

You need to create a package that must meet the following requirements:

It must be transactional. It must be optimized for 20 tables. It must be stored securely in the msdb database of a remote server.

What should you do?

Your server hosts Microsoft SQL Server 2000 Analysis Services (SSAS) databases and cubes. You need to perform the migration of a database from Analysis Services 2000 to Analysis Services 2005. 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 designing a data mining structure for a Microsoft SQL Server 2005 Analysis Services (SSAS) solution. The solution requires the use of relational data. You need to design the data mining structure so that the data mining models can use the data from a case table and a nested table. 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?