Microsoft
70-432 · Question #51
70-432 Question #51: Real Exam Question with Answer & Explanation
The correct answer is B. You should rebuild the full-text index. See the full explanation below for the reasoning.
Question
You are the administrator in charge of two instances both of which run on the same computer. One is a SQL Server 2008 instance; another is a SQL Server 2005 instance. There is a database named DB1 in the SQL Server 2008 instance. DB1 uses the Fulltext indexes. Several records that include the word "root" are added to DB1. An empty resultset is returned when the Fulltext index is queried for the word "root." You have to make sure the query can return records that contain the word "root". What should you do?
Options
- AYou should terminate and restart the MSFTESQL service
- BYou should rebuild the full-text index
- CThe word "root" should be added to the stop list
- DThe word "root" should be added to the thesaurus file
Community Discussion
No community discussion yet for this question.