1z0-931-20 practice test

1. Question 1 · 1

   When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)

   Choose one answer.

   • DBNAME_MEDIUM
   • DBNAME_HIGH
   • DBNAME_CONCURRENT
   • DBNAME_LOW

2. Question 2 · 1

   Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

   Choose all answers that apply.

   • Select the snapshot of the backup.
   • Select the backup from which restore needs to be done.
   • Backup and recovery must be done using Recovery Manager (RMAN).
   • Select the archived redo logs.
   • Specify the point in time (timestamp) to restore.

3. Question 3 · 1

   Which three event types are supported for Autonomous Database? (Choose three.)

   Choose all answers that apply.

   • Update IORM Begin
   • Maintenance Begin
   • Terminate End
   • Change Autoscaling Configuration Compartment
   • Change Compartment Begin

4. Question 4 · 1

   While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads? (Choose the best answer.)

   Choose one answer.

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

5. Question 5 · 1

   You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX. What statement describes the step to provide the developer a new workspace in APEX? (Choose the best answer.)

   Choose one answer.

   • Create a new developer account.
   • Access the APEX Administration Services and create the workspace for the developer.
   • Create a database user with the APEX role.
   • Create an IDCS user with the APEX role.

6. Question 6 · 1

   What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure? (Choose two.)

   Choose all answers that apply.

   • Users have OS access to the database machine.
   • It offers greater control and isolation starting at the Exadata cloud infrastructure level.
   • Users can customize the OS stack and add additional packages.
   • Users have SYS privileges in the database.
   • Users can customize the maintenance schedule.

7. Question 7 · 1

   Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements. Which statement is FALSE? (Choose the best answer.)

   Choose one answer.

   • Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
   • Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
   • Oracle Data Safe only supports Autonomous Databases.
   • Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.

8. Question 8 · 1

   Which statement is true when you provision an Autonomous Database using the cloning method? (Choose the best answer.)

   Choose one answer.

   • A clone database source can be a running database instance.
   • A clone database source can be from a point-in-time backup that is less than 2 hours old.
   • When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
   • After an Autonomous database is created using a clone, the network access option can be changed.

9. Question 9 · 1

   Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

   Choose all answers that apply.

   • through SQLPlus
   • through SQL/Developer
   • through the Oracle Cloud Infrastructure service console
   • using DBMS_CLOUD_ADMIN Package

10. Question 10 · 1

    Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls? (Choose the best answer.)

    Choose one answer.

    • SSH keys are not required in Oracle Cloud Infrastructure.
    • SSH keys cannot be added from console. They have to be added using REST APIs only.
    • On the Autonomous Database Console.
    • Navigate to Identity, select Users panel on the console and select ג€Add Public Keyג€.

11. Question 11 · 1

    Which statement is NOT correct when setting up compartment quotas? (Choose the best answer.)

    Choose one answer.

    • Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
    • Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
    • Compartment quotas are set by Oracle.
    • There are three types of quota policy statements which are set, unset and zero.

12. Question 12 · 1

    Which two statements are true about using an Autonomous Database with Private Endpoints? (Choose two.)

    Choose all answers that apply.

    • Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
    • You can configure Private Endpoints for an Always Free Autonomous Database.
    • A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints.
    • An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.

13. Question 13 · 1

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

    Choose all answers that apply.

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

14. Question 14 · 1

    How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure? (Choose the best answer.)

    Choose one answer.

    • Execute alter tablespace DATA set quota = 10G;
    • Execute alter tablespace for user MTHEO tablespace DATA quota = 10G;
    • Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => 'MTHEO',tablespace_quota => 'UNLIMITED');
    • Execute alter user MTHEO quota unlimited on tablespace DATA;

15. Question 15 · 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 the best answer.)

    Choose one answer.

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

Paid access to all 37 questions

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