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

Autonomous Data Warehouse (ADW) uses consumer groups (High, Medium, Low) to manage

resource allocation:

Correct Answer (A): “Low provides highest concurrency and lowest resources, and DoP is 1” is true.

The Low group is designed for many lightweight, short-running queries, offering maximum

concurrent sessions but minimal CPU/memory per session, with a Degree of Parallelism (DoP) of 1

(serial execution).

Incorrect Options:

B: High prioritizes resources, not concurrency; it has fewer sessions with more power.

C: Medium offers balanced resources and concurrency; queries can run in parallel (DoP > 1), not just

serially.

D: High has high resources but low concurrency; DoP is typically higher than 1 for resource-intensive

tasks.

This setup optimizes ADW for varied workloads.

Reference: Predefined Service Names