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 AUTOB. Move the index to a filegroup on its own driveC. Set change tracking on the index to MANUAL and schedule a nightly population update.D. Set change tracking on the index to OFF