Which impersonation information should you use?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) solution by using Business Intelligence Development Studio (BIDS). The SSAS instance runs under a local system account.
A trust relationship exists between the machine that hosts the SSAS instance and the data source. You need to use the Impersonation Information dialog box to create a data source that SSAS can connect to when SSAS is deployed from any workstation. Which impersonation information should you use?
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?
What should you do?
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?
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?
What should you do?
You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You notice unusually high CPU utilization in the msmdsrv.exe every day during business hours. You need to identify the source of the high CPU utilization without requiring user interaction to stop and start traces. What should you do?
Which two actions should you perform?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The OLE DB data source for the package is a database that is updated frequently.
You need to create a package that accomplishes the following tasks:
Implement the IRowsetFastLoad interface.
Support various data flow destinations.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
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?
What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package contains a Data Flow task that references a CustomerHistory table. The Data Flow task raises errors when the CustomerHistory table is not available. You need to edit a property in the Data Flow task to avoid errors in the development of the package and to permit the execution of the package. What should you do?
Which event handler should you use?
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?
Which two actions should you perform?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The package uses at least one sequence container in one transaction. Each transaction controls a Data Flow task and a Control Flow task. Each Data Flow task has a Success constraint. The Control Flow task follows the Success constraint.
The package must include the following requirements: Each Data Flow task must use its own transaction. The Control Flow task and the Data Flow task that precedes it must succeed or fail as an atomic unit. A restart point must restart each Data Flow task and the Control Flow task that follows it as an atomic unit.
You need to make changes in the control flow designer to meet the outlined requirements.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)