Microsoft
70-459 · Question #79
70-459 Question #79: Real Exam Question with Answer & Explanation
Sign in or unlock 70-459 to reveal the answer and full explanation for question #79. The question stem and answer options stay visible for context.
Question
You need to monitor the health of your tables and indexes in order to implement the required index maintenance strategy. What should you do?
Options
- AQuery system DMVs to monitor avg_chain_length and max_chain_length.
- BCreate a SQL Agent alert when the File Table:
- CQuery system DMVs to monitor total_bucket_count.
- DQuery system DMVs to monitor total_bucket_count.
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.