nerdexam
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

70-432 question #187 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(40 responses)
  • A
    10% (4)
  • B
    3% (1)
  • C
    3% (1)
  • D
    85% (34)

Community Discussion

No community discussion yet for this question.

Full 70-432 Practice