CORRECT TEXT
You are designing a package control flow. The package moves sales order data from a SQL Azure
transactional database to an on-premise reporting database. The package will run several times a day,
while new sales orders are being added to the transactional database. The current design of the package
control flow is shown in the answer area. (Click the Exhibit button.)
The Insert New Orders Data Flow task must meet the following requirements:
• Usage of the tempdb database should not be impacted.
• Concurrency should be maximized, while only reading committed transactions.
• If the task fails, only that task needs to be rolled back.
You need to configure the Insert New Orders Data Flow task to meet the requirements.How should you configure the transaction properties? (To answer, select the appropriate setting or
settings in the answer area.)
Answer: 
Explanation:
IsolationLevel = ReadCommited.
TransactionOption = RequiredReferences:
http://msdn.microsoft.com/en-us/library/ms137690.aspx
http://msdn.microsoft.com/en-us/library/ms137749.aspx
http://msdn.microsoft.com/enus/library/microsoft.sqlserver.dts.runtime.dtscontainer.isolationlevel.aspx
http://msdn.microsoft.com/en-us/library/ms173763.aspx
For the Transaction Option, I think not supported. The requirement was not to roll back any step except the current one. If it enlists in a transaction then a failure by the current step could roll back previous steps as well.
0
1