Oracle Cloud Infrastructure 2023 Architect Associate — Question 41

Users connect to Autonomous Data Warehouse by using one of the following consumer groups: High, Medium, and Low.

Which statement is true about these consumer groups?

Answer options

• A. Low provides highest concurrency and lowest resources, and DoP is 1.
• B. Medium provides intermediate resource and concurrency, and queries run serially.
• C. High provides highest concurrency and lowest resources, and DoP is 1.
• D. High provides highest resources and lowest concurrency, and Degree of Parallelism (DoP) is 1.

Correct answer: A

Explanation

Option A is correct because the Low consumer group is designed for high concurrency while utilizing minimal resources and a Degree of Parallelism (DoP) of 1. Options B, C, and D misrepresent the characteristics of the Medium and High groups, particularly regarding resource allocation and concurrency levels.