nerdexam
Microsoft

70-451 · Question #26

You have a stored procedure that is used to set up maintenance tasks. The stored procedure executes every night. The stored procedure contains three critical data manipulation language (DML)…

The correct answer is D. TABLOCKX. See the full explanation below for the reasoning.

Question

You have a stored procedure that is used to set up maintenance tasks. The stored procedure executes every night. The stored procedure contains three critical data manipulation language (DML) statements that operate against a single table. You need to prevent users from modifying any data in the table while the stored procedure executes. Which locking hint should you use?

Options

  • ANOLOCK
  • BREADCOMMITTED
  • CREPEATABLEREAD
  • DTABLOCKX

How the community answered

(22 responses)
  • A
    14% (3)
  • B
    5% (1)
  • C
    5% (1)
  • D
    77% (17)

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice