Microsoft
70-448 · Question #308
70-448 Question #308: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #308. The question stem and answer options stay visible for context.
Question
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Integration Services (SSIS) package for the company. The package not only uses a Data Flow task to import the contents of the files to a table, but also uses a ForEach Loop container to process multiple files. Besides, it uses an Execute SQL task to log the results of the status into a table. Now you are assigned a task to make sure that within a single transaction, both of a Data Flow task and a ForEach Loop container task are executed successfully, but the Execute SQL task fails to execute. What should you do to achieve this goal? (Each correct answer presents part of the solution. Choose two.)
Options
- AYou should have the TransactionOption property configured to Required in the package
- BYou should have the TransactionOption property configured to NotSupported in the Execute SQL task
- CYou should have the TransactionOption property configured to Required in the Data Flow task.
- DYou should have the TransactionOption property configured to Supported in the Execute SQL task
- EYou should have the TransactionOption property configured to NotSupported in the package
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.