Oracle Cloud Infrastructure 2019 Developer Associate — Question 157

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.)

Answer options

• A. The MEDIUM and LOW consumer group can run up to 16 concurrent SQL statements if HIGH consumer group has 0 SQL statements
• B. The HIGH consumer group can run up to 16 concurrent SQL statements as long as MEDIUM and LOW consumer groups have 0 SQL statements
• C. The MEDIUM consumer group can run 20 concurrent SQL statements when HIGH consumer group has 0 SQL statements
• D. The HIGH consumer group can run up to 16 concurrent SQL statements in addition to 32 concurrent SQL statements in MEDIUM and LOW consumer group each
• E. The HIGH consumer group can run 3 concurrent SQL statements when MEDIUM consumer group has 0 SQL statements

Correct answer: C, E

Explanation

The correct answers are C and E. Statement C is accurate because the MEDIUM consumer group can indeed run 20 concurrent SQL statements if the HIGH consumer group is not utilizing any. Statement E is also correct since the HIGH consumer group is limited to 3 concurrent SQL statements when the MEDIUM consumer group does not have any active SQL statements. The other options either overstate the limits or misrepresent the configuration of concurrent SQL statements.