Which predefined role that exists in Autonomous Database includes common privileges that are used by a Data Warehouse developer? (Choose the best answer.)

1. A. ADBDEV
2. B. DWROLE
3. C. ADMIN
4. D. ADWC

Correct Answer: B

Which predefined service connection should you use when running lots of high concurrent queries in an Autonomous Database?

1. A. DBNAME_LOW
2. B. DBNAME_MEDIUM
3. C. DBNAME_HIGH
4. D. DBNAME_CONCURRENT

Correct Answer: A

While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?

1. A. Quarterly Bundle Patch (QBP)
2. B. Prior Release Update Revision (PRUR)
3. C. Prior Release Update (PRU)
4. D. Release Update (RU)

Correct Answer: D

What predefined user is created when provisioning an Autonomous Database (ADB) instance to which you connect to create other users and grant roles?

1. A. SYS
2. B. ADMIN
3. C. DWDEV
4. D. SCOTT

Correct Answer: B

What is the difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?

1. A. Only ATP manages optimizer statistics.
2. B. Only ADW supports autoscaling
3. C. Only ADW uses columnar compression by default.
4. D. Only ATP supports automatic backups.

Correct Answer: C