Oracle Cloud Database 2023 Migration and Integration Professional (1z0-1094-23) Free Practice Test

Question 1

When integrating data from multiple sources into a Data Warehouse schema, you want to check a length constraint that you have imposed on one of the target columns before the rows arrive in the target table. All the rows that do not pass this quality check will have to be isolated in error tables. For this, you have chosen an Integration Knowledge Module (IKM) that supports flow control. You have also chosen the value raue for this parameter to enable this check. At compile time, you see that Oracle Data Integrator (ODI) throws an error and the execution cannot start. What is the reason?

A. There were no rows compliant with imposed constraint.

B. The integration type was not set in the logical design.

C. The Check Knowledge Module was not set in the physical design.

D. Primary key was not defined on the target table.

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

Which type of Zero Downtime Migration (ZDM) can you use for Inflight Upgrade?

A. Both Physical and Logical Migration is supported.

B. Physical Migration only

C. ZDM does not support Inflight Upgrade.

D. Logical Migration only

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

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

A. 4 ms

B. 6 ms

C. 16 ms

D. 8 ms

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

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

A. Data Pump

B. Recovery Manager

C. GoldenGate

D. Data Guard

Correct Answer: A,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

In which two ways can you use SQLcl to load data or migrate a database into an Oracle Cloud Database? (Choose two.)

A. Log Analytics and Functions

B. Object Storage and the SQLcl LOAD command

C. Object Storage and SQLcl Data Pump Export/Import

D. Streaming Service and Alert Logs

Correct Answer: B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

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)

A. Target and source have same Endianness.

B. Source must be Little-endian.

C. Target must be an Autonomous database.

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

Correct Answer: A,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

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)

A. The Set ENCRYPTION IDENTIFIED BY command was executed.

B. The set DECRYPTION IDENTIFIED BY RMAN command was not executed.

C. SET ENCRYPTION ON

D. The Set ENCRYPTION IDENTIFIED BY only command was executed

E. He OCT Object Storage eye on at rest key is missing

Correct Answer: C,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

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

A. LOGTIME

B. FLASHBACK_TIME

C. PARALLEL

D. METRIC

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 9

Your source database version is 12c and your target database is ATP-D.
Which utility should you use to instantiate the target database?

A. SQL Developer Migration Wizard

B. Oracle Data Pump

C. Datafile Copy to Object Storage

D. Oracle RMAN Duplicate Database

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Cloud Database 2023 Migration and Integration Professional (1z0-1094-23) Free Practice Test