Oracle Autonomous Database Cloud 2020 Specialist — Question 44

What would be the recommended module-based cube architecture for a company wanting to enable Financials and Capital, as well as create a Detailed Sales
Forecasting cube with complex allocations and calculations, corresponding sales reporting cube, and consolidated reporting cube? (Choose the best answer.)

Answer options

• A. 3 BSO cubes (1 required for the modules +2 custom BSO cubes), 2 ASO cubes
• B. 2 BSO cubes (1 required for the modules +1 custom BSO cubes), 2 ASO cubes
• C. 3 custom BSO cubes, 2 ASO cubes
• D. 3 BSO cubes (2 required for the modules +1 custom BSO cube), 2 ASO cubes

Correct answer: D

Explanation

The correct answer is D because it specifies the need for 3 BSO cubes, which include 2 for the essential modules and 1 custom cube, alongside 2 ASO cubes for complex calculations and reporting. Option A is incorrect as it has an unnecessary additional custom BSO cube, while option B has insufficient BSO cubes for the required functionalities. Option C fails to align with the required number of BSO cubes needed for the modules.