1Z0-448 Online Practice Questions and Answers

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.

You must modify the order in which data stores are being journalized in a model. What sequence of steps do you follow to achieve this? (Choose the best answer.)

A. Openthe model, go to the Journalizing tab, and modify the order there.

B. Right-click Datastore, select Changed Data Capture, and then select Order.

C. Open the model, go to the Journalized tables tab, and modify the order there.

D. Open the data stores, go to the Journalizing tab, and modify the order there.

You need to reverse engineer a flat file that contains multiple record formats. How must you proceed? (Choose the best answer.)

A. Create a Data Server by using the File technology and specify the various record formats while reverse engineering the file.

B. Create a Data Server by using the XML technology, create annXSDfile by using the Native Format Builder, and then reverse engineer it in a Model.

C. Create a Data Server by using theFile technology, create annXSDfile by using the Native Format Builder, and then reverse engineer it in a Model.

D. Create a Data Server by using the Complex File technology, create annXSDfile by using the NativeFormat Builder, and then reverse engineer it in aModel.

You must monitor and manage a co-located stand-alone agent, OracleDIAgent1, by using the ODI plug-in for Enterprise Manager Cloud Control.

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

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.

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.

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.

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

You need to create a Model that works with multiple underlying technologies. How must you proceed? (Choose the best answer.)

A. This works only for Oracle and Informix.

B. This works only for Oracle and MySQL.

C. Create a new generic technology to support it.

D. Use the out-ofthe box Generic SQL technology.

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

A. ODI Console

B. Oracle GoldenGate

C. Oracle WebLogic Server

D. Oracle BPEL Process Manager