Home » Microsoft » MB6-886 » What should you do?
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.
Correct Answer: D
Explanation/Reference:
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.