Microsoft
70-451 · Question #47
Users frequently update millions of rows in a table at a time. Users report that it takes a long time to update the rows. You need to recommend a solution to reduce the time it takes to update the…
The correct answer is C. Split the update operation into small batches. See the full explanation below for the reasoning.
Question
Users frequently update millions of rows in a table at a time. Users report that it takes a long time to update the rows. You need to recommend a solution to reduce the time it takes to update the rows. The solution must be developed in the minimum amount of time. What should you do?
Options
- AUse a table variable.
- BUse a temporary table.
- CSplit the update operation into small batches.
- DUse the NOLOCK optimizer hint and use a single transaction.
How the community answered
(28 responses)- A4% (1)
- B11% (3)
- C82% (23)
- D4% (1)
Community Discussion
No community discussion yet for this question.