100% Pass Guaranteed Free 1Z0-931-21 Exam Dumps Feb 14, 2023 [Q59-Q73]

4/5 - (5 votes)

100% Pass Guaranteed Free 1Z0-931-21 Exam Dumps Feb 14, 2023

Verified & Latest 1Z0-931-21 Dump Q&As with Correct Answers

Oracle 1Z0-931-21 Exam Syllabus Topics:

Topic	Details
Topic 1	Describe the options and considerations for migrating to ADB Articulate the key features of Autonomous Database
Topic 2	Configure Disaster Recovery (Data Guard) – both Shared and Dedicated Describe Autonomous Database architecture, integrations and license types
Topic 3	Developing on Autonomous Database Use ADB connectivity: Wallets, service handles
Topic 4	Monitor ADB performance and set up service notifications Managing and Maintaining Autonomous Database
Topic 5	Migrating to Autonomous Database Autonomous Database Technical Overview Manage maintenance scheduling (patching)
Topic 6	Manage ADB Backups and Restores, Patching and upgrading Manage Autonomous Database instances: REST APIs, OCI CLI, moving resources
Topic 7	Provision Dedicated ADB (ADB, Exadata, Container DB, VM Cluster for Cloud @ Customer) Autonomous Database Dedicated & Autonomous Database Cloud @ Customer

NO.59 Which three are Oracle-recommended best practices for Autonomous Database alarms?

Suppress alarms during investigations.

Create multiple alarm metrics.

Create a single alarm for each metric.

Select the correct alarm interval for your metric.

Routinely tune your alarms.

Use a single interval for all alarms.

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

Exadata

Active Data Guard

RAC, but only when scaling beyond 16 OCPUs

Transparent Data Encryption

Multitenant

Refer to https://www.oracle.com/autonomous-database/autonomous-data-warehouse/pricing/ If you run Oracle Database Enterprise Edition 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 supported Named 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 “Do customers need Exadata licenses to benefit from BYOL?”

NO.61 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?

db-workload

is-dedicated

db-type

license-model

https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html

NO.62 For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW’

Allow group ADB-Admins to manage autonomous-database in tenancy.

Allow group ADB-Admins to manage autonomous-database-family in tenancy.

Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘OLTP’

NO.63 Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?

Pluggable databases cannot be migrated to ADB using plug, unplug or clone.

Create a database link from source database to the ADB environment and clone the PDB.

Unplug to an xml file so database files and xml file can be uploaded to object storage.

Unplug into a pdb archive which can be uploaded to object storage.

Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.
In the current release you cannot use physical migration methods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.

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

Oracle GoldenGate

Transportable Tablespace

RMAN Restore

Oracle Data Pump

SQL*Loader

https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATPD
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-intro.html#GUID-5D2F70D8-4FA1-482C-BFB0-43441FB897F3

NO.65 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

NO.66 The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?

Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,

Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database

Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure

https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/components.html#GUID-
268B36E1-87D8-4649-A370-226E2AE3FC5C

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

SQLDEV_ADMIN.GRANT_SCHEMA

ORDS_ADMIN.ENABLE_SCHEMA

ORDS_ADMIN.GRANT_SCHEMA

ORDS_PRIV.ENABLE_SCHEMA

As an alternative, the ADMIN can provide Web Access for a user, REST enable a user, with SQL commands. As the ADMIN user run the following code:
BEGIN
ORDS_ADMIN.ENABLE_SCHEMA(
.
.
);
COMMIT;
END;
/
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/sql-developer-web.html#GUID-4B404CE3-C832-4089-B37A-ADE1036C7EEA

NO.68 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/

NO.69 When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

Data

Schemas

Tablespaces

Reports

NO.70 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.

NO.71 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