What is the block size in bytes?

Given the following:
Measures (Dense): 40 stored members, 50 total members
Time (Dense): 17 stored members, 17 total members
Scenario (Dense): 2 stored members, 5 total members
Market (Sparse): 100 stored members, 100 total members
Product(Sparse): 500 stored members, 550 total members
What is the block size in bytes?

Given the following:
Measures (Dense): 40 stored members, 50 total members
Time (Dense): 17 stored members, 17 total members
Scenario (Dense): 2 stored members, 5 total members
Market (Sparse): 100 stored members, 100 total members
Product(Sparse): 500 stored members, 550 total members
What is the block size in bytes?

A.
Block size = 40 * 17 * 2

B.
Block size = 40 * 17 * 2 * 8

C.
Block size = 50 * 17 * 5 * 8

D.
Block size = 50 * 17 * 5

E.
Block size = 100 * 500 * 8

F.
Block size = 100 * 500

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *