Oracle autonomous database cloud

3. Patching the database.

4. Automatically optimize the workload.

1. UPDATE_OBJECT_INFO

2. MODIFY_SNAPSHOT_SETTINGS

Reference: https://www.oracle.com/database/what-is-autonomous-database.html

3. If you need to connect to Autonomous Data Warehouse (ADW) using Java DatabaseConnectivity (JDBC) via an HTTP proxy, where do you set the proxy details?

Answer: AC

4. How can an Autonomous Database resource be provisioned without logging into the OracleCloud Infrastructure console?

Answer: B

5. What are three methods to load data into the Autonomous Database? (Choose three.)

Answer: ADE

Explanation:

3. In the Column Definition Phase, the system cross-references with the file-contents andshows the conflicts with the definition.

4. In the TEST phase, a temporary table will be populated with the records before insertingthem in the destination table.

3. CPU billing is halted based on full-hour cycles of usage.

4. In-flight transactions and queries are stopped.

2. Only the migration to ADB is possible from an on-premise installation of Golden Gate.

3. Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service existsfor this.

1. ADBDEV

2. ADMIN

Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manageusers-privileges.html#GUID-50450FAD-9769-4CF7-B0D1-EC14B465B873

10. What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)

Answer: AC

Explanation:

3. CREATE ANALYTIC HIERARCHY

4. CREATE ANALYTIC VIEWE. CREATE ATTRIBUTE DIMENSION

1. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to theAutonomous Data Warehouse.

2. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storagecredentials in the Autonomous Data Warehouse database.

Explanation:

Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbmscloud.html#GUID-930632E1-B7BF-4ECA-8F78-5E5A205C0865

4. Create a database link from one Autonomous Database to another Autonomous Databaseinstance.

Answer: D

2. Autonomous Data Warehouse workloads are optimized for mixed workloads.

3. Autonomous Transaction Processing workloads are optimized for data warehouse, datamart, and data lake.

15. Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console inorder to execute API calls?

1. On the Autonomous Database Console.

Explanation:

Reference: https://www.dbarj.com.br/en/2018/09/creating-a-read-only-user-in-oracle-cloud-infrastructure/