Oracle Cloud Infrastructure 2019 Architect Associate — Question 14

Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups:
High, Medium, and Low.
Which statement about these consumer groups is correct?

Answer options

• A. Medium provides intermediate resource and concurrency, and queries run in a serial.
• B. Low provides highest concurrency, lowest resources, and DoP =1.
• C. High provides highest resources, lowest concurrency, and DoP is 1.
• D. High provides highest concurrency and lowest resources, and DoP is 1.

Correct answer: B

Explanation

Option B is correct because the Low consumer group is designed for high concurrency with the least amount of resources, and it operates with a Degree of Parallelism (DoP) of 1. The other options misrepresent the characteristics of the consumer groups; for instance, Medium does not run queries in a serial fashion, and High has a different resource and concurrency profile than stated in options C and D.