Which of the following is a feature of the High consumer group in ADW?

The selection of "High resources, low concurrency, parallelism" as the correct answer reflects an understanding of the characteristics of the High consumer group within Oracle Autonomous Data Warehouse (ADW) environments. The High consumer group is designed for workloads that require more computing resources to efficiently process queries.

In this context, the term "high resources" indicates that the queries running in this consumer group are allocated more CPU and memory resources, allowing them to handle more complex operations and larger datasets effectively. The mention of "low concurrency" signifies that while these queries are resource-intensive, there are fewer of them running simultaneously compared to other consumer groups, such as the High concurrency group. This setup helps ensure that resource-heavy queries have the necessary capabilities to execute without being significantly impacted by resource contention from other queries.

The aspect of “parallelism” allows these queries to leverage multiple processing threads to improve performance, making it suitable for large aggregations, joins, or complex calculations that can benefit from parallel execution.

This combination of high resource allocation and the ability to utilize parallelism makes the High consumer group particularly suited for demanding workloads in data warehousing scenarios, facilitating efficient data processing and retrieval.