1Z0-448 | 10 Tips For Up to date 1Z0-448 exam question
Q21. 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/)
Q22. You are a project developer using ODI and want to consolidate your own local metadata repositories. Identify the true statement.(Choose the best answer.)
A. You must consolidate your own local metadata repositories. The local metadata must be transmitted via ftp and synchronized with a dedicated proprietary engine, creating a common metadata model for all the developers.
B. You must consolidate your own local metadata repositories. You have to invoke a dedicated web service to synchronize the metadata by using Oracle Service Bus.
C. You need not consolidate your own local metadata repositories, because the ODI proprietary metadata server allows all developers to share the common metadata of a specific project.
D. You need not consolidate yourown local metadata repositories, because ODI uses a
centralized relational metadata repository that all the developers share.
Answer: D
Q23. Identify the correct variable step type to use when assigning a value to a variable with an SQL query.(Choose the best answer.)
A. Evaluate Variable
B. Set Variable
C. Declare Variable
D. Refresh Variable
Answer: B
Q24. 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)
Q25. 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)
Q26. You want to modify the code generated by a failed Task and restart the session. How must you proceed?(Choose the best answer.)
A. Open the Task in Operator, go to Code, click Edit, use Pre-execution Code to edit the code, and save it.
B. It is not possible to modify the code once it has been generated.
C. Open the Step in Operator, edit the code, and save it.
D. Open the Task in Operator, go to Code, click Query/Execution Plan to edit the code, and save it.
Answer: D
Explanation: (http://www.odigurus.com/2011/05/using-operator.html)
Q27. Identify two correct exception behavior values for Run Scenario steps in load plans.(Choose two.)
A. Run Exception and Restart
B. Run Exception and Continue
C. Run Exception and Ignore
D. Run Exception and Fail
E. Run Exception and Raise
Answer: C,E
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1350)
Q28. 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
Q29. You must send the same message in multiple packages to several email addresses stored in the same database table. How do you accomplish this by using a reusable package step?(Choose the best answer.)
A. Create a procedure and add two tasks. The first one must have a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and the second must have a Command on Target that usesOdiSendMailto send the email by using the bind variable defined in the first task.
B. Createa Knowledge Module. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Command on Target that usesOdiSendMailto send the email using the bind variable defined in the Command on Source.
C. Create a counter variable that gets the total number of email addresses stored in the database table. Next, create another variable that selects the email addresses from the database table. Then, create a loop in the packages by using the variables and anOdiSendMailstep.
D. Create a procedure. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Commandon Targetthat usesOdiSendMailto send the email using the bind variable defined in the Command on Source.
Answer: B
Explanation:
(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/procedures.htm#ODIDG408)
Q30. 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)