nerdexam
Microsoft

70-450 · Question #18

70-450 Question #18: Real Exam Question with Answer & Explanation

The correct answer is A. Configure the linked server to use distributed transactions.. A distributed transaction can be executed via a linked server using BEGIN DISTRIBUTED This will guarantee that the entire batch will complete or fail. Two-phase commit is a transaction protocol employed by the MSDTC to ensure this is possible. The service broker is for distributi

Question

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?

Options

  • AConfigure the linked server to use distributed transactions.
  • BConfigure a Service Broker to enable the appropriate transaction control.
  • CEnsure that the linked server is appropriately configured for delegation.
  • DEnsure that the linked server is appropriately configured for impersonation.

Explanation

A distributed transaction can be executed via a linked server using BEGIN DISTRIBUTED This will guarantee that the entire batch will complete or fail. Two-phase commit is a transaction protocol employed by the MSDTC to ensure this is possible. The service broker is for distributing heavy workloads across multiple database instances. Delegation and impersonation are for passing credentials from one server/instance to another. Delegation passes windows credentials; Impersonation passes a SQL Server login.

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-450 Practice