16. Some of your full-text indexes are consuming a lot of server resources. You
investigate and discover that the index causing the problem is on a text-based
field that is updated frequently. You’ve spoken to the business, and the updates
don’t affect their search results. What could you do to reduce the overall
impact on the server while keeping the index fairly up-to-date?
A. Set change tracking on the index to AUTO
B. Move the index to a filegroup on its own drive
C. Set change tracking on the index to MANUAL and schedule a nightly
population update.
D. Set change tracking on the index to OFF
Correct Answer & Explanation: C. This will still track changes but switches off
auto propagation to the index. A nightly update will process all the tracked
changes.
Incorrect Answers & Explanations: A,B, D. Answer A is incorrect; change
tracking is already at the default setting of AUTO, and that is what is causing
the problem. Answer B is incorrect because you want to reduce overall impact,
and this option will only directly affect disk i/o. Answer D is incorrect because
there is no method specified to keep the index updated.
Bạn đang xem 16. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P144 PPSX