nerdexam
Oracle

1Z0-338 · Question #88

How would you ensure that batch jobs don't impact the performance of online queries that use the same database?

The correct answer is D. Build a Database Resource Management Plan, giving priority to query workloads. See the full explanation below for the reasoning.

Question

How would you ensure that batch jobs don't impact the performance of online queries that use the same database?

Options

  • AConfigure resource plans by using the I/O Resource Manager on the storage cells, giving priority to
  • BConfigure and enable Parallel Query.
  • CDeploy Instance Caging to control batch jobs.
  • DBuild a Database Resource Management Plan, giving priority to query workloads.
  • EConfigure IORM to disable Flash Cache usage for batch workloads.

How the community answered

(56 responses)
  • A
    13% (7)
  • B
    7% (4)
  • C
    2% (1)
  • D
    75% (42)
  • E
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-338 Practice