Exam 1z0-932 topic 1 question 89 discussion

Actual exam question from Oracle's 1z0-932

Question #: 89
Topic #: 1

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?

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

Show Suggested Answer

Suggested Answer: D 🗳️
Reference:
https://oracle-base.com/articles/misc/articles-misc

by fateh19000 at June 27, 2020, 6:06 p.m.