Online 1Z0-448 Practice Test

Question 1

Which two statements are true about using ODI and Oracle GoldenGate together? (Choose two.)

Options :

A : Oracle GoldenGate primarily performs aggregations for ODI.

B : Oracle GoldenGate and ODI are used together primarily for running weekly batch jobs.

C : Oracle GoldenGate provides non-invasive changed data capture capabilities to ODI.

D : ODI starts and stops Oracle GoldenGate processes automatically during a Mapping execution.

E : ODI and Oracle GoldenGate enable real-time business intelligence.

Answer: A,E

Question 2

Your customer wants a project in ODI, which contains a user function, to translate commands with different syntax for different technologies but with the same functionality. How can you achieve this? (Choose the best answer.)

Options :

A : The project must be explicitly mapped within an ODI mapping.

B : A customize knowledge module is needed.

C : An ODI procedure must be associated with it.

D : It can be defined for every technology listed in the topology.

Answer: D

Question 3

Identify two correct statements about reusable Mappings. (Choose two.)

Options :

A : They can have generic input and output signatures.

B : They contain both a Logical and Physical Mapping design.

C : They can be used within regular Mappings.

D : They can be executed directly.

E : They can be shared across projects.

Answer: A,B

Question 4

You must run the same mapping concurrently while avoiding clashes of ODI temporary objects. How must you implement this? (Choose the best answer.)

Options :

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: D

Question 5

Identify two constraints that can be used to ensure uniqueness in ODI. (Choose two.)

Options :

A : conditions

B : foreign keys

C : primary keys

D : alternate keys

E : not null

Answer: B,E

EXPERTY DESIGNED 1Z0-448 PRACTICE TEST