Oracle Cloud Infrastructure 2020 Architect Associate — Question 48

You are managing a tier-1 OLTP application on an Oracle 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. Configure ATP resource management rules to change CPU/IO shares for the consumer group of batch processes.
• B. Copy OLTP data into new tables in a new table space and run batch processes against these new tables.
• C. Disable automated backup during the batch process operations.
• D. ATP is designed for OLTP workload only, you cannot run batch processes on ATP.

Correct answer: A

Explanation

The correct answer is A because configuring resource management rules allows you to allocate CPU and IO resources effectively, ensuring that batch processes do not negatively affect OLTP transactions. Option B does not address resource contention directly, and while it might isolate data, it still could lead to performance issues. Option C is not a viable solution as disabling backups does not mitigate CPU contention. Option D is incorrect because ATP can handle batch processes if managed correctly.