nerdexam
Microsoft

98-364 · Question #186

You have a table named Product that contains one million rows. You need to search for product information in the Product table by using the product's unique ID. What will make this type of search…

The correct answer is D. an index. See the full explanation below for the reasoning.

Question

You have a table named Product that contains one million rows. You need to search for product information in the Product table by using the product's unique ID. What will make this type of search more efficient?

Options

  • Aa cursor
  • Ba subquery
  • Ca trigger
  • Dan index

How the community answered

(39 responses)
  • A
    3% (1)
  • B
    10% (4)
  • C
    3% (1)
  • D
    85% (33)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice