Q1. Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.)
A. extracting source data to flat files
B. triggers
C. Oracle GoldenGate
D. before-and-after database image comparison
Answer: B,C
Q2. You need to deploy ODI JEE Components on WebLogic Server. Where should you deploy them?(Choose the best answer.)
A. on the Coherence Server
B. on the Administration Server
C. on the Node Manager
D. on the Managed Server
Answer: D
Explanation: (http://docs.oracle.com/cd/E25054_01/core.1111/e10106/odi.htm)
Q3. Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)?(Choose two.)
A. It enables developers to execute most ODI operations through a Java program.
B. It can be used to embed ODI processes into another product.
C. It is used to load data between Teradata and Oracle.
D. It must be used by ETL developers to develop ODI processes.
Answer: A,D
Explanation: (https://foursconsultancy.wordpress.com/odi/oracle-data-integrator-12c-components/)
Q4. Which two objects can be dragged to a Mapping?(Choose two.)
A. Variables
B. Datastores
C. Knowledge Modules D. Reusable Mappings
Answer: B,D
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1560)
Q5. You want to ensure that thePhysical Mapping Design cannot be modifiedeven if the Logical Design of the Mapping is changed. What sequence of steps must you follow to achieve this?(Choosethe best answer)
A. Go to the Physical tab, select theFixedDesign check boxof the Physical Mapping Design.
B. Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design.
C. Go to the Physical tab, select the Read-only check box of the Physical Mapping Design.
D. Go to the Physical tab, deselect theModify check boxof the Physical Mapping Design.
Answer: C
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1560)
Q6. You need totroubleshoot the execution of a Mapping and visualize the data contained in the ODI Staging tableswhile the Mapping is being executed. How must you proceed?(Choose the best answer.)
A. Start a Mapping in Debug mode and use breakpoints and the Get Data featureto query the data contained in the Staging tables.
B. Modifya Knowledge Module to dump the Staging tables’ data into log files for review.
C. Use variables in a Package to query the Staging tablesand evaluate the variable values.
D. Reverse engineer the Staging tables in a Modeland review the data contained in it.
Answer: D
Explanation: (https://docs.oracle.com/middleware/1212/odi/ODIKD/rkm.htm#ODIKD909)
Q7. You are defining a data store in ODI metadata and want toadd a primary key even if it does not physically exist on the related database catalog.
How can you accomplish this?(Choose the best answer.)
A. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraintson the data store.
B. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints to the data store diagram.
C. You cannot add a primary key if it does not physically exist on the related database catalog. You can flag only non-null conditions to be checked.
D. You cannot add a primary key if it does not physically exist on therelated database catalog. You can reverse engineer only the existing constraints.
Answer: D
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIKM/teradata.htm#ODIKM1061)
Q8. You must ensure that your Mappings do not run into connectivity issues when moving data from server A to server B by using an AGT agent that is running on server B.
How must you test this by using ODI Studio running on machine C?(Choose the best answer.)
A. UseOdiPingAgentin a package to ping AGT agent.
B. In Topology, test the connections to servers A and B by using the AGT agent.
C. In Topology, test the connections to the AGT agent.
D. In Topology, test the connections to servers A and B by using Local (No Agent).
Answer: B
Explanation: (http://www.ateam-oracle.com/how-to-understand-and-diagnose-odi-connectivity-issues/) as per this link even choice A is right as its alternative/additional method for testing connectivity
Q9. In a Mapping, you want to load the data by using a specific partition that is declared for a target table. Which statement is correct in this situation?(Choose the best answer)
A. It is not possible to use a specific partition.
B. Only ODI variables can be used to filter the target table loading.
C. An option in the Mapping can be used to declare partitions but an ODI variable must be used to evaluate the correct partition value.
D. An option in the Mapping can be used to declare the partition that has to be used for the loading.
Answer: D
Explanation:
(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/interfaces.htm#ODIDG1044)
Q10. How do you reuse a configuration ofOdiSendMailacross multiple packages?(Choose the best answer.)
A. Add a sub-model to a package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.
B. Add anOdiSendMailstep to a knowledge module.
C. Duplicate theOdiSendMail stepinto multiple packages.
D. Create a procedure with a step that usesOdiSendMailand add this procedure into multiple packages.
Answer: D
Explanation: (https://blogs.perficient.com/oracle/2014/08/26/how-to-create-an-oracle-data-integrator-odi-package/)