Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. You are designing a load plan in which you must run Mappings A and B one after the other while running Mapping C at the same time. Which option represents the steps to accomplish this?(Choose the best answer.)
A. Add a parallel step, add three serial steps underneath it, then addAto the first parallel step, B to the second one, and C to the last one.
B. Create a scenario from the variable and add the scenario to the load plan to create a case step.
C. Add a parallel step, add two parallel steps underneath it, then add A and B tooneparallel step, and C to the other.
D. Add a parallel step, add two serial steps underneath it, then add A and B to one serial step, and C to the other.
Answer: C
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1356)
Q2. Identify two correct Restart values for parallel steps in load plans.(Choose two.)
A. Restart from new session.
B. Restart from failure.
C. Restart from failed children.
D. Restart all children.
Answer: C,D
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1409)
Q3. Which statement is true about theIKM SQL Control Append thatcreates an intermediate integration table prefixed with I$?(Choose the best answer.)
A. Theintermediate integration table prefixed with I$is required to determine which records must be inserted.
B. IfFlow Control is not necessary, an I$ table is not created.
C. Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.
D. Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.
Answer: D
Explanation: (http://www.oracle.com/us/products/middleware/data-integration/odi-performance-guide-wp-2147067.pdf)
Q4. Your project requires a loop through the same package logic 24/7. You must be able to purge those executions when required. How do you accomplish this?(Choose the best answer.)
A. Link the last step of the package to its first step to create an infinite loop.
B. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save and regenerate this scenario.
C. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save.
D. Drag the package to the last step in the package, run it asynchronously, and then save.
Answer: B
Explanation: (http://www.rittmanmead.com/2015/04/di-tips-odi-convert-to-flow/)
Q5. 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
Answer: A
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/app_tools.htm#ODIDG967)
Q6. The source and target data stores are located on the same data server. Which statement is correct about the need for a Loading KnowledgeModule to load the data on the target?(Choose the best answer.)
A. Only an Integration KnowledgeModule single-technology is required.
B. Only an Integration Knowledge Module multitechnology is required.
C. Aloading Knowledge Module multitechnology and an IntegrationKnowledgeModule single-technology are required.
D. Both a Loading Knowledge Module multitechnology and an Integration Knowledge Module multitechnology are required.
Answer: C
Explanation:
(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/interfaces.htm#ODIDG1059)
Q7. Youdesign a package with mappings that consume data from journalized data stores in Consistent Set CDC mode. Which option represents the steps that must be performed at the beginning of your package to accomplish this?(Choose the best answer.)
A. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Extend Window and Lock Subscriber check boxes.
B. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Unlock Subscriber and Purge Journal check boxes.
C. Add a model to the package, set the Model step to Journalizing Model, and select the Extend Window and Lock Subscriber check boxes.
D. Add a sub model to the package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.
Answer: C
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG287)
Q8. A. Add a new subscriber and edit the default Journalizing filter in your Mappings.
B. Drop the journal, add a new subscriber, start the journal, and edit the defaultJournalizing filter in your Mappings.
C. Drop the journal, remove existing subscribers, add a new subscriber, start the journal, and edit the default Journalizing filter in your Mappings.
D. Add a new subscriber, start the journal, and remove the default Journalizing filter in your Mappings.
Answer: B
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG285)
Q9. Identify two benefits that are unique toODI JEE Agents. (Choose two.)
A. high availability
B. minimal footprint
C. access to WebLogic connection pools
D. management in Enterprise Manager Cloud Control
Answer: A,D
Explanation: (http://www.ateam-oracle.com/odi-agents-standalone-jee-and-colocated/)
Q10. What must you set on the Definition tab of a variable to protect the variable value from being displayed in the Operator logs?(Choose the best answer.)
A. Select the Secure Value check box.
B. Select the Hide Value check box.
C. Set the Keep History field to No History.
D. Leave the Default Value field empty.
Answer: C
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/procedures.htm#ODIDG464)
Q11. Which statement is true about defining more than one physical schema associated to the same data server?(Choose the best answer.)
A. ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.
B. It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.
C. It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.
D. It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.
Answer: C
Explanation: (http://odiexperts.com/context-logical-and-physical-schema-how-does-it-work/)
Q12. 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
Answer: A
Explanation: (http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-realtime-access-2031152.pdf)
Q13. Which statement is correct about choosing the join order in an ODI Mapping when defining a join?(Choose the best answer.)
A. This option is inherited from reverse engineering.
B. This option is always available.
C. You can never make this choice.
D. This option may be available only if the underlying technology supports it.
Answer: B
Explanation:
(https://blogs.oracle.com/dataintegration/entry/user_interface_and_terminology_changes1)
Q14. 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.
Answer: D
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG272)
Q15. 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
Answer: A
Explanation: (http://odibeginnertutorials.blogspot.in/2013/12/odi-12c-installation-and-odi-12c.html)