Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. Oracle
  3. Database Cloud Service
  4. 1z0-1094-22 - Oracle Cloud Database Migration and Integration 2022 Professional

Oracle 1z0-1094-22 Oracle Cloud Database Migration and Integration 2022 Professional Exam Practice Test

Demo: 13 questions
Total 90 questions
Get 1z0-1094-22 Full Access Download 1z0-1094-22 PDF

Oracle Cloud Database Migration and Integration 2022 Professional Questions and Answers

Question 1

Which four Oracle Database CloudServices are supported as a target database using Oracle Zero Downtime Migration?

(Choose all correct answers)

Options:

A.

Oracle Database Cloud Service

B.

oracle NOSQL Database Cloud Service

C.

Autonomous Database

D.

Oracle MySQL Database Cloud Service

E.

ExadataCloud at Customer

F.

Exadata Cloud Service

Question 2

Which TWO products/utilities does Oracle Zero Downtime Migration use as part of its migration workflows to Autonomous Database? (Choose all correct answers)

Options:

A.

Data Pump

B.

Data Guard

C.

GoldenGate

D.

Recovery Manager

Question 3

In case of migration using the RMAN DUPLICATE command, which file do you use to specify the location of the Database Wallet?

Options:

A.

TNSNAMES.ORA

B.

SQLNET.ORA

C.

WALLET.ORA

D.

LISTENER.ORA

Question 4

Which developer tool is web-based, function-rich, and resides in a low code development environment?

Options:

A.

APEX

B.

RMAN

C.

IMPEXPDP

D.

DATAPUMP

Question 5

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)

Options:

A.

name of the Oracle Instance (SID) or service

B.

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

C.

database link

D.

list of all schemas

E.

listing port of the oracle listener

Question 6

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)

Options:

A.

Jmx connections to be accepted frommultiple hosts

B.

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

C.

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

D.

ZDM_BASE group access enabled

Question 7

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

Options:

A.

TABLES_AS_VIEWS

B.

SUBSET_AS_TABLES

C.

VIEWS_AS_TABLES

D.

MATERIALIZED_VIEWS

Question 8

You have an on-premises non-TDE-encrypted Linux 19c container database (CDB) that is already being regularly backed up to Oracle Cloud Infrastructure (OCI) Object Storage via the Database Backup Cloud Service. You plan on using Recovery Manager (RMAN) to migrate it to Database Cloud Service. What is the valid strategy to migrate?

Options:

A.

Create a new OCI DB Service instance and use the “instantiatefrom backup” option in the console. This will automatically take care of the encryption.

B.

Create a new OCI DB Service instance, delete the existing database, and use the DBaa$ tooling to configure the DB Cloud Backup Module to point to the existing bucket, and then restore the backup by using the console.

C.

Create a new OCI DB Service Instance, copy the backup data from the bucket to the FRA, and then use the console to perform a DB restore.

D.

Create a new DB Service instance, delete the existing database, manually install the DB Cloud Backup Module pointing it to the backed where the on-premises backups are located, and perform a complted RMAN RESTORE AS encryption operation.

Question 9

You have executed the mappings with Change Data Capture ( CDC ) on the source data store and you are now going through the code in the operator log for debugging. Which two tables or view do you need to inspect in the database to see whether the CDC process is writing changed data or not in Oracle Data Integration ( ODI )? (Choose all correct answers)

Options:

A.

JV$D view

B.

J$ table

C.

JV$ view

D.

JW$ view

Question 10

Which migration method gives you the least downtime?

Options:

A.

Data Guard

B.

RMAN point-in-time recovery

C.

Transportable Tablespaces

D.

Data pump

Question 11

How much network latency is tolerated by the Remote Apply process of Oracle GoldenGate?

Options:

A.

8 ms

B.

16 ms

C.

4 ms

D.

6 ms

Question 12

Which Oracle Database Cloud Service takes care of all routine database tasks ensuring higher performance, reliability, security, and operational efficiency?

Options:

A.

Oracle Exadata

B.

Oracle 19c

C.

Oracle MySQL Cloud Service

D.

Oracle Autonomous Database

Question 13

Which THREE Fusion SaaS components from the Oracle Data Integrator (ODI) Loading Knowledge Modules can be used to extract data out of Fusion SaaS applications and load it into Autonomous Data Warehouse (ADW)?(Choose all correct answers)

Options:

A.

Enterprise Scheduler Service (ESS) SOAP API

B.

Universal Content Management

C.

BI Application Configuration Manager

D.

REST API

E.

Cloud Connector

Load More 1z0-1094-22 Questions
Demo: 13 questions
Total 90 questions
Get 1z0-1094-22 Full Access Download 1z0-1094-22 PDF