1Z0-1094-22 Online Practice Questions and Answers

When integrating data from multiple sourcesinto 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. Primary key was not defined on the target table.

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

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

D. There were no rows compliant with imposed constraint.

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

A. Dbms_cloud_admin

B. Dbms_cloud

C. sa_audit_admin

D. Dbms_cloud_macadm

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

A. 8 ms

B. 16 ms

C. 4 ms

D. 6 ms

Which two migration methodologies can you use for migrating on-premises databases to Autonomous Database with Oracle Zero Downtime Migration (ZDM)? (Choose all correct answers)

A. Physical Online

B. Logical online

C. Physical Offline

D. Logical offline

In which mode must the auxiliary instance be started while using the RMAN DUPLICATE command for database migration?

A. NOMOUNT

B. OPEN

C. FORCE

D. MOUNT

In Oracle Zero Downtime Migration, the migrate database command provides several options to ensure a successful Oracle source and target data migration. Which FOUR are valid parameters to use with migrate database? (Choose all correct answers)

A. "-tgtroot"

B. "-tdemasterkey"

C. "-sourceid"

D. "-dbversion"

E. "-dbpatchievel"

F. "-sourcedb"

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

A. Transparent Data Encryption (TDE) must be enabled.

B. The database can be created only after migration has begun.

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

D. The TDE wallet status must be open.

E. The TDE wallet status must be closed.

When selecting a migration method for movingyour database to the cloud, what would you NOT take into consideration?

A. Database Version

B. High Availability

C. Schema Name

D. Database Size

Planning a database migration to Oracle Cloud Infrastructure (OCI) requires understanding the source?

A. users and groups to be migrated

B. on-premises host operating system

C. character set of databases

D. number of tables

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?

A. Encrypted host

B. Private host

C. Baston host

D. Isolation host