Home » Oracle » 1z0-533 » What are the two possible effects on the database when the data storage property of a parent member in the sparse Entity dimension is set to Dynamic Calc?
What are the two possible effects on the database when the data storage property of a parent member in the sparse Entity dimension is set to Dynamic Calc?
A. Essbase data block size decrease.
B. The member is not available for process management.
C. Retrieval performance could be slower when referencing the parent entity member.
D. Data cannot be input to the parent in target versions.
Correct Answer: AC
Explanation/Reference:
Explanation: A:Usage of dynamic calc in sparse dimensionincludes benefits such asshorter aggregations smaller database size.
C:Consider the number of members underneath a sparse parent. It’s generally good practice to have few (up to 20) members under dynamic sparse parents if your block size is not massively huge. This number might increase if your block size is tiny.
Download Printable PDF. VALID exam to help you PASS.
|
|
C&D,
A: Incorrect, block size unchange, no. of block decrease.