Oracle Application Testing Suite 12 Essentials — Question 6

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?

Answer options

• 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: A, C

Explanation

Option A is correct because setting a parent member to Dynamic Calc can lead to a smaller data block size since the data is calculated on-the-fly rather than stored. Option C is also correct as the dynamic calculation can slow down retrieval performance due to the additional computation required. The other options, B and D, are incorrect as they do not accurately reflect the consequences of the Dynamic Calc setting.