1Z0-448 Exam - Oracle Data Integrator 12c Essentials

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

View Answer

Q2. Which product is included in ODI web-based components?(Choose the best answer.) 

A. Oracle BPEL Process Manager 

B. Oracle GoldenGate 

C. ODI Console 

D. Oracle WebLogic Server 

View Answer

Q3. How are the domains of ODI Agents configured?(Choose the best answer.) 

A. by using Upgrade Assistant 

B. by using ODI Studio 

C. by using Domain Creation Assistant 

D. by using Configuration Wizard 

View Answer

Q4. The workflow you are designing requires checking to see whether there are records available in a source table before doing anything. Which ODI tool must you use to implement this?(Choose the best answer.) 

A. OdiWaitForData 

B. OdiWaitForCDCData 

C. OdiWaitForLogData 

D. OdiWaitForTable 

View Answer

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

View Answer

Q6. You need totroubleshoot the execution of a Mapping and visualize the data contained in the ODI Staging tableswhile the Mapping is being executed. How must you proceed?(Choose the best answer.) 

A. Start a Mapping in Debug mode and use breakpoints and the Get Data featureto query the data contained in the Staging tables. 

B. Modifya Knowledge Module to dump the Staging tables’ data into log files for review. 

C. Use variables in a Package to query the Staging tablesand evaluate the variable values. 

D. Reverse engineer the Staging tables in a Modeland review the data contained in it. 

View Answer

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

View Answer

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

View Answer

Q9. How do youprovide a timeout value for an exception step?(Choose the best answer.) 

A. by using a custom Groovy script 

B. by using a variable 

C. by using the Timeout filed 

D. by using a Timeout knowledge module 

View Answer

Q10. You are designing a load plan in which you must run Mappings A and B one after the other while running Mapping C at the same time. Which option represents the steps to accomplish this?(Choose the best answer.) 

A. Add a parallel step, add three serial steps underneath it, then addAto the first parallel step, B to the second one, and C to the last one. 

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

C. Add a parallel step, add two parallel steps underneath it, then add A and B tooneparallel step, and C to the other. 

D. Add a parallel step, add two serial steps underneath it, then add A and B to one serial step, and C to the other. 

View Answer