nerdexam
Microsoft

70-433 · Question #137

70-433 Question #137: Real Exam Question with Answer & Explanation

The correct answer is A. SELECT * FROM Inventory. See the full explanation below for the reasoning.

Question

Your company manufactures and distributes bicycle parts. You have a full-text catalog on the Inventory table which contains the PartName and Description columns. You also use a full-text thesaurus to expand common bicycle terms. You need to write a full-text query that will not only match the exact word in the search, but also the meaning. Which Transact-SQL statement should you use?

Options

  • ASELECT * FROM Inventory
  • BSELECT * FROM Inventory
  • CSELECT * FROM Inventory
  • DSELECT * FROM Inventory

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice