Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing? (Choose two.)
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing? (Choose two.)
Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) have different optimization needs based on their primary uses. ADW is optimized for analytical queries and therefore uses more memory for parallel processing and complex queries, which impacts Memory Usage. Additionally, ADW organizes data in a columnar format to optimize read efficiency and query performance, while ATP organizes data in a row format to enhance transaction performance. These differences in memory usage and data organization are key optimizations that distinguish ADW from ATP.
A) ADW will use more PGA memory for analytical query, for ATP more SGA is allocated for transactional operations. D) ADW data storage is columnar format , ATP data storage is is row format
A&C is correct