Oracle Cloud Infrastructure 2020 Architect Associate — Question 47

You hired a new employee to run reports from the Oracle Autonomous Data Warehouse (ADW) and are not confident in their SQL writing ability.
Into which consumer group will you assign this individual to minimize the impact of their code?

Answer options

• A. Lowest
• B. Highest
• C. Medium
• D. Low
• E. High

Correct answer: D

Explanation

Assigning the new employee to the Low consumer group will limit the resources available to their queries, thus minimizing any potential negative impact on the overall performance of the Oracle Autonomous Data Warehouse. The other options, especially Highest and High, would provide more resources, which could lead to performance issues if the employee's SQL skills are not strong.