You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The SQL Server 2008 instance contains a database named CK_Prod which make
use of the Fulltext indexes. However, some of the records have the word ‘root’ in CK_Prod. This
causes the Fulltext index, when searching for the root word, an empty resultset.
You need to include ‘root’ in the query that returned.
What should you do?
A.
You should consider adding a full-text index.
B.
You should consider changing a full-text index.
C.
You should consider rebooting the MSFTESQL services.
D.
You should consider reproducing the full-text index.