Cause all that matters here is passing the Oracle 1Z0-448 exam. Cause all that you need is a high score of 1Z0-448 Oracle Data Integrator 12c Essentials exam. The only one thing you need to do is downloading Exambible 1Z0-448 exam study guides now. We will not let you down with our money-back guarantee.

Q21. You are designing a load plan in which you must create multiple branches based on the value of a variable. How do you accomplish this by using Load Plan Editor?(Choose the best answer.) 

A. Add a case step and drag the variable into the case step. 

B. Create a scenario from the variable and add the scenario to the load plan to create a case step. 

C. Add a case step in the load plan and select a variable in the wizard. 

D. Drag the variable into the load plan and define a case step. 

Answer:

Explanation: 

(https://docs.oracle.com/middleware/1213/odi/develop/loadplans.htm#ODIDG1356) 


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

Explanation: (http://odiexperts.com/context-logical-and-physical-schema-how-does-it-work/) 


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


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


Q25. You create two mappings that both use the same changed data and run at different times. One runs every 15 minutes and the other runs once every day. 

What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping?(Choose the best answer.) 

A. Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change theJRN_SUBSCRIBERcolumn in the correspondingJ$table to keep the changed data present for the second Mapping. 

B. Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping. 

C. Duplicate the source data store for each Mapping. 

D. Create two distinct subscribers for each Mapping. 

Answer:

Explanation: (http://odiexperts.com/changed-data-capture-cdc/) 


Q26. You have to loop through a Mapping step three times in a package by using variables. Identify thecorrect variable data type to create the loop. (Choose the best answer.) 

A. numeric 

B. alphanumeric 

C. date 

D. text 

Answer:

Explanation: (https://www.packtpub.com/packtlib/book/Big-Data-and-Business-Intelligence/9781849681742/4/ch04lvl1sec31/Using%20variables%20to%20control%20loo ps%20inside%20packages) 


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

Explanation: (http://www.odigurus.com/2011/05/using-operator.html) 


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

Explanation: 

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


Q29. Which two statements are true about ODI web-based components?(Choose two.) 

A. ODI Console allows administrators to edit users’ information. 

B. Enterprise Manager Cloud Control provides access to ODI data servers’ settings. 

C. ODI sessions can be monitored in Enterprise Manager Cloud Control. 

D. ODI Console provides access to project and mapping details. 

Answer: A,D 

Explanation: (http://www.oracle.com/technetwork/middleware/data-integrator/overview/oracledi-architecture-1-129425.pdf) 


Q30. You must run the samemappingconcurrently while avoiding clashes of ODI temporaryobjects. How must you implement this?(Choose the best answer.) 

A. Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names. 

B. Use variables in the Logical Design of the Mapping to create unique temporary object names. 

C. Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names. 

D. Select the Use Unique Temporary Object Names check box at the Physical Design level. 

Answer:

Explanation: (https://blogs.oracle.com/dataintegration/entry/odi_12c_parallel_target_table)