Question 27

Answer A is correct. Before executing full-text searches, you must create and populate a full-text catalog. Population usually occurs when the catalog is created. A full-text catalog is the basis of the storage used for indexes. These catalogs should periodically be repopulated to ensure usefulness. Repopulation can be done by schedule or by administrative task.

For more information, see the following sources:

• Chapter 2, "Creating Database Objects," and Chapter 3, "Implementing Database Objects"

• SQL Server 2005 Books Online: "Full-Text Search"

• "SQL Server 2005 full-text search includes improved and updated noise word files," http://support.microsoft.com/default.aspx?scid=kb;en-us;905617

• Within MSDN Library, go to MSDN Home, SQL Server Developer Center, Community, Webcasts, Full-Text Search Q and A.