nerdexam
Oracle

1Z0-531 · Question #8

Given the following, what is the declared block size?

The correct answer is C. 3840 bytes. We need to multiple the stored (not the total) members of the dense dimensions (here Year: 12, Measures:20, and Scenario:2) with 8 to calculate the block size. Block size: 12x20x2x8 = 3840 Note: Data block size is determined by the amount of data in particular combination of…

Reporting and Integrations

Question

Given the following, what is the declared block size?

Exhibit

1Z0-531 question #8 exhibit

Options

  • A1920 bytes
  • B480 bytes
  • C3840 bytes
  • D12450 bytes

How the community answered

(40 responses)
  • A
    8% (3)
  • B
    3% (1)
  • C
    80% (32)
  • D
    10% (4)

Explanation

We need to multiple the stored (not the total) members of the dense dimensions (here Year: 12, Measures:20, and Scenario:2) with 8 to calculate the block size. Block size: 12x20x2x8 = 3840 Note: Data block size is determined by the amount of data in particular combination of dense dimensions. For ex: when you change the dense or sparse configuration of one or more dimensions in the database, the data block size changes. Data block size is 8n bytes, where n is the number of cells that exist (ie. Stored, not total) for that combination of dense dimensions.Note: Optimal range is 8 to 100 kb

Topics

#Essbase#block size#BSO#memory calculation

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice