Given the following information, what is the block size?

The correct answer is B. 400 Bytes. We need to multiple the stored (not the total) members of the dense dimensions (here Accounts: 10, Time:5) with 8 to calculate the block size. Block size: 10 x 5 x 8 = 400 Note: Data block size is determined by the amount of data in particular combination of dense dimensions…

Essbase Architecture

Question

Exhibit

Options

A400 KB
B400 Bytes
C1056 KB
D50 Bytes
E1056 Bytes
F50 KB
G70 KB

How the community answered

(22 responses)

A
9% (2)
B
77% (17)
C
9% (2)
E
5% (1)

Explanation

We need to multiple the stored (not the total) members of the dense dimensions (here Accounts: 10, Time:5) with 8 to calculate the block size. Block size: 10 x 5 x 8 = 400 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

#block size calculation#dense dimensions#BSO#storage sizing

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice