nerdexam
Oracle

1Z0-932(155Q) · Question #104

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. https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manageservice. html#GUID-4861BA7F-F9FA-4909-8DC0-4F46AFF80706

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?

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 group
  • 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

(27 responses)
  • A
    19% (5)
  • B
    4% (1)
  • C
    70% (19)
  • D
    7% (2)

Explanation

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manageservice. html#GUID-4861BA7F-F9FA-4909-8DC0-4F46AFF80706

Topics

#ADW consumer groups#concurrent SQL#OCPU#resource management

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-932(155Q) Practice