Oracle Cloud Infrastructure 2022 Architect Professional — Question 13

Which are two characteristics of Autonomous Transaction Processing (ATP)? (Choose two.)

Answer options

• A. Optimized for response time
• B. Creates autonomous data summaries
• C. Statistics are gathered as part of bulk load operations
• D. Stores data in columnar format
• E. Focuses on creation of indexes

Correct answer: A, D

Explanation

The correct answers are A and D because Autonomous Transaction Processing is designed to optimize response time and effectively manages data in a columnar format for better performance. Options B, C, and E do not accurately reflect the core characteristics of ATP, as it does not primarily focus on data summaries, bulk load statistics gathering, or index creation.