Oracle Cloud Infrastructure 2019 Architect Associate — Question 41

Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.
Which statement is true regarding the default configuration of the Autonomous Data Warehouse?

Answer options

• A. In Autonomous Data Warehouse direct access to the database node and the local file system is allowed.
• B. Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to.
• C. Adding, removing, or modifying tablespaces is allowed.
• D. Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.

Correct answer: B

Explanation

The correct answer is B because the degree of parallelism in Autonomous Data Warehouse is indeed automatically based on the OCPUs and the database service. Option A is incorrect because direct access to the database node and file system is not allowed for security reasons. Option C is false as modifications to tablespaces are restricted. Option D is also incorrect since compression is enabled by default in Autonomous Data Warehouse.