1Z0-448 Exam - Oracle Data Integrator 12c Essentials

Q1. 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. 

View Answer

Q2. How does the data flow when moving records between two servers by using Database Links and an Agent installed on a middle-tier server?(Choose the best answer.) 

A. from the source database into flat files that are then loaded into the target database 

B. directly from the source database to the target database 

C. from the source database onto the server running the Agent and then into the target database 

D. from the source database into the machine running ODI Studio and then into the target database 

View Answer

Q3. Which two objects can be dragged to a Mapping?(Choose two.) 

A. Variables 

B. Datastores 

C. Knowledge Modules D. Reusable Mappings 

View Answer

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. 

View Answer

Q5. Identify the ODI tool used to write content into a file in a package.(Choose the best answer.) 

A. OdiOutFile 

B. OdiFileCopy 

C. OdiFileMove 

D. OdiInFile 

View Answer

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

A. ERR$ 

B. ERROR$ 

C. ODI_ERR$ 

D. E$ 

View Answer

Q7. 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. 

View Answer

Q8. Which statement is correct about all expressions in a Mapping?(Choose the best answer.) 

A. It is possible to set the execution location on source, staging area, or target. 

B. All transformations are executed on the staging area. 

C. Only the source and target servers can be used to execute expressions. 

D. All expressions are executed on the source area. 

View Answer

Q9. 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. 

View Answer

Q10. If multiple changes occur on the source system but have not yet been processed by ODI, the J$ table contains entries for each change for the records sharing the same PK. 

What happens at run time when a Mapping gets executed?(Choose the best answer.) 

A. All distinct entries are processed. 

B. Only the latest entry is processed based on theJRN_DATEfield. 

C. Only the first entry is processed based on theJRN_DATEfield. 

D. A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table. 

View Answer