Question 1

Which two tasks can be executed from the service console for Autonomous Databases?

Options :

A : creating and scaling an Autonomous Database service

B : configuring virtual cloud networks (VCNS)

C : monitoring Autonomous Databases for usage and query performance

D : using a wizard to download connection wallet for connection from desktop tools

E : starting and stopping an instance

Answer: C,D

Question 2

Which DBMS_WORKLOAD_REPOSITORY subprogram procedure can be used to modify the default eight day retention period for Autonomous Database performance data?

Options :

A : MODIFY_BACELINE_WINDOW_SIZE

B : UPDATE_OBJECT_INFO

C : CREATE_BASELINE_TEMPLATE

D : MODIFY_SNAPSHOT_SETTINGS

Answer: D

Question 3

Which two statements are true about accessing the Autonomous Database Tools?

Options :

A : Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpoint networking.

B : Oracle APEX can be accessed only from the Developer menu in the Service Console.

C : Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.

D : Access to Database Actions is available for all users of Autonomous Database.

E : SQL Developer Web is exclusive to Autonomous Database, not traditional Oracle databases.

Answer: B,E

Question 4

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 5

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