70-463 · Question #117
You are currently discussing an EventHandlerClass property that is used to retrieve or configure a value that indicates whether the container participates in transactions. Which of the following is…
The correct answer is A. The TransactionOption property. The TransactionOption property on an SSIS container controls whether that container enlists in, starts, or ignores transactions during execution.
Question
You are currently discussing an EventHandlerClass property that is used to retrieve or configure a value that indicates whether the container participates in transactions. Which of the following is the EventHandlerClass property that you are discussing?
Options
- AThe TransactionOption property.
- BThe Executables property.
- CThe LoggingOptions property.
- DThe Variables property.
How the community answered
(40 responses)- A95% (38)
- B3% (1)
- C3% (1)
Why each option
The TransactionOption property on an SSIS container controls whether that container enlists in, starts, or ignores transactions during execution.
TransactionOption is the property that retrieves or sets a value indicating whether the container participates in transactions. It accepts values of Supported, NotSupported, or Required, directly governing transactional behavior for the container.
The Executables property is a collection that holds the child executables (tasks or containers) within a container, unrelated to transaction participation.
The LoggingOptions property controls how logging is configured for the container, not transaction behavior.
The Variables property exposes the collection of variables scoped to the container, not transaction settings.
Concept tested: SSIS container TransactionOption property
Source: https://learn.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.dts.runtime.eventhandler.transactionoption
Topics
Community Discussion
No community discussion yet for this question.