nerdexam
Oracle

1Z0-1072-20 · Question #90

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 E. The HIGH consumer group can run 3 concurrent SQL statements when MEDIUM consumer group. https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect- predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE

Implement OCI 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
  • CThe MEDIUM consumer group can run 20 concurrent SQL statements when HIGH consumer
  • DThe HIGH consumer group can run up to 16 concurrent SQL statements in addition to 32
  • EThe HIGH consumer group can run 3 concurrent SQL statements when MEDIUM consumer group

How the community answered

(20 responses)
  • A
    5% (1)
  • B
    5% (1)
  • C
    75% (15)
  • D
    15% (3)

Explanation

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect- predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE

Topics

#ADW consumer groups#concurrent SQL sessions#OCPU configuration#HIGH/MEDIUM/LOW groups

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-1072-20 Practice