nerdexam
Microsoft

98-364 · Question #162

One reason to add an index is to:

The correct answer is C. improve performance of select statements. See the full explanation below for the reasoning.

Question

One reason to add an index is to:

Options

  • Adecrease storage space.
  • Bincrease database security.
  • Cimprove performance of select statements.
  • Dimprove performance of insert statements.

How the community answered

(58 responses)
  • A
    9% (5)
  • B
    3% (2)
  • C
    71% (41)
  • D
    17% (10)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice