Microsoft
70-459 · Question #102
70-459 Question #102: Real Exam Question with Answer & Explanation
Sign in or unlock 70-459 to reveal the answer and full explanation for question #102. The question stem and answer options stay visible for context.
Question
You have a SQL Server 2012 database named Database1. You execute the following code: You insert 3 million rows into Sales. You need to reduce the amount of time it takes to execute Proc1. What should you do?
Exhibit
Options
- ARun the following:
- BChange the WHERE clause to the following:
- CRemove the ORDER BY clause from the stored procedure.
- DRun the following:
Unlock 70-459 to see the answer
You've previewed enough free 70-459 questions. Unlock 70-459 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.