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.)
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
For example, for an Autonomous Data Warehouse with 16 OCPUs, the HIGH consumer group will be able to run 3 concurrent SQL statements when the MEDIUM consumer group is not running any statements. The MEDIUM consumer group will be able to run 20 concurrent SQL statements when the HIGH consumer group is not running any statements. The LOW consumer group will be able to run 4800 concurrent SQL statements. The HIGH consumer group can run at least 1 SQL statement when the MEDIUM consumer group is also running statements. When these concurrency levels are reached for a consumer group new SQL statements in that consumer group will be queued until one or more running statements finish.
C&E are correct
This section is not available anymore. Please use the main Exam Page.1z0-932 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
jcmoranp
Highly Voted 5 years agoChandraTalasila
Highly Voted 4 years, 12 months agoAnirban_ITArchitect
Most Recent 4 years, 9 months agoScunningham99
4 years, 9 months agobharat1971
4 years, 9 months agoluisrogo
3 years, 8 months agoadesal
4 years, 12 months ago