Oracle Autonomous Database Cloud 2020 Specialist — Question 12

Which two client requirements align with using an ASO plan type alongside the module-based plan types? (Choose two.)

Answer options

• A. The client would like to plan revenue by Product and Services dimensions.
• B. The client would like to report the results of the allocation process by Entity.
• C. The client would like to store 10 years of actuals history for reporting purposes but only requires prior year history for planning purposes.
• D. Due to sparse dimensionality, aggregation times are slow in the application.
• E. The client has 10 dimensions in the application and needs to report at each intersection.

Correct answer: D, E

Explanation

Option D is correct because slow aggregation times due to sparse dimensionality indicate a need for an ASO plan type, which is optimized for such scenarios. Option E is also correct as having many dimensions and needing detailed reporting aligns with the capabilities of ASO. The other options do not specifically address the benefits of ASO in the context of dimensionality and performance.