Oracle Cloud Infrastructure 2020 Architect Associate — Question 32

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
(Choose the best answer.)

Answer options

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

Correct answer: A

Explanation

The correct answer is A because Autonomous Transaction Processing utilizes row format for bulk-loaded data, while Autonomous Data Warehouse employs a columnar format optimized for analytical queries. Options B, C, and D are incorrect as they misrepresent the specific workload optimizations for each service; for instance, Autonomous Data Warehouse is not specifically optimized for mixed workloads, and Autonomous Transaction Processing is not primarily focused on data warehouse types.