Question 8
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
Autonomous Data Warehouse workloads are optimized for mixed workloads.
Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
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: B
Explanation:
Reference: https://www.oracle.com/a/ocom/docs/database/oracle-autonomous-database-strategy-wp.pdf
Reference: https://www.oracle.com/a/ocom/docs/database/oracle-autonomous-database-strategy-wp.pdf