Oracle
1Z0-931-20 · Question #98
You have provisioned an Autonomous Data Warehouse (ADW) database with 16 enabled OCPUs and need to configure the consumer group for your application. Which two are true when deciding the number of…
The correct answer is C. The MEDIUM consumer group can run 20 concurrent SQL statements when HIGH consumer group E. The HIGH consumer group can run 3 concurrent SQL statements when MEDIUM consumer group has. Explanation/Reference:
Managing and Monitoring Autonomous Database
Question
You have provisioned an Autonomous Data Warehouse (ADW) database with 16 enabled OCPUs and need to configure the consumer group for your application. Which two are true when deciding the number of sessions for each application? (Choose two.)
Options
- AThe MEDIUM and LOW consumer group can run up to 16 concurrent SQL statements if HIGH
- BThe HIGH consumer group can run up to 16 concurrent SQL statements as long as MEDIUM and LOW
- CThe MEDIUM consumer group can run 20 concurrent SQL statements when HIGH consumer group
- DThe HIGH consumer group can run up to 16 concurrent SQL statements in addition to 32 concurrent
- EThe HIGH consumer group can run 3 concurrent SQL statements when MEDIUM consumer group has
How the community answered
(64 responses)- A16% (10)
- B5% (3)
- C70% (45)
- D9% (6)
Explanation
Explanation/Reference:
Topics
#consumer groups#concurrent sessions#OCPU scaling#HIGH MEDIUM LOW concurrency
Community Discussion
No community discussion yet for this question.