Question 1

You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance.Which tool would you use to automate data exploration and create pivot tables?

Options :

A : Business Models

B : Data Load

C : SQL Developer Web

D : APEX

Answer: A

Question 2

Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?

Options :

A : Data formats supported include: text, CSV, JSON, Avro, and Parquet

B : Data can be loaded from a local data source

C : Data can be uploaded from several cloud storage sources including S3, Azure, Google Cloud, and Oracle Object Storage

D : You must first manually create your database credentials using DBMS_CLOUD.CREATE_CREDENTIAL before accessing your Oracle Object Storage Bucket

E : Data can be loaded from a remote database using Database Links (DBLinks)

Answer: D

Question 3

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

Options :

A : Users are offered greater control and isolation starting at the Exadata Cloud Infrastructure level.

B : Users can customize the OS stack and add additional packages.

C : Users have OS access to the database machine.

D : Users have SYS privileges in the database.

E : Users have more control over the maintenance schedule.

Answer: A,E

Question 4

When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?

Options :

A : 2 hours

B : 30 minutes

C : 1 hours

D : 24 hours

Answer: A

Question 5

On which two infrastructure classes can the Autonomous Database service be deployed?

Options :

A : Shared Exadata Infrastructure

B : Dedicated Exadata Infrastructure

C : Exadata Cloud Service

D : Oracle Cloud Infrastructure Virtual Machines

Answer: A,B

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

Buying Options: