1Z0-531 · Question #69
Which two statements are true (assuming data is loaded to a BSO database and to the members noted below)?
The correct answer is A. If you delete a sparse shared member, the outline file shrinks. C. If you delete a sparse stored member, the index file shrinks. C: If a member of a sparse dimension is moved, deleted, or added, Essbase restructures the index and creates new index files. Restructuring the index is relatively fast; the time required depends on the index size. Sparse restructures are typically fast, but depend on the size…
Question
Which two statements are true (assuming data is loaded to a BSO database and to the members noted below)?
Options
- AIf you delete a sparse shared member, the outline file shrinks.
- BIf you delete a sparse shared member, the page file shrinks.
- CIf you delete a sparse stored member, the index file shrinks.
- DIf you delete a sparse stored member, the block density shrinks.
- EIf you delete a dense shared member, the block size shrinks.
- FIf you delete a dense stored member, the number of blocks shrinks
How the community answered
(25 responses)- A76% (19)
- B8% (2)
- D4% (1)
- F12% (3)
Explanation
C: If a member of a sparse dimension is moved, deleted, or added, Essbase restructures the index and creates new index files. Restructuring the index is relatively fast; the time required depends on the index size. Sparse restructures are typically fast, but depend on the size of the index file(s). Sparse restructures are faster than dense restructures.
Topics
Community Discussion
No community discussion yet for this question.