Oracle Cloud Infrastructure 2020 Architect Associate — Question 3

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure? (Choose two.)

Answer options

• A. You have direct access to the database node.
• B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
• C. Oracle Database Result Cache is enabled by default for all SQL statements.
• D. Parallelism is not enabled by default.

Correct answer: B, C

Explanation

Option B is correct because Autonomous Data Warehouse does indeed use Hybrid Columnar Compression by default for all tables, ensuring efficient storage. Option C is also correct as the Oracle Database Result Cache is enabled by default, improving the performance of SQL statements. Options A and D are incorrect; users do not have direct access to the database node, and parallelism is actually enabled by default in this environment.