1Z0-531 · Question #64
Block size is calculated by the following formula.
The correct answer is C. Number of stored dense dimension members multiplied together times 8 bytes. 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…
Question
Block size is calculated by the following formula.
Options
- ANumber of stored sparse dimension members multiplied together times 8 bytes
- BNumber of total sparse dimension members multiplied together times 8 bytes
- CNumber of stored dense dimension members multiplied together times 8 bytes
- DNumber of total dense dimension members multiplied together times 8 bytes
How the community answered
(28 responses)- A4% (1)
- B14% (4)
- C75% (21)
- D7% (2)
Explanation
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 We need to multiple the stored (not the total) members of the dense dimensions with 8 to calculate the block size.
Topics
Community Discussion
No community discussion yet for this question.