Microsoft
70-432 · Question #187
You administer a Microsoft SQL Server 2008 R2 database that hosts an order-processing application. You need to ensure that the database allows full-text searches on the Customers table. You also…
The correct answer is D. Option D. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2008 R2 database that hosts an order-processing application. You need to ensure that the database allows full-text searches on the Customers table. You also need to ensure that the full-text index is ready for use by the users. You execute a Transact-SQL statement to create the full-text index on the Customers table by using the CHANGE_TRACKING OFF and NO POPULATION clauses in the CREATE FULLTEXT INDEX statement. You execute an ALTER FULLTEXT INDEX. Which command or commands should you use next?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(40 responses)- A10% (4)
- B3% (1)
- C3% (1)
- D85% (34)
Community Discussion
No community discussion yet for this question.
