Given the following, what is the block size In bytes?

The correct answer is B. Block size = 40 *17 * 2 * 8. We need to multiple the stored (not the total) members of the dense dimensions (here Measures: 40, Time:17, and Dense:2) with 8 to calculate the block size. Note: Data block size is determined by the amount of data in particular combination of dense dimensions. For ex: when you…

Reporting and Integrations

Question

Exhibit

Options

ABlock size = 40 * 17 * 2
BBlock size = 40 *17 * 2 * 8
CBlock size = 50 * 17 * 5
DBlock size = 50* 17*5 * 8

How the community answered

(40 responses)

A
15% (6)
B
75% (30)
C
3% (1)
D
8% (3)

Explanation

We need to multiple the stored (not the total) members of the dense dimensions (here Measures: 40, Time:17, and Dense:2) with 8 to calculate the block size. 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 calculation#performance

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice