nerdexam
Oracle

1Z0-931-20 · Question #91

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

The correct answer is B. Autonomous Data Warehouse workloads are optimized for mixed workloads. Explanation/Reference:

Autonomous Database Concepts

Question

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

Options

  • AAutonomous Transaction Processing memory usage optimizes workloads for parallel joins and
  • BAutonomous Data Warehouse workloads are optimized for mixed workloads.
  • CAutonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data
  • DData that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where

How the community answered

(38 responses)
  • A
    3% (1)
  • B
    84% (32)
  • C
    3% (1)
  • D
    11% (4)

Explanation

Explanation/Reference:

Topics

#ATP vs ADW#workload optimization#columnar format#mixed workloads

Community Discussion

No community discussion yet for this question.

Full 1Z0-931-20 Practice