Free 1Z0-931-22 Exam Dumps PDF Preview

Question 1

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 2

Single choice

Which is a difference between Autonomous Data Warehouse (ADW) andAutonomous Transaction Processing (ATP) databases?

A
Only ATP manages optimizer statistics.
B
Only ATP supports automatic backups.
C
Only ADW uses columnar compression by default.
D
Only ADW supports autoscaling.

Reveal answer details Close answer details

Correct answerC

Question 3

Single choice

Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

A
TPPERFORMANT
B
MEDIUM
C
HIGH
D
LOW
E
TPURGENT

Reveal answer details Close answer details

Correct answerA

Explanation

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

Question 4

Multiple choice

Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?

A
Oracle Cloud Infrastructure Object Storage Classic
B
Oracle Cloud Infrastructure Object Storage
C
Google Cloud Storage
D
Amazon S3
E
Azure Blob Storage

Reveal answer details Close answer details

Correct answersA, B

Question 5

Single choice

Which two methods canyou use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure A. service console

A
SQL Developer
B
the DBMS_CLOUD_ADMIN package
C
SQL *Plus

Reveal answer details Close answer details

Correct answerB

Question 6

Single choice

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

A
Under Core Infrastructure then Compute then Autonomous Exadata
B
Under Solutionsand Platform then Platform Services then Autonomous Exadata
C
Under Database then Autonomous Transaction Processing then Autonomous Exadata
D
Under Core Infrastructure then Autonomous Exadata

Reveal answer details Close answer details

Correct answerC

Explanation

https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory.

Even though the UI has changed recently, this documentation has the user go to Menu-> Database

Question 7

Multiple choice

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

A
RMAN Cross-Platform backup and restore
B
Golden Gate on-premise installation
C
PDB unplug / plug operation
D
Datapump export / import
E
Dataguard Physical Standby
F
Golden Gate Cloud service

Reveal answer details Close answer details

Correct answersB, D, F

Explanation

https://k21academy.com/1z0-931/migrate-database-to-oracle-autonomous-database-cloud-optionsdata-pump-sql-loader-dbms_cloud-goldengate/

Question 8

Single choice

What happened with the standby database when disabling Autonomous Data Guard?

A
The standby database is started readwrite
B
The standby database is transformed in a refreshable clone
C
The standby database is terminated
D
Thestandby database is started read only

Reveal answer details Close answer details

Correct answerC

Question 9

Single choice

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

A
120
B
60
C
15
D
7

Reveal answer details Close answer details

Correct answerA

Explanation

Backup Retention
If you choose to enable automatic backups, you can choose one of the following preset retention periods: 7 days, 15 days, 30 days, 45 days, or 60 days. The system automatically deletes your incremental backups at the end of your chosen retention period.

https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/backingupOS.htm

Question 10

Single choice

Which can be Scaled Independently of the number of CPUs In an Autonomous Database?

A
Parallelism
B
Storage
C
Concurency
D
Memory
E
Sessions

Reveal answer details Close answer details

Correct answerB

Explanation

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846
Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:

Question 11

Single choice

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

A
On the Autonomous Database Console.
B
SSH keys are not required in Oracle Cloud Infrastructure.
C
SSH keyscannot be added from console. They have to be added using REST APIs only.
D
Navigate to Identity, select Users panel on the console and select "Add Public Key".

Reveal answer details Close answer details

Correct answerD

Explanation

- In the Console, click Identity, and then click Users. Locate the user in the list, and then click the user's name to view the details.
- Click Add Public Key.
- Paste the key's value into the window and click Add.

Question 12

Multiple choice

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

A
optimized data archive using partitioned external tables
B
optimized data archive using hybrid partitioned tables
C
scan avoidance using block skipping when reading parquet and ore files
D
scan avoidance using columnar pruning for columnar stores like parquet and orc
E
scan avoidance using partitioned external tables
F
scan avoidance using columnar pruning for .csv files

Reveal answer details Close answer details

Correct answersA, B, D, E

Question 13

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 14

Single choice

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.

Reveal answer details Close answer details

Correct answerA

Explanation

https://www.oracle.com/database/technologies/security/data-safe.html
https://www.oracle.com/a/tech/docs/dbsec/data-safe/faq-security-data-safe.pdf

Data Safe works with the following Oracle Databases Oracle on-Premises Databases Oracle Cloud Databases Autonomous Database on Shared Exadata Infrastructure Autonomous Database on Dedicated Exadata Infrastructure Exadata DB systems Database Cloud Service on Virtual Machine Database Cloud Service on Bare Metal Oracle Database on Compute

Question 15

Multiple choice

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

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).

Reveal answer details Close answer details

Correct answersA, E

Explanation

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1

Question 16

Single choice

Which statement is NOT correct when setting up compartment quotas?

A
There are three types of quota policy statements which are set, unset and zero.
B
Compartment quotas use policies that allow allocation of resources with ahigh level of flexibility.
C
Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
D
Compartment quotas are set by Oracle.

Reveal answer details Close answer details

Correct answerD

Explanation

https://docs.oracle.com/en-us/iaas/Content/General/Concepts/resourcequotas.htm

Question 17

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

Free 1Z0-931-22 Exam Dumps Preview

Oracle Autonomous Database Cloud 2022 Professional

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	12
2	Multiple choice	5