You have a table in a database that contains 30 million rows. You need to ensure that the table meets the following requirements:
* Enables queries on all string values within the table
* Enables queries to be returned by order of proximity
* Minimizes the amount of time required to execute queries
What should you do?
A.
Create a filtered index.
B.
Create a clustered index.
C.
Configure Service Broker.
D.
Configure a Full-Text-Search.
Explanation:
SQL Server 2008 provides the functionality for applications and users to issue full-text queries against character-based data in SQL Server tables. Before full-text queries can be run on a given table, the database administrator must create a full-text index on the table. The full-text index includes one or more character-based columns in the table. These columns can have any of the following data types: char, varchar, nchar, nvarchar, text, ntext, image, xml, varbinary, or varbinary(max). Each full-text index indexes one or more columns from the base table, and each column can have a specific language.