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)- A14% (3)
- B5% (1)
- C5% (1)
- D77% (17)
Community Discussion
No community discussion yet for this question.