1z0-931 practice test

1. Question 1 · 1

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

   Choose all answers that apply.

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

2. Question 2 · 1

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

   Choose one answer.

   • Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
   • Autonomous Data Warehouse workloads are optimized for mixed workloads.
   • Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
   • Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

3. Question 3 · 1

   When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

   Choose one answer.

   • Active transactions continue running unaffected.
   • Active transactions are paused.
   • Scaling cannot happen while there are active transactions in the database.
   • Active transactions are terminated and rolled back.

4. Question 4 · 1

   The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usemames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it). Which statement is true about the migration of the application's database success?

   Choose one answer.

   • The migration can be technically a success but the 3-rd party vendor needs to support the result.
   • The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.
   • The tablespace names will result in a blocking error during datapump import because of ADB limitations.
   • The migration can be a success, both technically and functional due to datapump enhancements.

5. Question 5 · 1

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

   Choose one answer.

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

6. Question 6 · 1

   Which statement is true regarding database client credentials file required to connect to your Autonomous Database?

   Choose one answer.

   • Place the credential files on a share drive that all users can use to connect to the database.
   • The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database.
   • Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.
   • When you share the credential files with authorized users, mail the wallet password and the file in the same email.

7. Question 7 · 1

   In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

   Choose one answer.

   • In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition.
   • In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.
   • In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.
   • In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.

8. Question 8 · 1

   Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

   Choose one answer.

   • Replicate the table using Golden Gate
   • Create a Data Set
   • Load data using Data Pump
   • Import Table

9. Question 9 · 1

   A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well. Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

   Choose one answer.

   • Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
   • ADW since operational reporting is a higher priority in this scenario.
   • It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
   • ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

10. Question 10 · 1

    Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

    Choose all answers that apply.

    • The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
    • The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
    • A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
    • The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
    • The target table will be created in Autonomous Database if it does not already exist.

11. Question 11 · 1

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

    Choose all answers that apply.

    • The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
    • The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
    • The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
    • The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
    • The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

12. Question 12 · 1

    Which is NOT required to connect to Autonomous Database from SQL developer?

    Choose one answer.

    • Database name
    • Service name
    • Wallet file
    • Username and password

13. Question 13 · 1

    What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.)

    Choose all answers that apply.

    • Golden Gate
    • Recovery Manager (RMAN)
    • CSV files copied to Autonomous Database block storage
    • Data Pump

14. Question 14 · 1

    Which of these database features is NOT part of the Autonomous Database?

    Choose one answer.

    • Online Indexing
    • Flashback Database
    • Real Application Clusters (RAC)
    • Java in the Database

15. Question 15 · 1

    Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?

    Choose one answer.

    • Terraform
    • REST API
    • Dlocker
    • Enterprise Manager

Paid access to all 23 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.