Skip to main content

1Z0-931-22 Real Exam Questions

Oracle Autonomous Database Cloud 2022 Professional

112 questions available · Page 1 of 12

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

  1. A

    IOPS, Storage Space Used By Tablespace, Applyand Transport Lag

  2. B

    CPU Utilization, Storage Utilization

  3. C

    Query Latency, User Calls, Execute Count

  4. D

    Transaction Count, Sessions, Running Statements

Show answer and explanation

Correct answer: B

Question 2 Single choice

What is the correct way to list all files in the default data pump directory?

  1. A

    By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');

  2. B

    You cannot list files in the default data pumpdirectory from Autonomous Data Warehouse (ADW).

  3. C

    Log onto ADW server and issue is -al on the command line.

  4. D

    By executing select * from utl_file . list ( `DATA_PUMP_DIR ' ) ;

Show answer and explanation

Correct answer: A

Question 3 Multiple choice

Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

  1. A

    Transparent Data Encryption

  2. B

    Database Vault

  3. C

    Customer Managed Keys

  4. D

    Data Redaction

  5. E

    Audit Vault

Show answer and explanation

Correct answers: A, B, C

Explanation

https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472B-8287-41682C2B61B3

Question 4 Single choice

Which statement is correct about the Service consolein an Autonomous Database?

  1. A

    You can use Service console to enable or disable auto scaling of Autonomous DB

  2. B

    You can use Service console to manage runaway SQL statements on Autonomous DB

  3. C

    You can use Service console to move Autonomous DB betweencompartments

  4. D

    You can use Service console to create manual backups of Autonomous database

Show answer and explanation

Correct answer: B

Explanation
Question 5 Single choice

You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.

Which service will you need to connect to?

  1. A

    TPURGENT

  2. B

    TP

  3. C

    MEDIUM

  4. D

    LOW

Show answer and explanation

Correct answer: A

Explanation

tpurgent: The highest priority application connection service for time critical transaction processing operations. This connectionservice supports manual parallelism.

https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-
9747539B-FD46-44F1-8FF8-F5AC650F15BE

Question 6 Multiple choice

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

  1. A

    Network Security Group

  2. B

    Security List

  3. C

    VCN

  4. D

    Route Table

  5. E

    Subnet

Show answer and explanation

Correct answers: A, C, E

Explanation

To provision an Autonomous Database with a private endpoint, you must have the following resources already created: A VCN within the region that will contain your Autonomous Database with shared Exadata infrastructure.
Cannot be changed after provisioning. A private subnet within your VCN configured with default DHCP options. Cannot be changed after provisioning.
At least 1network security group (NSG) within your VCN for the Autonomous Database. Can be changed or edited after provisioning.

https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbsprivateaccess.htm

Question 7 Multiple choice

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

  1. A

    through the Oracle Cloud Infrastructure service console

  2. B

    through SQL/Developer s

  3. C

    using DBMS_CLOUD_ADMIN package

  4. D

    through SQLPIus

Show answer and explanation

Correct answers: B, D

Explanation

https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-
warehouse-adw-create-service
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B

"To create users in your database, connectto the database as the ADMIN user using any SQL client tool."
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-create.html#GUID-54CA837B-CD6A-4ED2-A960-5874535818CB

Question 8 Single choice

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance.

What should youdo?

  1. A

    Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database

  2. B

    Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"

  3. C

    Create a notification alert using DBMS_SNMP package

  4. D

    Create an Oracle Cloud Infrastructure Alarm for Shutdown metric

Show answer and explanation

Correct answer: B

Explanation
Question 9 Multiple choice

Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

  1. A

    Undo Management

  2. B

    Index Storage

  3. C

    Memory Usage

  4. D

    Data Organization

  5. E

    Backup Retention

Show answer and explanation

Correct answers: B, C

Question 10 Multiple choice

Which three of the following data sources are available when using the Data Load page on Database Actions?

  1. A

    Files in Oracle Cloud Storage

  2. B

    Backup files in block storage

  3. C

    Local Files

  4. D

    Files in AWS S3 Storage

  5. E

    REST endpoints

Show answer and explanation

Correct answers: A, C, D