Microsoft
70-448 · Question #139
70-448 Question #139: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #139. The question stem and answer options stay visible for context.
Question
You are creating a SQL Server 2008 Integration Services (SSIS) instance for Company.com. The package displays job listed below: - You should operate multiple files through utilizing a For Each Loop container. - You should get the files' content to a table through utilizing a Data Flow task. - Through utilizing an Execute SQL task, you should Log the results of the state into a table - You should make sure that the Execute SQL task only could not run in one transaction. Which is the correct answer? (Select more than one)
Options
- AYou should set the TransactionOption property to RequiredNew in the package.
- BYou should set the TransactionOption property to Supported in the package.
- CYou should set the TransactionOption property to Required in the package.
- DYou should set the TransactionOption property to None in the package.
- EYou should set the TransactionOption property to NotSupported in the Execute SQL task.
- FYou should set the TransactionOption property to Supported in the Execute SQL task.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.