nerdexam
Microsoft

70-433 · Question #106

You are writing a batch that contains multiple UPDATE statements to modify existing products. You have placed these updates into one explicit transaction. You need to set an option at the beginning…

The correct answer is B. XACT_ABORT. See the full explanation below for the reasoning.

Question

You are writing a batch that contains multiple UPDATE statements to modify existing products. You have placed these updates into one explicit transaction. You need to set an option at the beginning of the transaction to roll back all changes if any of the updates in the transaction fail. Which option should you enable?

Options

  • AARITHABORT
  • BXACT_ABORT
  • CIMPLICIT_TRANSACTIONS
  • DREMOTE_PROC_TRANSACTIONS

How the community answered

(29 responses)
  • A
    17% (5)
  • B
    72% (21)
  • C
    3% (1)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice