Microsoft
70-451 · Question #47
70-451 Question #47: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #47. The question stem and answer options stay visible for context.
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.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 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.