Oracle Cloud Infrastructure 2019 Architect Associate — Question 9

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

Answer options

• A. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
• B. Autonomous Data Warehouse workloads are optimized for mixed workloads.
• C. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
• D. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

Correct answer: D

Explanation

The correct answer is D because in Autonomous Transaction Processing, bulk-loaded data is stored in a row format, which is optimal for transaction processing. In contrast, Autonomous Data Warehouse uses a columnar format that enhances analytical query performance. The other options incorrectly describe the specific workload optimizations associated with each service.