Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low. Which statement about these consumer groups is correct?
A.
Medium provides intermediate resource and concurrency, and queries run in a serial.
B.
Low provides highest concurrency, lowest resources, and DoP =1.
C.
High provides highest resources, lowest concurrency, and DoP is 1.
D.
High provides highest concurrency and lowest resources, and DoP is 1.
B
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
tp: A typical application connection service for transaction processing operations. Queries run serially.
high: A high priority application connection service for reporting and batch operations with low concurrency requirements. All operations run in parallel (if you have multiple OCPU assigned to your instance) and are subject to queuing.
medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
low: A lowest priority application connection service for high concurrency reporting or batch processing operations. Queries run serially.
B is correct because of the second part which says DoP = 1, because low service queries can use inly 1 CPU so there is no parallel query processing. C is partially true but is wrong because queries using High can multiple CPU so parallel processing can be achieved there
LA RESPUESTA CORRECTA ES C, SE PUEDE CONFIRMAR EN EL SEGUIENTE LINK https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/adwud/predefined-database-service-names.html#GUID-D94714F3-C6FC-45E2-8E80-07A08DB47FFE
Correct C:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
The basic characteristics of these consumer groups are:
HIGH: Highest resources, lowest concurrency. Queries run in parallel.
MEDIUM: Less resources, higher concurrency. Queries run in parallel.
LOW: Least resources, highest concurrency. Queries run serially.
C is correct as per the link
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
Correct Ans: C
Low: DoP is NOT 1
Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
This section is not available anymore. Please use the main Exam Page.1z0-931 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.
ecc_ar
Highly Voted 4 years, 10 months agoKiwino
Highly Voted 4 years, 10 months agoyogen
Most Recent 4 years, 6 months agosebas880316
4 years, 8 months agomigue3230
4 years, 8 months agomigue3230
4 years, 8 months agorider
4 years, 9 months agoNorman_13579
4 years, 9 months agolixo
4 years, 9 months agoDeep121
4 years, 9 months agoprince1985
4 years, 9 months agojones4u
4 years, 9 months agos_muyo
4 years, 7 months agoScunningham99
4 years, 9 months agovictor007
4 years, 10 months agoakt007tx
4 years, 10 months agotell2ami
4 years, 10 months agoadesmaster
4 years, 7 months ago