There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to several SQL Server databases.
Within PassGuideApp there is a function PG_fn.
PG_fn changes a product record, that are stored in severalSQL Server databases, within a
single transaction.
How can ensure that the transactions can be recovered? Select two.
A.
In the transaction class..
B.
In the transaction recover class..
C.
In the transaction manager class..
D.
..use the Try method.
E.
..use the Recovery Complete.
F.
..use the Enlist Volatile method.
G.
..use the Enlist Durable method.
H.
..use the Recover method.
I.
..use the Reenlist method.
Explanation:
The specified answer is wrong. It should be:
In the transaction class…
…use the EnlistDurable method.
Source: http://msdn.microsoft.com/en-us/library/ms172153%28v=vs.85%29.aspx
Durable Enlistment:
The EnlistDurable methods are used to enlist a resource manager for participation in the transaction as a durable resource. It is expected that if a durable resource manager is brought down in the middle of a transaction, it CAN PERFORM RECOVERY once it is brought back online by reenlisting (using the Reenlist method).
Volatile Enlistment:
Participants managing volatile resources such as a cache should enlist using the EnlistVolatile methods. Such objects might NOT BE ABLE TO obtain the outcome of a transaction or RECOVER the state of any transaction they participate in after a system failure.
0
0