Oracle Cloud Infrastructure 2022 Architect Associate — Question 47

Your customer would run month-end jobs on their on-premises databases that would take around 14 hours to complete and sometimes even fail due to overloaded database systems. After a detailed evaluation, they migrated their database to Oracle Autonomous Data Warehouse. They realized they could also move their analytics platform to Oracle Analytics Cloud (OAC) and have their best of breed technology platforms meet their critical business requirements.
After migrating their analytics platform, they want to use one consumer group for running month-end jobs and another consumer group that can be used by the analytics team for performing data analytics tasks everyday.
How can your customer implement this requirement?

Answer options

• A. Use consumer group high for data analytics and consumer group low for month-end jobs.
• B. Use consumer group high for both month-end jobs and data analytics.
• C. Use consumer group high for month-end jobs and consumer group medium for data analytics.
• D. Use consumer group medium for month-end jobs and consumer group low for data analytics.

Correct answer: D

Explanation

The correct answer is D, as using consumer group medium for month-end jobs allows for sufficient resources without overwhelming the system, while consumer group low for data analytics ensures that everyday tasks do not interfere with critical processing times. Option A misallocates resources by giving higher priority to analytics, which could disrupt month-end jobs. Options B and C do not properly differentiate the resource needs for the month-end jobs, risking performance issues.