[Apr 15, 2022] Valid 1Z0-931-21 Test Answers & Oracle 1Z0-931-21 Exam PDF [Q49-Q68]

4/5 - (13 votes)

[Apr 15, 2022] Valid 1Z0-931-21 Test Answers & Oracle 1Z0-931-21 Exam PDF

Realistic 1Z0-931-21 Exam Dumps with Accurate & Updated Questions

NEW QUESTION 49
Which statement is FALSE for Oracle Data Safe? (Choose the best answer.)

Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations

Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user

Oracle Data Safe only supports Autonomous Databases

Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary

NEW QUESTION 50
During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator

the Client Credentials wallet which is used to connect to the Autonomous Database

the ‘High Availability Container Database’ in which the Autonomous instance should run

the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment

the Listener endpoint where the Autonomous Database should register on

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

NEW QUESTION 51
Which statement is correct about managing and monitoring of Autonomous Database?

You can use Service console to move Autonomous DB between compartments.

You can use Service console to create manual backups of Autonomous database.

You can use Service console to enable or disable auto scaling of Autonomous DB.

You can use Service console to manage runaway SQL statements on Autonomous DB.

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-sql-statements.html#GUID-4861BA7F-F9FA-4909-8DC0-4F46AFF80706

NEW QUESTION 52
Which stage of the indexing pipeline divides text into tokens?

SECTIONER

FILTER

Otokenizer

LEXER

NEW QUESTION 53
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?

Admin page of the Cloud Service Console

OCI CLI

OS command line from the database server.

SQLDeveloper

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

Autonomous Transaction Processing

Autonomous Data Warehouse

Neither service ignores hints by default

Both services ignore hints by default

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

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

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

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

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

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

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

Fleet Administrators create, monitor and manage Autonomous Databases.

NEW QUESTION 57
Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?

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

A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.

The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.

The marketplace OCI image can be used with an Always Free Autonomous Database account.

The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.

NEW QUESTION 58
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

Users have OS access to the database machine.

Users can customize the maintenance schedule.

It offers greater control and isolation starting at the Exadata cloud infrastructure level.

Users have SYS privileges in the database.

Users can customize the OS stack and add additional packages

NEW QUESTION 59
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

To provision an Autonomous Database with a private endpoint, you must have the following resources already created:
A VCN within the region that will contain your Autonomous Database with shared Exadata infrastructure. Cannot be changed after provisioning.
A private subnet within your VCN configured with default DHCP options. Cannot be changed after provisioning.
At least 1 network security group (NSG) within your VCN for the Autonomous Database. Can be changed or edited after provisioning.
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbsprivateaccess.htm

NEW QUESTION 60
When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?

Scan partition tables

scan hybrid partition tables

prun column in parquet files

prun columns in csv files

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

inside the Autonomous Database wallet

inside the backups of the container database

In a separate key vault external to the Exadata Infrastructure

on the Exadata Infrastructure where Autonomous Database Dedicated is hosted

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

Oracle Machine Learning notebook

Compartment quotas

Resource Manager settings

SQL Developer Web Console

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

NEW QUESTION 63
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?

Change the Automatic Maintenance Schedule to ‘None’d.

Change the Automatic Maintenance Schedule to ‘Specify a Schedule’ but do not select any month, week or day.

You cannot permanently disable scheduled Automatic Maintenance.

Change the Automatic Maintenance Schedule to ‘No Preference’.

“If the Autonomous Exadata Infrastructure resource doesn’t have a customized schedule, its maintenance schedule will be automatically modified so that it precedes the Autonomous Container Database schedule you define.”
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/change-maintenance-scheduleacd.html#GUID-CA028A37-5510-473E-B4D0-A5D454B8DA6E

NEW QUESTION 64
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

NEW QUESTION 65
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

Data

Schemas

Tablespaces

Reports

NEW QUESTION 66
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?

Business Models

Data Load

SQL Developer Web

APEX

NEW QUESTION 67
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

Autonomous Transaction Processing only

ATP and ADW

Autonomous Data Warehouse only

Hybrid Columnar compression

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

Select the backup from which restore needs to be done.

Specify the point in time (timestamp) to restore.

Select the snapshot of the backup.

Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.

Specify the archived custom image.

Loading …

Oracle 1Z0-931-21 Exam Syllabus Topics:

Topic	Details
Topic 1	Manage ADB Backups and Restores, Patching and upgrading Manage Autonomous Database instances: REST APIs, OCI CLI, moving resources
Topic 2	Incorporate Location-based analysis (Autonomous Spatial) Understand the Oracle Cloud Infrastructure
Topic 3	Describe the options and considerations for migrating to ADB Articulate the key features of Autonomous Database
Topic 4	Use Autonomous Database with Oracle Machine Learning, APEX and SQL Developer Web (Database actions) Use services in ADB: auto indexing, data safe, compartment quotas
Topic 5	Use Marketplace Developer image to connect to ADB, use ADW with third party tools Use Access Control Llist (ACL) and Private End Points