1Z0-931-21 Online Practice Questions and Answers

The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?

A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,

B. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

C. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database

D. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure

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

A. Undo Management

B. Index Storage

C. Memory Usage

D. Data Organization

E. Backup Retention

Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.

Which statement is FALSE?

A. Oracle Data Safe only supports Autonomous Databases.

B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.

C. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.

D. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.

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

To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?

A. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB

B. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure

C. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB - >Database Administrator -> Autonomous DB

D. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB

During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

A. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator

B. the Client Credentials wallet which is used to connect to the Autonomous Database

C. the 'High Availability Container Database' in which the Autonomous instance should run

D. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment

E. the Listener endpoint where the Autonomous Database should register on

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

A. It cannot be done.

B. Using Database Configuration Assistant (DBCA) on the database server.

C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

D. Connecting to the Cloud Infrastructure Command console via SSH wallet.

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)

What is the correct way to list all files in the default data pump directory?

A. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');

B. You cannot list files in the default data pumpdirectory from Autonomous Data Warehouse (ADW).

C. Log onto ADW server and issue is -al on the command line.

D. By executing select * from utl_file . list ( `DATA_PUMP_DIR ' ) ;

Which three of the following data sources are available when using the Data Load page on Database Actions?

A. Files in Oracle Cloud Storage

B. Backup files in block storage

C. Local Files

D. Files in AWS S3 Storage

E. REST endpoints