Exam Code: 1Z0-448 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Data Integrator 12c Essentials
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-448 Exam.

2017 Feb 1Z0-448 exam topics

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


Q32. You want to ensure that thePhysical Mapping Design cannot be modifiedeven if the Logical Design of the Mapping is changed. What sequence of steps must you follow to achieve this?(Choosethe best answer) 

A. Go to the Physical tab, select theFixedDesign check boxof the Physical Mapping Design. 

B. Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design. 

C. Go to the Physical tab, select the Read-only check box of the Physical Mapping Design. 

D. Go to the Physical tab, deselect theModify check boxof the Physical Mapping Design. 

Answer:

Explanation: 

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


Q33. A. Add a new subscriber and edit the default Journalizing filter in your Mappings. 

B. Drop the journal, add a new subscriber, start the journal, and edit the defaultJournalizing filter in your Mappings. 

C. Drop the journal, remove existing subscribers, add a new subscriber, start the journal, and edit the default Journalizing filter in your Mappings. 

D. Add a new subscriber, start the journal, and remove the default Journalizing filter in your Mappings. 

Answer:

Explanation: 

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


Q34. Your package logic requires you to retrieve the status of the previous package step into a variable. How must you implement this?(Choose the best answer.) 

A. Create a variable, useodiRef.getPrevStepLog ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package. 

B. Create a variable, useodiRef.getPrevInfo ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package. 

C. Create a variable, useodiRef.getStep ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package. 

D. Create a variable, useodiRef.getPrevStepStatus ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package. 

Answer:

Explanation: 

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


Q35. Identify the name of the default WebLogic data source created for the Master Repository when setting up a JEE domain.(Choose the best answer.) 

A. odiMasterRepository 

B. MasterRepository 

C. odimasterrepository 

D. ODIMasterRepository 

Answer:

Explanation: 

(https://docs.oracle.com/cd/E23943_01/install.1111/e16453/configure.htm#ODING303) 


Rebirth 1Z0-448 exam topics:

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


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


Q38. You are designing a Mapping. How are target and source tables defined?(Choose the best answer.) 

A. Their definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database. 

B. Their definition is imported with a reverse-engineering process directly from databases and other sources. 

C. Forevery load the definition of the tables used, their columns and constraints must be manually built. 

D. An external engine must be run to describe what metadata is needed for a Mapping. 

Answer:

Explanation: 

(https://docs.oracle.com/middleware/1212/odi/ODIDG/create_rev_model.htm#ODIDG234) 


Q39. You are designing a package in which you want a certain step to not appear in the ODI logs. How do you accomplish this?(Choose the best answer.) 

A. Right-click the step in Package Editor and select the No Logging menu item. 

B. Modify Operator Navigator settings to disable that step from being displayed. 

C. In Package Editor, click the step, go to the Advanced tab, and set Log Steps in the journal to Never. 

D. Periodically schedule a scenario that usesOdiPurgeLogto remove that step from the ODI logs. 

Answer:


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

Answer: C,D 

Explanation: 

(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1409)