1Z0-531 · Question #16
Identify the two true statements about compression for block storage databases.
The correct answer is B. RLE compression works well for consecutive zero values or repeating values within a database. C. Bitmap compression is the default compression method. B: RLE (Run Length Encoding) is a good compression type when your data has many zeros (block density low) or often repeats. RLE uses multiple compression compressions (one per block). RLE will use RLE, bitmap or IVP. C: By default, Bitmap compression is enabled. To switch to a…
Question
Identify the two true statements about compression for block storage databases.
Options
- AIndex value pair compression works well for consecutive zero values or repeating values within a database.
- BRLE compression works well for consecutive zero values or repeating values within a database.
- CBitmap compression is the default compression method.
- DThe Accounts dimension is tagged the compression dimension by default.
- EDo not set compression for a dimension that has many members.
How the community answered
(42 responses)- A14% (6)
- B74% (31)
- D7% (3)
- E5% (2)
Explanation
B: RLE (Run Length Encoding) is a good compression type when your data has many zeros (block density low) or often repeats. RLE uses multiple compression compressions (one per block). RLE will use RLE, bitmap or IVP. C: By default, Bitmap compression is enabled. To switch to a different compression type, use alter database set compression.
Topics
Community Discussion
No community discussion yet for this question.