Oracle Cloud Infrastructure 2019 Developer Associate — Question 151

You are managing a tier-1 OLTP application on an Autonomous Transaction Processing (ATP) database. Your business needs to run hourly batch processes on this ATP database that may consume more CPUs than what is available on the server.
How can you limit these batch processes to not interfere with the OLTP transactions?

Answer options

• A. Copy OLTP data into new tables in a new table space and run batch processes against these new tables
• B. ATP is designed for OLTP workload only; you should not run batch processes on ATP
• C. Disable automated backup during the batch process operations
• D. Configure ATP resource management rules to manage runtime and IO consumption for the consumer group of batch processes

Correct answer: D

Explanation

The correct answer is D because configuring resource management rules allows for the prioritization of OLTP transactions over batch processes, ensuring that the batch jobs do not consume excessive resources. Option A is incorrect because copying data into new tables does not address resource contention. Option B is misleading as ATP can handle batch processes if managed correctly. Option C is not a viable solution since disabling backups does not mitigate CPU competition.