nerdexam
Oracle

1Z0-932(155Q) · Question #97

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…

The correct answer is D. Configure ATP resource management rules to manage runtime and IO consumption for the. https://oracle-base.com/articles/misc/articles-misc

Database

Question

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?

Options

  • ACopy OLTP data into new tables in a new table space and run batch processes against these new
  • BATP is designed for OLTP workload only; you should not run batch processes on ATP
  • CDisable automated backup during the batch process operations
  • DConfigure ATP resource management rules to manage runtime and IO consumption for the

How the community answered

(22 responses)
  • A
    5% (1)
  • B
    5% (1)
  • C
    9% (2)
  • D
    82% (18)

Explanation

https://oracle-base.com/articles/misc/articles-misc

Topics

#ATP resource management#consumer groups#OLTP workload#batch processing

Community Discussion

No community discussion yet for this question.

Full 1Z0-932(155Q) Practice