1Z0-931-21 Online Practice Questions and Answers

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.

While creating a business model what advanced options you can enable or disable? (Choose three)

A. Business Object Security Feature

B. Analytic View Transparency View

C. Autonomous Aggregate Cache

D. Display private tables

E. Analytic View Base Table Query Transformation

Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?

A. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure

B. Oracle Machine Learning ZeppelinNotebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator

C. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database

D. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure

Which statement is correct about managing and monitoring of Autonomous Database?

A. You can use Service console to move Autonomous DB between compartments.

B. You can use Service console to create manual backups of Autonomous database.

C. You can use Service console to enable or disable auto scaling of Autonomous DB.

D. You can use Service console to manage runaway SQL statements on Autonomous DB.

Which statement is true when you provision an Autonomous Database using the cloning method?

A. After an Autonomous database is created using a clone, the network access option can be changed.

B. A clone database source can be a running database instance.

C. A clone database source can be from a point-in-time backup that is less than 2 hours old.

D. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.

Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?

A. Data Pump Export File

B. Avro

C. Parquet

D. Text

E. JSON

F. Microsoft SQL Server (.mdf)

A new Python developer has joined your team and needs to access the Autonomous Database(ADB) data.

How does the developer connect to and interact with ADB from Python?

A. SQL Developer

B. JAVA JDK

C. You can't use Python with ADB.

D. The Oracle Client and the cx_Oracle interface for Python

Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

A. Transparent Data Encryption

B. Database Vault

C. Customer Managed Keys

D. Data Redaction

E. Audit Vault

Which statement is not correct when the Autonomous Database is stopped?

A. In-flighttransactions queries are stopped

B. Tools are no longer able to connect to a stopped instance

C. User with DWROLE can still access the database

D. CPU billing is halted

Which is NOT needed to manage Oracle Autonomous Database with REST APIS?

A. User's OCID

B. Tenancy's OCID

C. Database ADMIN password

D. Fingerprint of the public key