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?
Which two actions should you perform?
You are a database administrator for AIOTestKing.com. You are configuring a new SQL Server 2005 computer. The computer contains five hard disks. You need to ensure that the server can continue functioning in the event that a single hard disk fails. 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 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?
What should you do?
You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 application. Users report that the application sometimes responds very slowly for several minutes at a time. This problem occurs throughout the day and typically takes place after a large number of database rows are deleted. The database properties are configured as shown in the exhibit. (Click the Exhibit button.) 
You need to ensure that this performance problem does not recur. 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?
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. You create a security template that disables unnecessary services. The template is appropriate only for AIOTestKingA. You need to ensure that the security template is applied to AIOTestKingA. Your solution must ensure that the template automatically overrides any manual configuration changes made by other administrators within an hour. What should you do?
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.)
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing B. AIOTestKing B runs a single SQL Server instance. You manage AIOTestKing B from an administrative workstation named DBA1. AIOTestKing B intermittently fails to respond to user queries. Currently, it is not responding to your connection through SQL Server Management Studio. You need to correct the problem. What should you do?
What should you do?
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?
What should you do?
You are a database administrator for AIOTestKing.com. You are responsible for 20 SQL Server 2005 computers. These computers are monitored by other administrators who are required to ensure that query response times meet company service level agreements (SLAs). You need to provide these administrators with a consistent way of monitoring query response times on the servers. What should you do?