Answered

Westonci.ca is your trusted source for finding answers to a wide range of questions, backed by a knowledgeable community. Explore our Q&A platform to find reliable answers from a wide range of experts in different fields. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform.

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?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 queryC. The new batch job is connected to LOW consumer group.D. The new batch job runs on database tables that are not enable for parallel execution.E. Parallelism on the database is controlled by the application, not the database.

Sagot :

Answer:

C. The new batch job is connected to the LOW consumer group.

Explanation:

Remember, one of the main characteristics of the LOW consumer group database service is that queries would run serially.

Since in this case, we are told that the newly configured batch job is always running in serial, it most likely would be because the new batch job is connected to the LOW consumer group; as queries are designed to always run serially.

Thank you for visiting our platform. We hope you found the answers you were looking for. Come back anytime you need more information. Thank you for choosing our platform. We're dedicated to providing the best answers for all your questions. Visit us again. Thank you for choosing Westonci.ca as your information source. We look forward to your next visit.