PrepAway - Latest Free Exam Questions & Answers

What should you do to ensure that the transaction uses a two-phase commit?

You administer a SQL Server 2008 infrastructure.
You administer two SQL Server 2008 instances named Instance1 and Instance2. Instance1 contains the Sales database, and Instance2 contains the Accounts database.
A procedure in the Sales database starts a transaction. The procedure then updates the Sales.dbo.Order table and the Accounts.dbo.OrderHistory table through a linked server.
You need to ensure that the transaction uses a two-phase commit.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Configure the linked server to use distributed transactions.

B.
Configure a Service Broker to enable the appropriate transaction control.

C.
Ensure that the linked server is appropriately configured for delegation.

D.
Ensure that the linked server is appropriately configured for impersonation.


Leave a Reply