70-432 · Question #51
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…
Sign in or unlock 70-432 to reveal the answer and full explanation for question #51. The question stem and answer options stay visible for context.
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
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.