Labour Day Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

Oracle Autonomous Database Cloud 2023 Professional Question and Answers

Oracle Autonomous Database Cloud 2023 Professional

Last Update May 3, 2024
Total Questions : 180

We are offering FREE 1z0-931-23 Oracle exam questions. All you do is to just go and sign up. Give your details, prepare 1z0-931-23 free exam questions and then go for complete pool of Oracle Autonomous Database Cloud 2023 Professional test questions that will help you more.

1z0-931-23 pdf

1z0-931-23 PDF

$35  $99.99
 Add to Cart
1z0-931-23 Engine

1z0-931-23 Testing Engine

$42  $119.99
 Add to Cart
1z0-931-23 PDF + Engine

1z0-931-23 PDF + Testing Engine

$56  $159.99
 Add to Cart
Questions 1

Which two statements are true about Data Insights?

Options:

A.  

You can retrieve previously executed Data Insights searches.

B.  

Data Insights is available with on-premises deployments of Oracle Database.

C.  

Data Insights is an additional priced option.

D.  

You can search for Data Insights against a base table or business model.

Discussion 0
Questions 2

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

Options:

A.  

DOC

B.  

AVRO

C.  

JSON

D.  

DDL

E.  

Dcsv

F.  

Parquet

Discussion 0
Questions 3

Which three functions are provided by Spatial Studio?

Options:

A.  

Spatial analysis

B.  

Geocoding

C.  

Custom SQL queries

D.  

Map visualization

E.  

Spatial data editing

Discussion 0
Questions 4

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

Options:

A.  

Oracle GoldenGate

B.  

Transportable Tablespace

C.  

RMAN Restore

D.  

Oracle Data Pump

E.  

SQL*Loader

Discussion 0
Questions 5

Which three event types are supported for Autonomous Database?

Options:

A.  

Terminate End

B.  

Maintenance Begin

C.  

Change Compartment Begin

D.  

Change Autoscaling Configuration Compartment

E.  

Update IORM Begin

Discussion 0
Questions 6

Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?

Options:

A.  

Maximum Continuity

B.  

Maximum Availability

C.  

Maximum Performance

D.  

Maximum Protection

Discussion 0
Questions 7

Which three tasks are performed from the service console of an Autonomous Database on Shared Infrastructure?

Options:

A.  

Manage Oracle Machine Learning users

B.  

Download the wallet

C.  

Rotate the wallet

D.  

Set resource management rules

E.  

Enable autoscaling

Discussion 0
Questions 8

Which two actions can be performed when an Autonomous Database is stopped?

Options:

A.  

Start

B.  

Update License Type

C.  

Update Network Access

D.  

Change Administrator Password

Discussion 0
Questions 9

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

Options:

A.  

In-flight transactions 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

Discussion 0
Questions 10

What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?

Options:

A.  

Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.

B.  

Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.

C.  

Fleet Administrators are responsible for patching and backups of all container databases.

D.  

Fleet Administrators create, monitor and manage Autonomous Databases.

Discussion 0
Questions 11

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

Options:

A.  

Autonomous Transaction Processing

B.  

Autonomous Data Warehouse

C.  

Neither service ignores hints by default

D.  

Both services ignore hints by default

Discussion 0
Questions 12

Which stage of the indexing pipeline divides text into tokens?

Options:

A.  

SECTIONER

B.  

FILTER

C.  

Otokenizer

D.  

LEXER

Discussion 0
Questions 13

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

Options:

A.  

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

B.  

You cannot list files in the default data pump directory 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 ' ) ;

Discussion 0
Questions 14

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

Options:

A.  

User's OCID

B.  

Tenancy's OCID

C.  

Database ADMIN password

D.  

Fingerprint of the public key

Discussion 0
Questions 15

A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during nonpeak hours. The architecture team is debating whether such reports should be run on the online transaction processing (OLTP) database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well

Options:

A.  

Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types

B.  

The application should be deployed on a Kubernetes Cluster because it needs to be highly available

C.  

It is best to build a separate data warehouse, and move the OLTP data on a nightly basis

D.  

Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority in this scenario

Discussion 0
Questions 16

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?

Options:

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.

Discussion 0
Questions 17

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

Options:

A.  

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

B.  

Oracle Machine Learning Zeppelin Notebook, 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

Discussion 0
Questions 18

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

Options:

A.  

A graph license key

B.  

Tables in an Autonomous Database instance

C.  

NoSQL configuration

D.  

Graph analytics algorithms

E.  

Graph created by a special tool downloaded from Oracle.com

Discussion 0
Questions 19

Which two are ways Oracle Database can optimally access data in Object Storage?

Options:

A.  

Optimized data archive using hybrid partitioned tables

B.  

Optimized data archive using partitioned external tables

C.  

Scan avoidance using partitioned external tables

D.  

Scan avoidance using columnar pruning for .csv files

Discussion 0
Questions 20

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?

Options:

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

Discussion 0
Questions 21

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

Options:

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

Discussion 0
Questions 22

Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endpoints with security rules to allow incoming and outgoing traffic to and from the Autonomous Database Instance?

Options:

A.  

The IP Protocol is set to TCP

B.  

A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance

C.  

The source is set to the address range you want to allow to connect to your database

D.  

The destination port range is set to 1522

Discussion 0
Questions 23

Which two of the following statements are correct?

Options:

A.  

ODI Web Edition is available only on Oracle Linux.

B.  

ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.

C.  

The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.

D.  

All of the capabilities of ODI Classic are available with ODI Web Edition,

Discussion 0
Questions 24

Which two statements apply to the Autonomous Database service on Dedicated Infrastructure?

Options:

A.  

You can set a maintenance window for each individual Autonomous Container Database

B.  

You, as the customer, are responsible for all patching operations

C.  

You can set a maintenance window for an Autonomous Exadata Infrastructure

D.  

Patching occurs on the first Sunday of each quarter

Discussion 0
Questions 25

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

Options:

A.  

The SQL statement completed its execution.

B.  

The SQL statement is executing.

C.  

The SQL statement is queued.

D.  

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

Discussion 0
Questions 26

Which two methods can you use to define Oracle Machine Learning users?

Options:

A.  

SQL Developer

B.  

the DBMS_CLOUD_ADMIN package

C.  

Oracle Cloud Infrastructure Console

D.  

Service Console

Discussion 0
Questions 27

When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

Options:

A.  

Under Core Infrastructure then Compute then Autonomous Exadata

B.  

Under Solutions and Platform then Platform Services then Autonomous Exadata

C.  

Under Database then Autonomous Transaction Processing then Autonomous Exadata

D.  

Under Core Infrastructure then Autonomous Exadata

Discussion 0
Questions 28

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?

Options:

A.  

db-workload

B.  

is-dedicated

C.  

db-type

D.  

license-model

Discussion 0
Questions 29

Which are the two restrictions for an Always Free Autonomous Database?

Options:

A.  

supports only ATP as a workload type

B.  

maximum of two Always Free Databases per OCI tenancy

C.  

Oracle Application Express (APEX) not included

D.  

maximum of one OCPU per Database

Discussion 0
Questions 30

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

Options:

A.  

Transparent Data Encryption

B.  

Database Vault

C.  

Customer Managed Keys

D.  

Data Redaction

E.  

Audit Vault

Discussion 0
Questions 31

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

Options:

A.  

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

Connection button, then Download the Wallet.

B.  

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

Download the Wallet.

C.  

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

Wallet.

D.  

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

Credentials.

E.  

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

the Client Credentials (Wallet).

Discussion 0
Questions 32

Which option is not available to pick ( no.of days ) when configuring the backup retention for Oracle Container Database.

Options:

A.  

120

B.  

60

C.  

15

D.  

7

Discussion 0
Questions 33

What are four methods to load data into an Autonomous Database?

Options:

A.  

SQL*Loader

B.  

Oracle Data Pump

C.  

Database Actions

D.  

Transportable Tablespace

E.  

Oracle GoldenGate

F.  

RMAN Restore

Discussion 0
Questions 34

Who, and in which order, provisions dedicated Exadata Infrastructure resources?

Options:

A.  

The database administrator provisions the Autonomous Container DB and the Autonomous DB Then, the feet administrator provisions the Autonomous Exadata Infrastructure

B.  

The fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container D

B.  

Then, the database administrator provisions the Autonomous DB

C.  

The database administrator provisions the Autonomous Exadata Infrastructure. Then, the fleet administrator provisions the Autonomous Container DB and then the Autonomous DB

D.  

The fleet administrator provisions the Autonomous Exadata Infrastructure. Then, the database administrator provisions the Autonomous Container DB and then the Autonomous DB

Discussion 0
Questions 35

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

Options:

A.  

An "INSERT" REST call

B.  

A "GET" REST call

C.  

A "POST" REST call

D.  

A "PUT" REST call

Discussion 0
Questions 36

You have been tasked with analyzing a year's worth of sales data stored in an Autonomous Data Warehouse instance.

Which tool would you use to automate data exploration and create pivot tables?

Options:

A.  

Business Models

B.  

APEX

C.  

SQL Developer Web

D.  

Data Load

Discussion 0
Questions 37

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?

Options:

A.  

SQLDEV_ADMIN.GRANT_SCHEMA

B.  

ORDS_ADMIN.ENABLE_SCHEMA

C.  

ORDS_ADMIN.GRANT_SCHEMA

D.  

ORDS_PRIV.ENABLE_SCHEMA

Discussion 0
Questions 38

Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?

Options:

A.  

Exadata

B.  

Active Data Guard

C.  

RAC, but only when scaling beyond 16 OCPUs

D.  

Transparent Data Encryption

E.  

Multitenant

Discussion 0
Questions 39

Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

Options:

A.  

IOPS, Storage Space Used By Tablespace, Apply and Transport Lag

B.  

CPU Utilization, Storage Utilization

C.  

Query Latency, User Calls, Execute Count

D.  

Transaction Count, Sessions, Running Statements

Discussion 0
Questions 40

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

Options:

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

Discussion 0
Questions 41

Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?

Options:

A.  

Oracle Key Vault, Oracle Cloud Infrastructure Vault

B.  

Oracle Database Vault, Oracle Key Vault

C.  

Oracle Audit Vault, Oracle Key Vault

D.  

Oracle Cloud Infrastructure Vault, Oracle Database Vault

Discussion 0
Questions 42

You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.

What statement describes the step to provide the developer a new workspace in APEX?

Options:

A.  

Create an IDCS user with the APEX role.

B.  

Access the APEX Administration Services and create the workspace for the developer.

C.  

Create a new developer account.

D.  

Create a database user with the APEX role.

Discussion 0
Questions 43

Which three methods can be used to migrate on-premises databases to Oracle Autonomous Database (both Shared and Dedicated)?

Options:

A.  

RMAN backup & restore

B.  

Physical migration methods, such as database cloning

C.  

Orace Zero Downtime Migration (ZDM)

D.  

Original imp/exp tools

E.  

Oracle Data Pump

F.  

Oracle Golden Gate

Discussion 0
Questions 44

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

Options:

A.  

A Network Security Group is required within your Virtual Cloud Network before you can provision a

Shared Autonomous Database to use Private Endpoints

B.  

An Autonomous Database with private endpoints can be accessed from the public internet by

adding your ip address to an Access Control List.

C.  

Private Endpoints can be configured when you clone a Shared Autonomous Database that was

initially created with public endpoints.

D.  

You can configure Private Endpoints for an Always Free Autonomous Database

Discussion 0
Questions 45

Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?

Options:

A.  

Data Insights

B.  

JSON

C.  

Catalog

D.  

Data Load

Discussion 0
Questions 46

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

Options:

A.  

Parquet

B.  

DOC

C.  

DDL

D.  

JSON

E.  

CSV

F.  

AVRO

Discussion 0
Questions 47

Which two methods can you use to create database users and grant roles in Autonomous Database services?

Options:

A.  

the Oracle Cloud Infrastructure

A.  

service console

B.  

SQL Developer

C.  

the DBMS_CLOUD_ADMIN package

D.  

SQL *Plus

Discussion 0