Proper study guides for Regenerate Oracle Oracle Data Integrator 12c Essentials certified begins with Oracle 1Z0-448 preparation products which designed to deliver the 100% Guarantee 1Z0-448 questions by making you pass the 1Z0-448 test at your first time. Try the free 1Z0-448 demo right now.

2016 Dec 1Z0-448 real exam

Q1. You have been tasked with designing a Mapping that must perform an initial load and incremental updates using the same transformation logic. How should you proceed?(Choose the best answer.) 

A. Create a single Mapping with two Physical Designs: one for theinitialload and one for the incremental updates. 

B. Create a single Mapping with a single Physical Design and modify it appropriately when an initial load is required or when an incremental update is required. 

C. Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic. 

D. Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise. 

Answer:

Explanation: 

(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1614) 


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


Q3. In a Mapping, you want to load the data by using a specific partition that is declared for a target table. Which statement is correct in this situation?(Choose the best answer) 

A. It is not possible to use a specific partition. 

B. Only ODI variables can be used to filter the target table loading. 

C. An option in the Mapping can be used to declare partitions but an ODI variable must be used to evaluate the correct partition value. 

D. An option in the Mapping can be used to declare the partition that has to be used for the loading. 

Answer:

Explanation: 

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


Q4. You want to deploy the generated code manually in a source or target server, before executing a mapping in ODI. How can you accomplish this?(Choose the best answer.) 

A. You need not deploy the generated code manually in a source or target server. ODI Agent coordinates the execution of commands prepared for the job, and executes them on the correct server. 

B. You must deploy the generated code manually in a source or target server. You must then compile the generated code and then double-check if the code prepared for the development server is the same as the code for the production server. 

C. You need not deploy the generated code manually in a source or target server. ODI prepares a package for the development environment. 

D. You must deploy the generated code manually in a source or target server. You must copy all procedures generated into the development, test, and production servers. 

Answer:

Explanation: (https://docs.oracle.com/middleware/1212/odi/ODIDG/intro.htm#ODIDG149) 


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

Explanation: (http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-realtime-access-2031152.pdf) 


Up to date 1Z0-448 actual exam:

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


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


Q8. You need to deploy ODI JEE Components on WebLogic Server. Where should you deploy them?(Choose the best answer.) 

A. on the Coherence Server 

B. on the Administration Server 

C. on the Node Manager 

D. on the Managed Server 

Answer:

Explanation: (http://docs.oracle.com/cd/E25054_01/core.1111/e10106/odi.htm) 


Q9. As part of your QA process you want to view code at the Step level in Operator. How must you proceed?(Choose the best answer.) 

A. It is only possible to see code at the Session level. 

B. It is only possible to view code at the Task level. 

C. Depending on the audit level declared when running the execution, some of the generated code at the step level can be viewed. 

D. All generated code can be viewed together at the step level, with a complete list of executed code. 

Answer:

Explanation: 

(https://docs.oracle.com/middleware/1212/odi/ODIDG/debugging.htm#ODIDG1641) 


Q10. You want to draw directly in the data flow all the details about how the different servers involved are connected, in order to load a specific table by using ODI. 

What must you do to accomplish this?(Choose the best answer.) 

A. In the ODI Interface palette, choose the more convenient graphic objects to link the involved servers. 

B. You need not draw directly in the data flow all the details about how the different servers involved are connected. ODI automatically designs the flow and how servers are connected. 

C. You need not draw directly in the data flow all the details about how the different servers involved are connected. The code will be the black box generated directly by ODI. 

D. You must draw directly in the data flow all the details about how the different servers involved are connected, and also specify with variables the passwords for connecting to the data contained in the servers. 

Answer: