VCEdump

1Z0-931-21 Oracle Autonomous Database Cloud 2020 Specialist

PDF question preview Back to product

Reading controls

Reader tools

Free demo

17 of 112 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice10

Multiple choice7

Oracle · 1Z0-931-21

Free 1Z0-931-21 Exam Dumps Preview

Preview real exam questions, verified answers and available explanations before choosing a study plan.

Question 1

Single choice

Which statement is FALSE about Oracle Autonomous JSON Database?

A
JSON data is stored natively in the database
B
You can promote Autonomous JSON Database to Autonomous Transaction /Processing
C
It supports NoSQL-style, document-centric application
D
There is a 20 GB limit on JSON collection

Reveal answer details Close answer details

Correct answerD

Explanation

Question 2

Single choice

Whichstatement is FALSE about Oracle Data Safe?

A
It supports only Autonomous Databases.
B
It helps you assess the security of your cloud database configurations by analyzing database configurations.
C
It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.
D
It evaluates user types, how users are authenticated, and the password policies assigned to each user.
E
It helps you evaluate risks to data, assess user security, monitor useractivity, and address data security compliance requirements.

Reveal answer details Close answer details

Correct answerE

Question 3

Multiple choice

Which two of the followingstatements are correct?

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,

Reveal answer details Close answer details

Correct answersA, B

Question 4

Single choice

Which statement is correct about the Service consolein an Autonomous Database?

A
You can use Service console to enable or disable auto scaling of Autonomous DB
B
You can use Service console to manage runaway SQL statements on Autonomous DB
C
You can use Service console to move Autonomous DB betweencompartments
D
You can use Service console to create manual backups of Autonomous database

Reveal answer details Close answer details

Correct answerB

Explanation

Question 5

Single choice

Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is stopped.

Which statement is true?

A
The standby database is terminated.
B
The standby database is also stopped.
C
Switchover is automatically initiated.
D
Failover is automatically initiated.

Reveal answer details Close answer details

Correct answerB

Question 6

Single choice

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

Reveal answer details Close answer details

Correct answerC

Question 7

Multiple choice

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

A
RMAN
B
Logs
C
OCI Metrics
D
Performance Hub
E
Enterprise Manager Cloud Control

Reveal answer details Close answer details

Correct answersC, D, E

Question 8

Multiple choice

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

A
Exadata
B
Active Data Guard
C
RAC, but only when scaling beyond 16 OCPUs
D
Transparent Data Encryption
E
Multitenant

Reveal answer details Close answer details

Correct answersC, E

Explanation

Refer to
https://www.oracle.com/autonomous-database/autonomous-data-warehouse/pricing/

If you run Oracle Database EnterpriseEdition and the required options listed below, then your BYOL requirements are as follows: For 1-16 OCPUs of a single Oracle Autonomous Data Warehouse instance: For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate up to 2 OCPUs of the BYOL Cloud Service. For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate 1 OCPU of the BYOL Cloud Service. For 17 OCPUs or more of a single Oracle Autonomous Data Warehouse: For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate up to 2 OCPUs of the BYOL Cloud Service.
For every 25 supportedNamed User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate 1 OCPU of the BYOL Cloud Service.

https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html
"Docustomers need
Exadata licenses to benefit from BYOL?"

Question 9

Single choice

When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection?(Choose the best answer.)

A
DBNAME_MEDIUM
B
DBNAME_HIGH
C
DBNAME_CONCURRENT
D
DBNAME_LOW

Reveal answer details Close answer details

Correct answerD

Explanation

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-
80E464A7-8ED4-45BB-A7D6-E201DD4107B7

Question 10

Multiple choice

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

A
Number of OCPUs displayed in the console.
B
Amount of storage
C
I/O resources
D
parallelism settings
E
Level of concurrency

Reveal answer details Close answer details

Correct answersB, D, E

Explanation

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-scale.html#GUID-27FAB1C1-B09F-4A7A-9FB9-5CB8110F7141

Question 11

Multiple choice

Which two options are available to restore an Oracle Autonomous Database?

A
Select the backup from which restore needs to be done.
B
Specify the point in time (timestamp) to restore.
C
Select the snapshot of the backup.
D
Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.
E
Specify the archived custom image.

Reveal answer details Close answer details

Correct answersA, B

Question 12

Multiple choice

Which three are use cases for Graph Studio? (Choose three.)

A
3-D modelling
B
Churn analysis
C
Pattern matching
D
Facial recognition
E
Clustering

Reveal answer details Close answer details

Correct answersA, C, E

Explanation

Question 13

Multiple choice

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

A
DOC
B
AVRO
C
JSON
D
DDL
E
Dcsv
F
Parquet

Reveal answer details Close answer details

Correct answersB, C, E, F

Question 14

Single choice

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?

A
Business Models
B
Data Load
C
SQL Developer Web
D
APEX

Reveal answer details Close answer details

Correct answerB

Explanation

Question 15

Single choice

In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?

A
Oracle Machine Learning notebook
B
Compartment quotas
C
Resource Manager settings
D
SQL Developer Web Console

Reveal answer details Close answer details

Correct answerB

Explanation

https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm

Question 16

Single choice

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

A
The Autonomous Database must be in the same VCN and Subnet as the Compute instance.
B
The OCI compute instance does not support connecting to a Shared Autonomous Database.
C
The Autonomous Database must belong to a Network Security Group (NSG).
D
The OCI compute instance can be used with an Always-Free Autonomous Database account.
E
A Private Endpoint is required to connect to the Shared-Autonomous Database.

Reveal answer details Close answer details

Correct answerD

Question 17

Single choice

Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?

A
inside the Autonomous Database wallet
B
inside the backups of thecontainer database
C
In a separate key vault external to the Exadata Infrastructure
D
on the Exadata Infrastructure where Autonomous Database Dedicated is hosted

Reveal answer details Close answer details

Correct answerC

Free 1Z0-931-21 Exam Dumps Preview

Oracle Autonomous Database Cloud 2020 Specialist

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14

QUESTION 15

QUESTION 16

QUESTION 17

VOL	TYPE	QUESTIONS
1	Single choice	10
2	Multiple choice	7