Free Oracle 1z0-1094-22 Exam Dumps Questions & Answers

Which type of checks is NOT supported by Oracle Data Integrator (ODI)?

• A.  business rule
• B.  conditions
• C.  references
• D.  mandatory attributes
• E.  keys

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

• A.  sa_aupiT_ADMIN
• B.  pams_cnoup_MacapM
• C.  pems_croup
• D.  ppms_cLoup_aDMIN

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.  sa_audit_admin
• B.  Dbms_cloud
• C.  Dbms_cloud_admin
• D.  Dbms_cloud_macadm

Which of these can be used to unload and load data via Data Pump? (Choose two.)

• A.  Backupset
• B.  Network mode (with database links)
• C.  Streamfile
• D.  Dumpfile

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.  Primary key was not defined on the target table.
• B.  The integration type was not set in the logical design.
• C.  There were no rows compliant with imposed constraint.
• D.  The Check Knowledge Module was not set in the physical design.