Question 1

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

Options :

A : The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.

B : The source files can reside in Oracle Object Storage, Amazon S3 Object Storage, or Azure Blob Storage.

C : The target table will be created in Autonomous Database if it does not already exist.

D : The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.

E : A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

Answer: B,E

Question 2

Which two options are available to restore an Oracle Autonomous Database?

Options :

A : Select the backup from which restore needs to be done.

B : Specify the point in time (timestamp) to restore.

C : Select the snapshot of the backup.

D : Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.

E : Specify the archived custom image.

Answer: A,B

Question 3

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

Options :

A : Backup and recovery must be done using Recovery Manager(RMAN).

B : Select the snapshot of the backup.

C : Select the archived redo logs.

D : Select the backup from which restore needs to be done.

E : Specify the point in time (timestamp) to restore.

Answer: A,D

Question 4

What is a best practice when planning and instituting access controls for your Autonomous Dedicated environment regarding subnets, compartments, and user groups?

Options :

A : Create a separate VCN that contains only public subnets

B : Only 1 of each is allowed to be allocated per environment.

C : Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.

D : Create at least 2 of each resource.

Answer: D

Question 5

Which two statements are true about using an Oracle Autonomous Database with private endpoints? (Choose two.)

Options :

A : A Network Security Group is required within your Virtual Cloud Network before you can provision a shared Autonomous Database to use private endpoints.

B : An Autonomous Database with private endpoints can be accessed from the public internet by adding your IP address to an Access Control List (ACL).

C : Private endpoints can be configured when you clone a shared Autonomous Database that was initially created with public endpoints.

D : You can configure private endpoints for an Always Free Autonomous Database

Answer: A,C

Free 1Z0-931-25 Mock Exam – Practice Online Confidently

Buying Options: