1Z0-448 Oracle Exam Questions and Free Practice Test

Question 13

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 Informi

B. This works only for Oracle and MySQ

C. Create a new generic technology to support i

D. Use the out-ofthe box Generic SQL technolog

Correct Answer:D

(https://docs.oracle.com/middleware/1212/odi/ODIDG/projects.htm#ODIDG326)

Question 14

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 on

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

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

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

Correct Answer:C

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

Question 15

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 engineerin

B. This option is always availabl

C. You can never make this choic

D. This option may be available only if the underlying technology supports i

Correct Answer:B

(https://blogs.oracle.com/dataintegration/entry/user_interface_and_terminology_changes1)

Question 16

Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.)

A. extracting source data to flat files

B. triggers

C. Oracle GoldenGate

D. before-and-after database image comparison

Correct Answer:BC

Question 17

Youdesign a package with mappings that consume data from journalized data stores in Consistent Set CDC mode. Which option represents the steps that must be performed at the beginning of your package to accomplish this?(Choose the best answer.)

A. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Extend Window and Lock Subscriber check boxe

B. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Unlock Subscriber and Purge Journal check boxe

C. Add a model to the package, set the Model step to Journalizing Model, and select the Extend Window and Lock Subscriber check boxe

D. Add a sub model to the package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxe

Correct Answer:C

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

START 1Z0-448 EXAM