Oracle Cloud Infrastructure 2019 Developer Associate — Question 155

You are running your warehouse using Autonomous Data Warehouse (ADW) service and you noticed that a newly configured batch job is always running in serial even though nothing else is running in the database. All your jobs are configured to run with parallelism enabled.
What could be the reason for this batch job to run in serial?

Answer options

• A. The batch job depends on only one table and parallelism cannot be enabled on single-table queries.
• B. The parallelism of batch job depends on the number of ADW databases involved in the query.
• C. The new batch job is connected to LOW consumer group.
• D. The new batch job runs on database tables that are not enabled for parallel execution.
• E. Parallelism on the database is controlled by the application, not the database.

Correct answer: C

Explanation

The correct answer is C because a job connected to the LOW consumer group has limited resources and cannot utilize parallel processing effectively. Options A, B, D, and E are incorrect because they do not accurately describe how parallelism works in the context of ADW and the conditions affecting the execution of batch jobs.