Let’s evaluate each statement about Autonomous Data Warehouse (ADW) on Shared Exadata Infrastructure:
A. Oracle Database Result Cache is enabled by default for all SQL statements:True. ADW enables the Result Cache by default to improve query performance by storing frequently accessed results in memory.
B. You have direct access to the database node:False. ADW is a fully managed service; users do not have direct access to underlying nodes, which Oracle manages for patching, scaling, and security.
C. Parallelism is not enabled by default:False. Parallelism is enabled by default in ADWto optimize large analytical queries across multiple CPUs.
D. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default:True. Hybrid Columnar Compression (HCC) is applied automatically to reduce storage and enhance query performance.
Thus, A and D are correct, reflecting ADW’s default performance optimizations.
[Reference:Oracle Autonomous Data Warehouse Documentation -Overview, ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit