nerdexam
Oracle

1Z0-531 · Question #38

With an average block density greater than 90%.

The correct answer is B. You should consider no compression. Hyperion recommends that you should turn compression off if you have a block density > 90% (rarely happens) and you should change to RLE compression when the block density is < 3% (or if you have all the same values in the database - lots of zeros). Note: You may want to…

Performance Tuning

Question

With an average block density greater than 90%.

Options

  • AYou should reconsider the dense and sparse settings
  • BYou should consider no compression
  • CYou should set Commit blocks to
  • DYou should reconsider the outline order of dimensions

How the community answered

(34 responses)
  • A
    3% (1)
  • B
    79% (27)
  • C
    6% (2)
  • D
    12% (4)

Explanation

Hyperion recommends that you should turn compression off if you have a block density > 90% (rarely happens) and you should change to RLE compression when the block density is < 3% (or if you have all the same values in the database - lots of zeros). Note: You may want to disable data compression if blocks have very high density (90% or greater) and have few consecutive, repeating data values. Under these conditions, enabling compression consumes resources unnecessarily. Don't use compression if disc space/memory is not an issue compared to your application. It can become a drain on the processor.

Topics

#block density#compression strategy#dense sparse settings#performance

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice