Question 1

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 2

What happens with the standby database when disabling Autonomous Data Guard?

Options :

A : The standby database is terminated.

B : The standby database is started read-write

C : The standby database is started read-only

D : The standby database is transformed into a refreshable clone

Answer: D

Question 3

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

Options :

A : Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.

B : Autonomous Data Warehouse workloads are optimized for mixed workloads.

C : Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.

D : Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

Answer: D

Question 4

What is the number of concurrent statements that can be handled by the medium database service name?

Options :

A : 1-25 X OCPU

B : OS

C : unlimited

D : 20 X OCPU

Answer: A

Question 5

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