Microsoft
70-451 · Question #107
70-451 Question #107: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #107. The question stem and answer options stay visible for context.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. Users report poor performance of a long-running query in a database. You fail to detect the cause of poor performance when you examine the estimated execution plan. On viewing the actual execution plan, you discover that several tasks are CPU-intensive. You need to ensure that you can view an estimated execution plan containing the most likely actions. You want to achieve this goal by incurring minimum possible CPU overhead. What should you do?
Options
- ARebuild all indexes.
- BUse the SET STATISTICS PROFILE ON statement.
- CUse the SET STATISTICS XML ON statement.
- DUpdate statistics on the appropriate tables.
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.