nerdexam
IBM

C2090-619 · Question #5

Which option provides the greatest performance benefit in an Informix warehouse environment?

The correct answer is C. Setting higher value of DS_TOTAL_MEMORY. See the full explanation below for the reasoning.

Question

Which option provides the greatest performance benefit in an Informix warehouse environment?

Options

  • ASetting lower value of PDQPRIORITY.
  • BIncreasing the number of B-Tree cleaners.
  • CSetting higher value of DS_TOTAL_MEMORY.
  • DSetting value of OPT_GOAL configuration variable to 0.

How the community answered

(23 responses)
  • A
    9% (2)
  • B
    4% (1)
  • C
    83% (19)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-619 Practice