You have a server that runs SQL Server 2008. The server supports an online application.
New products are constantly being added to a database stored on the server. You identify
the following: • Searches often take too long • Users cannot search by using multiple criteria
• Users cannot adequately search product descriptions • Most queries that search the
product descriptions use “LIKE *%…%”‘ as the filter predicate You need to recommend a

search process that meets the following requirements: • Reduces the amount of time it
takes to return search results • Enables users to filter searches by using multiple criteria •
Enables users to search product descriptions • Minimizes administrative effort • Minimizes
development costs What should you do?

A.
Create filtered indexes on the product description.

B.
Implement Full-Text Search.

C.
Create a stoplist that contains the product descriptions.

D.
Create a nonclustered index and include the product description.