we provide Printable Oracle 1Z0-448 exam prep which are the best for clearing 1Z0-448 test, and to get certified by Oracle Oracle Data Integrator 12c Essentials. The 1Z0-448 Questions & Answers covers all the knowledge points of the real 1Z0-448 exam. Crack your Oracle 1Z0-448 Exam with latest dumps, guaranteed!

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

Answer:

Explanation: 

(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/interfaces.htm#ODIDG1040) 


Q12. 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:


Q13. 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:

Explanation: 

(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG287) 


Q14. You want tooverride the code generated by ODI and provide a custom SQL statementas the source of a Mapping. How must you proceed?(Choose the best answer.) 

A. Duplicate theIntegration Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping. 

B. Duplicate the Check Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping. 

C. In the Physical tab of a Mapping, click one of the source data stores, select the Extract Options, and enter the SQL statement in theCUSTOM_TEMPLATEfield. 

D. Duplicate the Loading Knowledge module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping. 

Answer:

Explanation: 

(https://blogs.oracle.com/dataintegration/entry/sessionizing_data_with_match_recognize) 


Q15. 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:

Explanation: 

(https://blogs.oracle.com/dataintegration/entry/user_interface_and_terminology_changes1) 


Q16. You are working on notifications in a package and you must send an email containing an error message incase a Package step fails. 

WhichodiRefmethod do you use to access the error message?(Choose the best answer.) 

A. odiRef.getSession() 

B. odiRef.getInfo() 

C. odiRef.getPrevStepLog() 

D. odiRef.getStep() 

Answer:

Explanation: 

(https://docs.oracle.com/middleware/1212/odi/ODIKD/odiref_reference.htm#ODIKD1147) 


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

Answer:

Explanation: (https://community.oracle.com/thread/3780742?start=0&tstart=0) 


Q18. 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) 


Q19. You are defining a data store in ODI metadata and want toadd a primary key even if it does not physically exist on the related database catalog. 

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

A. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraintson the data store. 

B. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints to the data store diagram. 

C. You cannot add a primary key if it does not physically exist on the related database catalog. You can flag only non-null conditions to be checked. 

D. You cannot add a primary key if it does not physically exist on therelated database catalog. You can reverse engineer only the existing constraints. 

Answer:

Explanation: 

(https://docs.oracle.com/middleware/1212/odi/ODIKM/teradata.htm#ODIKM1061) 


Q20. 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/)