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

Question

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

• A
  6% (2)
• B
  14% (5)
• C
  3% (1)
• D
  77% (27)

Explanation

Explanation/Reference: - Both ADW and ATP share the Autonomous Database platform of Oracle Database on Exadata Cloud The difference is how the services have been optimized within the database. When you start loading data into the autonomous database, we store the data in the appropriate format for the workload. * If it is ADW, then we store data in columnar format because that's the best format for analytics ꞏ If it is ATP, then we store the data in row format because that's the best format for fast single row - Oracle Autonomous Database is offered in two workload-optimized flavors * Autonomous Data Warehouse (ADW), which has been optimized for analytic workloads ꞏ Autonomous Transaction Processing (ATP). ATP is optimized for transaction processing or mixed workload https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04- 4147-9606-0413D9CC1589

No community discussion yet for this question.