Exam 70-463 topic 3 question 73 discussion

Actual exam question from Microsoft's 70-463

Question #: 73
Topic #: 3

HOTSPOT -
You are designing a package control flow. The package moves sales order data from a Microsoft Azure SQL Database 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.
Hot Area:

Show Suggested Answer

Suggested Answer:

IsolationLevel = ReadCommited -

TransactionOption = Required -
References:
https://docs.microsoft.com/en-us/sql/integration-services/integration-services-transactions https://docs.microsoft.com/en-us/sql/connect/jdbc/understanding-isolation-levels

by LuckyKatt at Jan. 6, 2020, 3:50 a.m.

Comments

Submit Cancel

cornford

4 years, 10 months ago

If the package uses the NotSupported option, the tasks can not roll back if they fail. We do want it to roll back. So without knowing the setting of the other tasks we must assume "required" is the correct answer. "supported" relies on a transaction existing and as we don't want to roll back the others we can assume the other tasks are set to "NotSupported".

upvoted 1 times

...

mickeygeorge

4 years, 12 months ago

I think the task should have its own transaction since only that task should be rolled back hence why the Required option is needed here

upvoted 2 times

...

LuckyKatt

5 years, 6 months ago

I think the TransactionOption should be Not Supported, as failure should not roll back anything outside of that task. If set to required, it will enlist to a pre-existing transaction and roll back anything that occurred in that transaction no failure.

upvoted 2 times

...