Oracle
1Z0-1072 · Question #124
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 through nothing else is running in the…
The correct answer is C. The new batch job is connected to LOW consumer group. See the full explanation below for the reasoning.
Question
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 through 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?
Options
- AThe batch job depends on only one table and parallelism cannot be enabled on single-table
- BThe parallelism of batch job depends on the number of ADW databases involved in the query.
- CThe new batch job is connected to LOW consumer group.
- DThe new batch job runs on database tables that are not enable for parallel execution.
- EParallelism on the database is controlled by the application, not the database.
How the community answered
(19 responses)- A5% (1)
- B21% (4)
- C68% (13)
- D5% (1)
Community Discussion
No community discussion yet for this question.