Q1. Which is the correct statement about the contents of Master repositories?(Choose the best answer.) 

A. They contain data model and security information. 

B. They contain security and topology information. 

C. They contain project and topology information. 

D. They contain project and security information. 

View Answer

Q2. Which tables created by ODI contain error records?(Choose the best answer.) 

A. ERR$ 

B. ERROR$ 

C. ODI_ERR$ 

D. E$ 

View Answer

Q3. Updates have been made to Mappings in a package. What must you do to ensure that the Production team runs a scenario that contains those updates while preserving the existing scenario’s schedule?(Choose the best answer.) 

A. Regenerate the existing scenario. 

B. Nothing, the existing scenario will automaticallybe updated. 

C. Generate a new scenario and create a new schedule. 

D. Generate a new scenario and attach the previous scenario’s schedule to it. 

View Answer

Q4. Your customer wants a project in ODI, which contains a user function, to translate commands with different syntax for different technologies but with the same functionality. 

How can you achieve this?(Choose the best answer.) 

A. The project must be explicitly mapped within an ODI mapping. 

B. A customize knowledge module is needed. 

C. An ODI procedure must be associated with it. 

D. It can be defined for every technology listed in the topology. 

View Answer

Q5. How are the domains of ODI Agents configured?(Choose the best answer.) 

A. by using Upgrade Assistant 

B. by using ODI Studio 

C. by using Domain Creation Assistant 

D. by using Configuration Wizard 

View Answer

Q6. How should you define the Work Schema of a Physical Schema?(Choose the best answer.) 

A. Use a dedicated schema such asODI_STAGING. 

B. UseTEMP. 

C. Use the same schema as the Data Schema. 

D. Use SYSTEM. 

View Answer

Q7. You must monitor and managea co-located stand-alone agent,OracleDIAgent1, by using the ODI plug-in for Enterprise Manager CloudControl. Which is the correct command to start this agent on Linux?(Choose the best answer.) 

A. ./agent.sh –NAME=OracleDIAgent1 –PORT=20910 

B. ./agent.sh –NAME=OracleDIAgent1 

C. ./startComponent.sh OracleDIAgent1 

D. ./startComponent.sh OracleDIAgent1 –PORT=20910 

View Answer

Q8. The workflow you are designing requires checking to see whether there are records available in a source table before doing anything. Which ODI tool must you use to implement this?(Choose the best answer.) 

A. OdiWaitForData 

B. OdiWaitForCDCData 

C. OdiWaitForLogData 

D. OdiWaitForTable 

View Answer

Q9. You are designing a package in which you want a certain step to not appear in the ODI logs. How do you accomplish this?(Choose the best answer.) 

A. Right-click the step in Package Editor and select the No Logging menu item. 

B. Modify Operator Navigator settings to disable that step from being displayed. 

C. In Package Editor, click the step, go to the Advanced tab, and set Log Steps in the journal to Never. 

D. Periodically schedule a scenario that usesOdiPurgeLogto remove that step from the ODI logs. 

View Answer

Q10. You must run the samemappingconcurrently while avoiding clashes of ODI temporaryobjects. How must you implement this?(Choose the best answer.) 

A. Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names. 

B. Use variables in the Logical Design of the Mapping to create unique temporary object names. 

C. Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names. 

D. Select the Use Unique Temporary Object Names check box at the Physical Design level. 

View Answer