[Jun-2022] Oracle 1Z0-1094-21 Test Engine PDF - All Free Dumps from Exams4sures [Q31-Q50] : Best Free Exam Guide : http://free.exams4sures.com

NO.31 WI Autonomous Data Warehouse (ADW) package is leveraged by the Business Intelligence Cloud Connector (BICC) Loading Knowledge Modules, when using Oracle Data Integrator (ODI)?

ppms_cLoup_aDMIN

pams_cnoup_MacapM

pems_croup

sa_aupiT_ADMIN

NO.32 Which statements are true for Zero Downtime Migration? (Choose two.)

It is a complex process that requires you to raise an SR with Oracle Support.

It ensures zero data loss.

It is free.

It does not leverage Oracle MAA best practices.

NO.33 If unplug and plug was decided to be used as the tool for the migration to Oracle Cloud Infrastructure (OCD), which two constraints are part of this migration to process for using unplug and plug? (Choose all correct answers)

Target must be an Autonomous database.

Target and source have same Endianness.

Source must be Little-endian.

Source and target need to be container database (CDB).

NO.34 Which entry in a Data Pump parameter file ensures consistent export using Data Pump migration to Autonomous Database?

PARALLEL

LOGTIME

METRIC

FLASHBACK_TIME

NO.35 Which TWO statements are true about online pluggable database (PDB) relocation? (Choose all correct answers)

Database version downgrade can be achieved with PDB relocation.

A PDB with the ASCII character set can be relocated to a container database (CDB) with the AL32UTF8 character set.

PDB relocation with no version change can be performed with near-zero downtime.

Online PDB relocation can achieve a zero downtime upgrade.

NO.36 Which port number do all the OCI GoldenGate Microservices environments use for port forwarding through NGINX?

1521

1680

443

NO.37 Which TWO provisions are required for Oracle Zero Downtime Migration (ZDM) to perform a database migration successfully with the physical workflow? (Choose all correct answers)

Jmx connections to be accepted from multiple hosts

Root user or SSH key-based access to target database server

Root user or SSH key-based access to source database server

ZDM_BASE group access enabled

NO.38 Which three tasks can be executed when you submit a data integration job to an Oracle Data Integrator (ODI) agent? (Choose all correct answers)

an operation on a model, sub model, or a data store, such as a customized reverse-engineering or a journalizing operation

the execution of a runtime scenario or a Load plan that was launched from the Oracle Data Integrator Studio, from a command line, via a schedule or a web service interface

setting up an FTP server as a staging location for extracted data

the execution of a design-time object, such as a mapping, a package or a procedure backing up data warehouse destination objects before loading the transformed data

NO.39 You have a requirement to join data from an Oracle database table and a flat file and load into target DB2 table, using Oracle Data Integrator (ODI). Which statement is correct about this?

Heterogeneous sources and targets are possible in a single mapping only if there is no incremental data load.

Flat file data has to have a header row in order to join with Oracle database table in a single mapping

It is not possible to join data from different source connection types in a Single mapping

It is possible to mix heterogeneous source connection type and load into any supported target connection type in a single mapping.

It is possible to join data from different source connection types in mapping, but the result must be loaded to Oracle.

NO.40 You are migrating a non TDE encrypted on-premises Database to an OCT Database Service Instance ising RMAN. You set up the DB Cloud Backup Module, but when executing the RMAN command to create your Cloud Backup you see the following error: AANA RMAN-03009: failure of backup command on ORA_SBT_TAPE 1 channel at: 08/18/2014 11: ORA-19914: unable to encrypt backup ORA~29361 mastor key not yet set What are the TWO causes of this error? (Choose all correct answers)

The Set ENCRYPTION IDENTIFIED BY command was executed.

SET ENCRYPTION ON

The Set ENCRYPTION IDENTIFIED BY only command was executed

He OCT Object Storage eye on at rest key is missing

The set DECRYPTION IDENTIFIED BY RMAN command was not executed.

NO.41 You need to migrate your on-premises 12c Non CDB to Cloud 12c. Which migration methods can you use?
(Choose two.)

Conventional Data Pump Export and Import

Transportable Databases

Transportable Tablespaces

Conventional RMAN Backup and Recovery

NO.42 Your source tables are in an on-premises Oracle Database. You are creating a data server in Oracle Data Integrator (ODI) topology. Which THREE configuration items are needed to successfully test an on-premises Oracle Database connection ? (Choose 3 all correct answers)

name of the Oracle Instance (SID) or service

network name or IP address of the machine hosting the Oracle Database

database link

list of all schemas

listing port of the oracle listener

NO.43 Which four Oracle database version are supported for source databases when migrating with Oracle Zero Downtime Migration? (Choose all correct answers)

Oracle Database 11g Release 2 ( 11.2.0.3 )

Oracle Database 10 g Release 2

Oracle Database 12c Release 2 ( 12.2.0.1 )

Oracle Database 11g Release 2 ( 11.2.0.4 )

Oracle Database 19

Oracle Database 12c Release 1 ( 12.1.0.2)

NO.44 Which three backup mediums are supported when migrating a database with oracle zero downtime migration?.
(Choose all correct answers)

Oracle Cloud Infrastructure Object Storage

Third-Party Cloud Storage

Oracle Zero data loss recovery appliance

NFS Storage

Tape Storage

NO.45 You are using Data Pump to migrate your database to Autonomous Database (ADB). To which tablespace must you remap your source database tablespaces?

USERS

UNDO

SYSTEM

DATA

NO.46 Which TWO options are valid when using the unplug/plug a PDB method to migrate? (Choose all correct answers)

Non-CDB databases can be consolidated and migrated.

Source database versions are 12c or later.

Target database versions must be 18c or later.

Use this technique to do a cross-endian conversion

NO.47 You are looking at migrating a large data centre to the Oracle Cloud while trying to consolidate many Oracle Databases at the same time. Which Oracle Data Management Service helps you achieve this?

oracle Exadata Cloud Service

oracle Data Safe

oracle MySQL Cloud Service

oracle Autonomous Database

NO.48 For a source database to be successfully migrated, you must view and apply the prerequisites. Which TWO prerequisites must pass before the source database can be migrated using Oracle Zero Downtime Migration (ZDM)? (Choose all correct answers)

The database must be stored in an Automatic Storage Management Cluster File System (ACFS).

Archivelog must be enabled

The database must have a configured TDE wallet if the version is Oracle Database 11g Release 2 or 12c Release 1.

The database must have Transparent Data Encryption (TDE) enabled.

Port 22 on the source database server must allow incoming connections from the ZDM service host.

NO.49 Which TWO object types should be excluded from an Autonomous Transaction Processing database? (Choose all correct answers)

SCHEMA

DB -LINK

constraint

cluster

NO.50 When building out your private subnet, you realize you need a host within your network in order to get access to the rest of your Oracle Cloud Infrastructure instances. Which type of host should you set up to get around this constraint?

Encrypted host

Private host

Baston host

Isolation host

[Jun-2022] Oracle 1Z0-1094-21 Test Engine PDF - All Free Dumps from Exams4sures [Q31-Q50]

Oracle 1Z0-1094-21 Exam Syllabus Topics: