Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Microsoft 70-445
Title
: TS:MS SQL Server 2005
Business
Intelligence-Implem &
Mainte
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The package has the following features:
Two Data Flow tasks and two Control Flow tasks
A success constraint between each Data Flow task and the subsequent Control Flow task
The package uses one transaction for all the tasks.
You need to configure the package so that the two Data Flow tasks use their own transactions. You also
need to ensure that each Control Flow task is enlisted in the same transaction as its preceding Data Flow
task.
Which three actions should you perform? (Each correct answer presents part of the solution. Choose
three.)
A. Change the TransactionOption property to Supported for the package.
B. Change the TransactionOption property to Required for the package.
C. Change the TransactionOption property to Supported for each Data Flow task.
D. Change the TransactionOption property to Required for each Data Flow task.
E. Change the TransactionOption property to Supported for each Control Flow task.
F. Change the TransactionOption property to Required for each Control Flow task.
Answer: ADE
2. You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package
contains 30 Data Flow tasks and 30 Control Flow tasks. The package runs slower than expected. You need
to capture the start time, the finish time, and the elapsed time for the validation and execution of the
package. What should you do?
A. Enable the OnProgress event handler and use the Control Flow tasks to write the information to a log.
B. Monitor the Progress tab during the execution of the package, and then monitor the Execution Results
tab.
C. Use the Performance Monitor tool to capture the counters from the SQL Server: SSIS