What is the difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?

The primary architectural difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) lies in their data storage optimization. ADW is designed for analytics and business intelligence workloads, which benefit from scanning large volumes of data. To optimize for this, ADW stores data in a hybrid columnar format by default, which significantly improves query performance and data compression. In contrast, ATP is optimized for transactional (OLTP) workloads with high volumes of concurrent, short-running transactions, and it uses the traditional row format by default, which is more efficient for single-row lookups, inserts, and updates.

A. Only ATP manages optimizer statistics. This is incorrect. Automatic statistics collection and management is a core "autonomous" feature of both ADW and ATP to ensure optimal query performance.
B. Only ADW supports autoscaling. This is incorrect. Autoscaling for both CPU and storage is a fundamental feature of the Oracle Autonomous Database platform, available for both ADW and ATP workloads.
D. Only ATP supports automatic backups. This is incorrect. Fully-managed, automatic backups are a key feature of the entire Autonomous Database service, including both ADW and ATP, to ensure data protection.

1. Oracle Cloud Infrastructure Documentation - Overview of Autonomous Data Warehouse:

"Data is stored in a highly compressed

optimized columnar format."

Source: Oracle Cloud Infrastructure Documentation

"Overview of Autonomous Data Warehouse

" Section: "Key Features of Autonomous Data Warehouse".

2. Oracle Cloud Infrastructure Documentation - Overview of Autonomous Transaction Processing:

This document describes ATP's optimization for transactional workloads

which implicitly relies on a row-based format for efficiency

contrasting with ADW's explicitly stated columnar format. The documentation focuses on features like high concurrency and low latency for transactional operations.

Source: Oracle Cloud Infrastructure Documentation

"Overview of Autonomous Transaction Processing

" Section: "Key Features of Autonomous Transaction Processing".

3. Oracle Cloud Infrastructure Documentation - About Autonomous Database:

This document outlines features common to both ADW and ATP

invalidating the incorrect options. It explicitly lists "Automatic Backups" and "Automatic Scaling" as platform-wide features. It also describes the self-managing capabilities

which include automatic statistics gathering.

Source: Oracle Cloud Infrastructure Documentation

"About Autonomous Database

" Section: "Autonomous Database Is a Self-Managing Database".