Which four file formats are supported when loading data from Cloud Storage?

• A.Parquet
• B.Dcsv
• C.JSON
• D.DOC
• E.AVRO
• F.DDL

Comment: *

Name: *

Email: *

Verification: *

You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.
The load on the database increases from three OCPUs to nine OCPUs.
What is the total number of concurrent statements that the TPURGENT service can support?

• A.900
• B.1800
• C.2700
• D.1500

Correct Answer: C

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-priorities.html#GUID-6E4DCD27-CDAA-432D-A90B-485C19EF72B0 It's 300x the number of OCPUs for TPURGEN

Comment: *

Name: *

Email: *

Verification: *

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

• A.Index Storage
• B.Data Organization
• C.Undo Management
• D.Backup Retention
• E.Memory Usage

Comment: *

Name: *

Email: *

Verification: *

Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is stopped.
Which statement is true?

• A.The standby database is terminated.
• B.Switchover is automatically initiated.
• C.Failover is automatically initiated.
• D.The standby database is also stopped.

Comment: *

Name: *

Email: *

Verification: *

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?

• A.SQLDEV_ADMIN.GRANT_SCHEMA
• B.ORDS_ADMIN.ENABLE_SCHEMA
• C.ORDS_ADMIN.GRANT_SCHEMA
• D.ORDS_PRIV.ENABLE_SCHEMA

Comment: *

Name: *

Email: *

Verification: *