Download as:
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Language:EN
Pages: 5
Words: 1173

Oracle autonomous database cloud

  1. Patching the database.

  2. 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:

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

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

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

  2. In-flight transactions and queries are stopped.

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

  2. 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:

  1. CREATE ANALYTIC HIERARCHY

  2. 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

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

Answer: D

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

  2. 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/

Copyright © 2009-2023 UrgentHomework.com, All right reserved.