SOME OF YOUR FULL-TEXT INDEXES ARE CONSUMING A LOT OF SERVER RESOU...

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.