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…
Question
Given the following, what is the declared block size?
Exhibit
Options
- A1920 bytes
- B480 bytes
- C3840 bytes
- D12450 bytes
How the community answered
(40 responses)- A8% (3)
- B3% (1)
- C80% (32)
- D10% (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
Community Discussion
No community discussion yet for this question.
