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.
Configure a Full-Text-Search.
B.
Configure Service Broker.
C.
Create a filtered index.
D.
Create a clustered index.