Microsoft
70-451 · Question #77
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…
The correct answer is D. Configure a Full-Text-Search. See the full explanation below for the reasoning.
Question
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?
Options
- ACreate a filtered index.
- BCreate a clustered index.
- CConfigure Service Broker.
- DConfigure a Full-Text-Search.
How the community answered
(45 responses)- A9% (4)
- B4% (2)
- C2% (1)
- D84% (38)
Community Discussion
No community discussion yet for this question.