nerdexam
Dell-EMC

E20-880 · Question #32

Which tool provides recommendations on how query processing performance can be improved by modifying physical design structures such as indexes, indexed views, and partitioning?

The correct answer is A. Tuning Advisor. See the full explanation below for the reasoning.

Question

Which tool provides recommendations on how query processing performance can be improved by modifying physical design structures such as indexes, indexed views, and partitioning?

Options

  • ATuning Advisor
  • BQuery Editor
  • CSQL Activity Monitor
  • DPerformance Monitor

How the community answered

(52 responses)
  • A
    83% (43)
  • B
    4% (2)
  • C
    4% (2)
  • D
    10% (5)

Community Discussion

No community discussion yet for this question.

Full E20-880 Practice