1Z0-931 Oracle Autonomous Database Cloud

1. Which task is NOT automatically performed by the Oracle Autonomous Database?

  1. Backing up the database.
  2. Mask your sensitive data.
  3. Patching the database.
  4. Automatically optimize the workload.

Answer: B


Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitorperformance-intro.html#GUID-4A1E8FCA-FAF1-43F5-93E0-559C0145D6C3

2. The default eight-day retention period for Autonomous Database performance data can bemodified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?


Answer: B


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?

  1. tnsnames.ora
  2. keystore.jks
  3. sqlnet.ora
  4. cwallet.ssoE. ojdbc.properties

Answer: AC

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

  1. Using Database Configuration Assistant (DBCA) on the database server.
  2. It cannot be done.
  3. Connecting to the Cloud Infrastructure Command console via SSH wallet.
  4. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Answer: B

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

  1. Oracle GoldenGate
  2. Transportable Tablespace
  3. RMAN Restore
  4. Oracle Data PumpE. SQL*Loader

Answer: ADE


Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/loaddata.html#GUID-1351807C-E3F7-4C6D-AF83-2AEEADE2F83E

6. In which way can a SQL Developer help you test your data loading scenario to AutonomousDatabase (ADB)?

  1. In the TEST phase of the wizard, a subset of accepted records is displayed based on yourdefinition.
  2. In the TEST phase of the wizard a list is generated containing the records that would berejected during import.
  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.

Answer: C

7. Which three statements are correct when the Autonomous Database is stopped? (Choosethree.)

  1. User with DWROLE can still access the database.
  2. Tools are no longer able to connect to a stopped instance.
  3. CPU billing is halted based on full-hour cycles of usage.
  4. In-flight transactions and queries are stopped.

Answer: BCD

Explanation:Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomousstop.html#GUID-9AF677F3-027A-43FD-B018-9F4A42D5CDE9

8. A customer wants to migrate to Autonomous Database (ADB) but only allows for a very smallwindow of downtime. Golden Gate was advised to be used during the migration. For maximumreassurance of their end-users, the customer also would like to use Golden Gate as a fall-backscenario for the first 6 months after the migration. If customers complain, the on-premise datacan be synchronised with the ADB Instance for a switch back.Which statement about the migration using Golden Gate is correct?

  1. Migration to ADB is not possible using Golden Gate because the apply-process cannot beinstalled on ADB.
  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.
  4. The fallback scenario is not possible using Golden Gate because the capture-process cannotbe installed on ADB.
  5. The described scenario is correct, can be used for migration and fallback scenarios.

Answer: B

9. What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?

  2. ADMIN
  4. ADWC



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

  1. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
  2. Data Pump is platform independent - it can migrate Oracle Databases running on any platform.
  3. Data Pump is faster to migrate database than using RMAN.
  4. Data Pump creates the table spaces used by your Autonomous Database.

Answer: AC


Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-datadata-pump.html#GUID-30DB1EEA-DB45-49EA-9E97-DF49A9968E24

11. Which two system privileges does a user need to create analytic views? (Choose two.)


Answer: DE


Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analyticviews.html#GUID-6F948948-6AE6-4A89-8AAC-5B8952CEF41D

12. Which three statements are true about procedures in the DBMS_CLOUD package?(Choose three.)

  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.
  3. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files foran external table, generates log information, and stores the rows that do not match the formatoptions specified for the external table in a badfile table on Autonomous Data Warehouse.
  4. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from theAutonomous Data Warehouse database.
  5. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table onfiles in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

Answer: BDE


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

13. Which statement is true in regards to database links?

  1. You can call PL/SQL procedures and functions using a database link.
  2. Connect from Autonomous Database to remote database using a database link.
  3. Connect to Autonomous Database from remote database using a database link.
  4. Create a database link from one Autonomous Database to another Autonomous Databaseinstance.

Answer: D


Reference: https://blogs.oracle.com/datawarehousing/making-database-links-from-adw-to-other-databases

14. While Autonomous Transaction Processing and Autonomous Data Warehouse use thesame Oracle database, which statement is true about the workloads?

  1. Autonomous Transaction Processing memory usage optimizes workloads for parallel joinsand aggregations.
  2. Autonomous Data Warehouse workloads are optimized for mixed workloads.
  3. Autonomous Transaction Processing workloads are optimized for data warehouse, datamart, and data lake.
  4. Data that is bulk loaded, by default, uses the row format in Autonomous TransactionProcessing where Autonomous Data Warehouse data format is columnar.

Answer: B


Reference: https://www.oracle.com/a/ocom/docs/database/oracle-autonomous-database-strategy-wp.pdf

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.
  2. SSH keys are not required in Oracle Cloud Infrastructure.
  3. SSH keys cannot be added from console. They have to be added using REST APIs only.
  4. Navigate to Identity, select Users panel on the console and select "Add Public Key".

Answer: D


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