1Z0-931-22 Online Practice Questions and Answers

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

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.

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

A. DOC

B. AVRO

C. JSON

D. DDL

E. Dcsv

F. Parquet

Which option should you use to create a graph with Graph Studio?

A. A graph license key

B. NoSQL configuration

C. Graph created by a special tool downloaded from oracle.com

D. Graph analytics algorithms

E. Tables in an Autonomous Database instance

A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment.

What should theydo to remove this bottleneck?

A. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

B. Remove any non-JSON data from the database.

C. Increase the number of OCPUs allocated to the database.

D. Ask Support to migrate their setup to a node without noisy neighbors.

Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?

A. The Autonomous Database must belong to a Network Security Group (NSG).

B. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.

C. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.

D. The marketplace OCI image can be used with an Always Free Autonomous Database account.

E. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.

Which three are Oracle-recommended best practices for Autonomous Database alarms?

A. Suppress alarms during investigations.

B. Create multiple alarm metrics.

C. Create a single alarm for each metric.

D. Select the correct alarm interval for your metric.

E. Routinelytune your alarms.

F. Use a single interval for all alarms.

You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:

Autonomous Transaction Processing License Included Shared Infrastructure

Which parameter would you NOT use?

A. db-workload

B. is-dedicated

C. db-type

D. license-model

Which two methods canyou use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure A. service console

A. SQL Developer

B. the DBMS_CLOUD_ADMIN package

C. SQL *Plus

Youhave 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

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?

A. The SQL statement completed its execution.

B. The SQL statement is executing.

C. TheSQL statement is queued.

D. The SQL statement did not complete either due to an error.