Oracle autonomous database cloud
Patching the database.
Automatically optimize the workload.
UPDATE_OBJECT_INFO
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:
In the Column Definition Phase, the system cross-references with the file-contents andshows the conflicts with the definition.
In the TEST phase, a temporary table will be populated with the records before insertingthem in the destination table.
CPU billing is halted based on full-hour cycles of usage.
In-flight transactions and queries are stopped.
Only the migration to ADB is possible from an on-premise installation of Golden Gate.
Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service existsfor this.
ADBDEV
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:
CREATE ANALYTIC HIERARCHY
CREATE ANALYTIC VIEWE. CREATE ATTRIBUTE DIMENSION
The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to theAutonomous Data Warehouse.
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
Create a database link from one Autonomous Database to another Autonomous Databaseinstance.
Answer: D
Autonomous Data Warehouse workloads are optimized for mixed workloads.
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?
On the Autonomous Database Console.
Explanation:
Reference: https://www.dbarj.com.br/en/2018/09/creating-a-read-only-user-in-oracle-cloud-infrastructure/