nerdexam
Oracle

1Z0-931-20 · Question #119

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…

The correct answer is B. Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the. Explanation/Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/experienced-database- users.html#GUID-58EE6599-6DB4-4F8E-816D-0422377857E5

Autonomous Database Concepts

Question

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?

Options

  • AIn Autonomous Data Warehouse direct access to the database node and the local file system is
  • BDegree of parallelism for SQL statements is set based on the number of OCPUs in the system and the
  • CAdding, removing, or modifying tablespaces is allowed.
  • DCompression is not enabled by default and you must specify the compression method for your tables

How the community answered

(27 responses)
  • A
    7% (2)
  • B
    78% (21)
  • C
    11% (3)
  • D
    4% (1)

Explanation

Explanation/Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/experienced-database- users.html#GUID-58EE6599-6DB4-4F8E-816D-0422377857E5

Topics

#ADW default configuration#degree of parallelism#OCPU#autonomous optimization

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-931-20 Practice