Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?

• A.Only ATP manages optimizer statistics.
• B.Only ADW uses columnar compression by default.
• C.Only ATP supports automatic backups.
• D.Only ADW supports autoscaling.

Comment: *

Name: *

Email: *

Verification: *

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.
What steps do you need to take?

• A.Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
• B.Create a database user with the default privileges.
• C.Create a database user with connect, resource, and object privileges.
• D.Create an IDCS user. Create a database user with connect, resource, and object privileges.

Comment: *

Name: *

Email: *

Verification: *

In which four ways can Oracle Database optimally access data in Object Storage?

• A.scan avoidance using partitioned external tables
• B.scan avoidance using columnar pruning for .csv files
• C.scan avoidance using columnar pruning for columnar stores like parquet and orc
• D.optimized data archive using partitioned external tables
• E.optimized data archive using hybrid partitioned tables
• F.scan avoidance using block skipping when reading parquet and ore files

Comment: *

Name: *

Email: *

Verification: *

For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

• A.Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'DW'
• B.Allow group ADB-Admins to manage autonomous-database in tenancy.
• C.Allow group ADB-Admins to manage autonomous-database-family in tenancy.
• D.Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'

Comment: *

Name: *

Email: *

Verification: *

Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

• 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.
• 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

Comment: *

Name: *

Email: *

Verification: *