Question 1

Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

Options :

A : If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.

B : Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.

C : You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.

D : Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.

Answer: D

Question 2

Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing? (Choose two.)

Options :

A : Memory Usage

B : Data Organization

C : Backup Retention

D : Undo Management

Answer: A,B

Question 3

Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

Options :

A : Autonomous Transaction Processing only

B : Hybrid Columnar Compression

C : ATP and ADW

D : Autonomous Data Warehouse only

Answer: C

Question 4

As a database architect, you are tasked with configuring a high concurrency, production OLTP (EXAM) application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode. Which connection service is appropriate for such a workload?

Options :

A : TPURGENT

B : TP

C : HIGH

D : MEDIUM

Answer: C

Question 5

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?

Options :

A : Add a 'BEFORE SHUTDOWN ON DATABASE' trigger within the database

B : Create a rule for the Oracle Cloud Infrastructure Event for 'Autonomous Database STOP END'

C : Create a notification alert using DBMS_SNMP package

D : Create an Oracle Cloud Infrastructure Alarm for Shutdown metric

Answer: B