Q1. How are the ODI repositories upgraded?(Choose the best answer.) 

A. by using Opatch 

B. by using ODI Studio 

C. by using the import/export utilities 

D. by using Upgrade Assistant 

View Answer

Q2. You have been tasked with designing a Mapping that must perform an initial load and incremental updates using the same transformation logic. How should you proceed?(Choose the best answer.) 

A. Create a single Mapping with two Physical Designs: one for theinitialload and one for the incremental updates. 

B. Create a single Mapping with a single Physical Design and modify it appropriately when an initial load is required or when an incremental update is required. 

C. Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic. 

D. Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise. 

View Answer

Q3. What is the main benefit of using consistent set journalizing compared to simple journalizing?(Choose the best answer.) 

A. Consistent set journalizing runs faster than simple journalizing. 

B. Consistent set journalizing always uses Oracle GoldenGate. 

C. Consistent set journalizing treats each data store individually. 

D. Consistent set journalizing provides a guarantee of consistency of the captured changes. 

View Answer

Q4. As part of your QA process you want to view code at the Step level in Operator. How must you proceed?(Choose the best answer.) 

A. It is only possible to see code at the Session level. 

B. It is only possible to view code at the Task level. 

C. Depending on the audit level declared when running the execution, some of the generated code at the step level can be viewed. 

D. All generated code can be viewed together at the step level, with a complete list of executed code. 

View Answer

Q5. When Oracle Data Integrator (ODI) and Oracle GoldenGate are used together, which option represents the phases of an ELT process that Oracle GoldenGate performs?(Choose the best answer.) 

A. transform only 

B. load and transform 

C. extract and load 

D. extract and transform 

View Answer

Q6. How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.) 

A. The Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI. 

B. The Knowledge Module must be customized only for aggregation functions. 

C. The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic. 

D. The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum. 

View Answer

Q7. How do youprovide a timeout value for an exception step?(Choose the best answer.) 

A. by using a custom Groovy script 

B. by using a variable 

C. by using the Timeout filed 

D. by using a Timeout knowledge module 

View Answer