1z0-1094-22 Updated Exam Dumps [2022] Practice Valid Exam Dumps Question [Q21-Q35]

Topic	Details
Topic 1	Analyze architecture components for transferring data from On-premises Database to Oracle Cloud DB Describe Oracle Data Management Services
Topic 2	Migrate an Oracle Database to OCI by using Oracle Database Cloud Backup Service Describe when to use Data Pump to migrate to Autonomous Database (ADB)
Topic 3	Analyze and choose a Migration Strategy (Source Database and Environments, Linux non-linux, CDB, non-CDB) Describe Oracle Data Management and Integration
Topic 4	Migrating to Cloud Database Services using Oracle Zero Downtime Migration (ZDM) Use Recovery Manager (RMAN) to migrate to OCI
Topic 5	Implement data integration mapping for data quality checks as part of data flow Migragting to Cloud Database Services using SQL Devoper, Cloud Backup, and GoldenGate
Topic 6	Implement change data capture (CDC) and leverage GoldenGate for real-time feed Migrate Oracle Databases on 3rd party clouds (moving from 3rd party clouds)
Topic 7	Manage the Database Migration Workflow (ZDM Commands and Options, Migration with Oracle ZDM, Troubleshooting, Common Issues) Analyze migration evaluation considerations
Topic 8	Describe when to use Data Pump to migrate to Oracle Database to Oracle Cloud Infrastructrure (OCI) Explain ETL vs ELT architecture of data integration
Topic 9	Migrating to Cloud Database Services using RMAN, Data Pump and Cloning Explain Migration Use Cases and Solutions
Topic 10	Describe when to use Unplug Plug, Remote Cloning and Relocation of PDBs to migrate to OCI Explain Sounce database and Target Options in OCI

QUESTION 21
Which source database versions are supported for OCI Database Migration? (Choose two.) (Choose all correct answers)

Oracle Database 19c

Oracle Database 10g R2

Oracle Database 11g

Oracle Database 10g R1

QUESTION 22
Which statements are true about Data Pump? (Choose two.)

Both the source and target database must be of the same version

It supports cross-platform migration

A best practice is to invoke Data Pump using SYS as SYSDBA

It supports cross-endian formats

QUESTION 23
Which are THREE target database prerequisites for database cloud migration with Oracle Zero Downtime Migration? (Choose all correct answers)

The TDE wallet status must be closed.

The database can be created only after migration has begun.

The database db_name should be the same as the source database.

Transparent Data Encryption (TDE) must be enabled.

The TDE wallet status must be open.

QUESTION 24
Which are TWO benefits of Extract-Load-Transform (ELT) over traditional Extract-Transform-Load (ETL) architectures? (Choose all correct answers)

ELT architecture reduces the amount of network traffic over traditional ETL tools, which use a dedicated server.

ELT architecture can easily become a bottleneck by placing excessive loads on the target servers.

Traditional ETL tools use a dedicated server, which provides better performance as it can be sized to any workload.

ELT architecture does not require dedicated hardware and leverages native data management engines, such as Big Data and RDBMs.

QUESTION 25
What are the constraints of using transportable tablespaces? (Choose two.)

The source and target platforms must match.

The source and target character sets must match.

The source and target database versions must match.

The source and target time zone versions must match.

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

Conventional RMAN Backup and Recovery

Transportable Tablespaces

Conventional Data Pump Export and Import

Transportable Databases

QUESTION 27
Which parameter can be used to export a subset of data using Data Pump?

TABLES_AS_VIEWS

MATERIALIZED_VIEWS

SUBSET_AS_TABLES

VIEWS_AS_TABLES

QUESTION 28
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

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

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.

QUESTION 29
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 MySQL Cloud Service

oracle Autonomous Database

oracle Exadata Cloud Service

oracle Data Safe

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

Target database versions must be 18c or later.

Non-CDB databases can be consolidated and migrated.

Source database versions are 12c or later.

Use this technique to do a cross-endian conversion

QUESTION 31
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

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

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

QUESTION 32
Which TWO methods are supported by Oracle Zero Downtime Migration (ZDM) for migrating onpremises databases to Autonomous Database? (Choose all correct answers)

Logical online or offline migration using OCI Object Storage

Physical online or offline migration using a database link

Logical online or offline migration using a database link

Physical online or offline migration using OCI Object Storage

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

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

Target and source have same Endianness.

Source must be Little-endian.

QUESTION 34
Which process does Oracle Data Integrator Enterprise Edition use to process and transform data for disparate relational database management systems or Big Data Engines?

SOA

ELT

ETL

DML

QUESTION 35
You are using Oracle Data Integrator (ODI). Which three topology elements are required to extract data out of Fusion SaaS applications and load it into Autonomous Data Warehouse (ADW)? (Choose all correct answers)

File

In-Memory Engine

Object Storage

BI Cloud Connector

Oracle (ADW)