nerdexam
Dell-EMC

E20-326 · Question #206

You are assigned to design a storage solution for a customer's Oracle OLTP environment. The current configuration has performance issues. Users have complained about slow response. What knowledge…

The correct answer is A. Database tables and indexes are characterized by a large number of random I/Os. Redo logs are. See the full explanation below for the reasoning.

Question

You are assigned to design a storage solution for a customer's Oracle OLTP environment. The current configuration has performance issues. Users have complained about slow response. What knowledge about a typical Oracle OLTP workload will help in the redesign of the storage environment so that it runs more optimally?

Options

  • ADatabase tables and indexes are characterized by a large number of random I/Os. Redo logs are
  • BRedo logs are characterized by a large number of random I/Os. Database tables and indexes are
  • CDatabase tables, indexes, and redo logs are all characterized by a large number of sequential
  • DDatabase tables, indexes, and redo logs are all characterized by a large number of random I/Os.

How the community answered

(29 responses)
  • A
    83% (24)
  • B
    10% (3)
  • C
    3% (1)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full E20-326 Practice