70-516 · Question #29
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to several SQL Server databases. You create a function that modifies customer…
The correct answer is B. Call the EnlistDurable method of the Transaction class. Volatile resource managers cannot recovery from failure to complete a transaction in which they were participating. To obtain a durable enlistment in a transaction, use the EnlistDurable method. For more information on volatile and durable resources, as well as how to enlist a…
Question
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to several SQL Server databases. You create a function that modifies customer records that are stored in multiple databases. All updates for a given record are performed in a single transaction. You need to ensure that all transactions can be recovered. What should you do?
Options
- ACall the EnlistVolatile method of the Transaction class.
- BCall the EnlistDurable method of the Transaction class.
- CCall the Reenlist method of the TransactionManager class.
- DCall the RecoveryComplete method of the TransactionManager class.
How the community answered
(26 responses)- B85% (22)
- C12% (3)
- D4% (1)
Explanation
Volatile resource managers cannot recovery from failure to complete a transaction in which they were participating. To obtain a durable enlistment in a transaction, use the EnlistDurable method. For more information on volatile and durable resources, as well as how to enlist a resource, see Implementing A Resource Manager. For more information on how a resource manager responds to commit notification and prepare the commit, see Committing A Transaction In Single-Phase and Multi-Phase.
Topics
Community Discussion
No community discussion yet for this question.