Oracle 1z0-931-22 today updated questions - Verified by Oracle Experts

Oracle Autonomous Database Cloud 2022 Professional Questions and Answers

Question 1

When enabling auto-scaling, which three options do not change?

Options:

Number of OCPUs displayed in the console.

Amount of storage

I/O resources

parallelism settings

Level of concurrency

Question 2

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

Options:

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

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

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

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

Question 3

What are three methods to load data into the Autonomous Database?

Options:

Oracle GoldenGate

Transportable Tablespace

RMAN Restore

Oracle Data Pump

SQL*Loader

Question 4

Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?

Options:

RMAN

Logs

OCI Metrics

Performance Hub

Enterprise Manager Cloud Control

Question 5

Whichstatement is FALSE about Oracle Data Safe?

Options:

It supports only Autonomous Databases.

It helps you assess the security of your cloud database configurations by analyzing database configurations.

It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.

It evaluates user types, how users are authenticated, and the password policies assigned to each user.

It helps you evaluate risks to data, assess user security, monitor useractivity, and address data security compliance requirements.

Question 6

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

Options:

Backup and recovery must bedone using Recovery Manager(RMAN).

Select the snapshot of the backup.

Select the archived redo logs.

Select the backup from which restore needs to be done.

Specify the point in time (timestamp) to restore.

Question 7

Which three options are available to access data in an Autonomous JSONDatabase?

Options:

Oracle Cloud Infrastructure console using the JSON Online Developer tool

Oracle JSON Developer tool downloaded from OTN

NOSQL statements using Oracle SODA drivers

REST API calls to the database (not enabled by default)

Regular Oracle SQL statements using a connection through the listener

Question 8

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:

Business Models

Data Load

SQL Developer Web

APEX

Question 9

While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?

Options:

60 days

7 days

15 days

120 days

Question 10

Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

Options:

The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.

The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores CloudObject Storage credentials in the Autonomous Data Warehouse database.

The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format optionsspecified for the external table in a badfile table on Autonomous Data Warehouse.

The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.

The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates anexternal table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

Answer:

B, C, E

Explanation:

DELETE_FILE Procedure

This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.

CREATE_CREDENTIAL Procedure

This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. Use stored credentials for data loading or for querying external data residing in the Cloud.

PUTJDBJECT Procedure

This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).

VALIDATE EXTERNAL TABLE Procedure

This procedure validates the source files for an external table, generateslog information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.

CREATE_EXTERNAL_TABLE Procedure

This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.

To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process.

This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're

moving the log import.log to object store witha DBMS_CLOUD.PUT_OBJECT command.

VALIDATE_EXTERNAL_TABLE Procedure

This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in abadfiletable on Autonomous Database. The overloaded form enables you to use the operation_id parameter.

PUT_OBJECT Procedure

This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedureis 5 gigabytes (GB)

DELETE FILE Procedure

This procedure removes the specified file from the specified directory on Autonomous Database.

CREATE_EXTERNAL_TABLE Procedure

This procedure creates an external table on files in the Cloud. This allows you to runqueries on external data from Autonomous Database.

Question 11

Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?

Options:

Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments.

Moving an Autonomous Database instance does not include its automatic backups.

You do not need to have sufficient access permissions on the compartment that the resource is being moved to.

Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.

Question 12

Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)

Options:

RMAN Cross-Platform backup and restore

Golden Gate on-premise installation

PDB unplug / plug operation

Datapump export / import

Dataguard Physical Standby

Golden Gate Cloud service

Question 13

Which statement is NOT correct when setting up compartment quotas?

Options:

There are three types of quota policy statements which are set, unset and zero.

Compartment quotas use policies that allow allocation of resources with ahigh level of flexibility.

Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.

Compartment quotas are set by Oracle.

Question 14

Which two are correct actions to take in order to Download the Autonomous Database Credentials?

Options:

Click on the Autonomous Data Warehouse in the menu,click a database name, then Choose DB

Connection button, then Download the Wallet.

Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then

Download the Wallet.

Click the Compute section of the menu, then choose Instance Configurations, then Download

Wallet.

Click on the Object Storage and find your Autonomous Bucket and Download the Wallet

Credentials.

Find the Service Console for your Autonomous Database, then pick Administration, then Download

the Client Credentials (Wallet).

Question 15

Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

Options:

The Autonomous Database must be in the same VCN and Subnet as the Compute instance.

The OCI compute instance does not support connecting to a Shared Autonomous Database.

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

The OCI compute instance can be used with an Always-Free Autonomous Database account.

A Private Endpoint is required to connect to the Shared-Autonomous Database.

Question 16

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

Options:

Network Security Group

Security List

VCN

Route Table

Subnet

Load More 1z0-931-22 Questions

Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Oracle 1z0-931-22 Oracle Autonomous Database Cloud 2022 Professional Exam Practice Test

Oracle Autonomous Database Cloud 2022 Professional Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation: