nerdexam
Oracle

1Z0-931 · Question #59

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. 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
  • CAdding, removing, or modifying tablespaces is allowed.
  • DCompression is not enabled by default and you must specify the compression method for your

How the community answered

(62 responses)
  • A
    8% (5)
  • B
    69% (43)
  • C
    5% (3)
  • D
    18% (11)

Explanation

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

Topics

#degree of parallelism#OCPUs#ADW auto-configuration#managed database

Community Discussion

No community discussion yet for this question.

Full 1Z0-931 Practice