[Q33-Q57] 2023 Updated 1z0-931-22 Tests Engine pdf – All Free Dumps Guaranteed!

QUESTION 33
Which two statements are true about accessing Autonomous Database Tools?

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

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

SQL Developer Web is available exclusively on the Autonomous Database.

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.

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

QUESTION 34
According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.
Which statement is true?

Create a separate VCN that contains only public subnets

Only 1 of each is allowed to be allocated per environment.

Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.

Create at least 2 of each resource

QUESTION 35
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?

You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.

You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.

You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.

You can perform a “rolling restart” on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.

QUESTION 36
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.

The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.

A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.

The target table will be created in Autonomous Database if it does not already exist.

QUESTION 37
Which two methods can you use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure

service console

SQL Developer

the DBMS_CLOUD_ADMIN package

SQL *Plus

QUESTION 38
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.

You can use the dbms_auto_index package to report on the automatic task and to set your preferences.

It is enabled by default.

You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.

The indexing feature is implemented as an automatic task that runs at a fixed interval.

QUESTION 39
In Graph Studio which you can use to create a graph?

A graph license key

Tables in an Autonomous Database instance

NoSQL configuration

Graph analytics algorithms

Graph created by a special tool downloaded from Oracle.com

QUESTION 40
What REST verb is used to create an Autonomous Database service using REST APIs?

An “INSERT” REST call

A “GET” REST call

A “POST” REST call

A “PUT” REST call

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

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 42
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

Backup and recovery must be done 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 43
Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)

Oracle Cloud Infrastructure Object Storage

Google Cloud Storage

Amazon S3

Azure Blob Storage

Oracle Cloud Infrastructure Object Storage Classic

QUESTION 44
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 they do to remove this bottleneck?

Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

Remove any non-JSON data from the database.

Increase the number of OCPUs allocated to the database.

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

QUESTION 45
In which four ways can Oracle Database optimally access data in Object Storage?

optimized data archive using partitioned external tables

optimized data archive using hybrid partitioned tables

scan avoidance using block skipping when reading parquet and ore files

scan avoidance using columnar pruning for columnar stores like parquet and orc

scan avoidance using partitioned external tables

scan avoidance using columnar pruning for .csv files

QUESTION 46
Which statement is NOT correct when setting up compartment quotas?

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

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

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

Compartment quotas are set by Oracle.

QUESTION 47
Which statement is FALSE about Oracle Data Safe?

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 user activity, and address data security compliance requirements.

QUESTION 48
Which two actions are available to perform when an Autonomous Database is stopped?

Start

Update Network Access

Change administrator password

Update License Type

QUESTION 49
Which statement is FALSE about setting up compartment quotas?

Quotas set on a parent compartment override quotas set on child compartments.

Compartment quotas cannot be set on the root compartment.

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

You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.

QUESTION 50
A Business Analyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst.
When restoring/cloning the ADB, you must select a backup which is atleast___ hours/minutes old.

24 hrs

2 hrs

5 min

1 day

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

In-flight transactions queries are stopped

Tools are no longer able to connect to a stopped instance

User with DWROLE can still access the database

CPU billing is halted

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

Network Security Group

Security List

VCN

Route Table

Subnet

QUESTION 53
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.

Autonomous Data Warehouse workloads are optimized for mixed workloads.

Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.

Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

QUESTION 54
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints

An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.

Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.

You can configure Private Endpoints for an Always Free Autonomous Database

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

RMAN

Logs

OCI Metrics

Performance Hub

Enterprise Manager Cloud Control

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