nerdexam
Microsoft

70-516 · Question #175

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database. The application uses nested transaction scopes. An inner transaction scope…

Sign in or unlock 70-516 to reveal the answer and full explanation for question #175. The question stem and answer options stay visible for context.

Implementing Data Access

Question

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database. The application uses nested transaction scopes. An inner transaction scope contains code that inserts records into the database. You need to ensure that the inner transaction can successfully commit even if the outer transaction rolls back. What are two possible TransactionScope constructors that you can use for the inner transaction to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

Options

  • ATransactionScope(TransactionScopeOption.Required)
  • BTransactionScope()
  • CTransactionScope(TransactionScopeOption.RequiresNew)
  • DTransactionScope(TransactionScopeOption.Suppress)

Unlock 70-516 to see the answer

You've previewed enough free 70-516 questions. Unlock 70-516 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#TransactionScope#nested transactions#RequiresNew#Suppress
Full 70-516 Practice