Oracle Data Integrator 11g Certified Implementation Essentials

Question 1

Select the correct statement. When running an interface in ODI, is it possible to see a simul-ation of the code?

A. No, that is a current limitation in ODI.

B. No, but it is possible to query the metadata repository in order to see the generated code.

C. Yes, but it is only possible to see a code simulation on ODI Console.

D. Yes, before executing the interface, it is possible to set a flag to request the code simulation.

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

Which two ODI knowledge modules are included in the Application Adapter for Hadoop?

A. IKM File to Hive

B. IKM Hive Transform

C. IKM Oracle Incremental Update

D. IKM SQL to File Append

Correct Answer: A,B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

Identify one correct statement regarding Exception steps in Load Plans.

A. Exception steps can be defined for most Step types in a Load Plan.

B. Exception steps can only be defined for Parallel Steps in a Load Plan

C. Exception steps cannot be defined in a Load Plan.

D. Exception steps can only be defined for Serial Steps in a Load Plan.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

Do all project developers using ODI need to consolidate their own local metadata repositories?

A. No, ODI proprietary metadata server allows all developers to share the common metadata of a specific project.

B. Yes, you have to invoke a dedicated web service to synchronize the metadata using the Oracle Service Bus.

C. No, ODI uses a centralized relational metadata repository that all the developers share.

D. Yes, the local metadata needs to be transmitted via FTP and synchronized with a dedicated proprietary engine, creating a common metadata model for all developers.

Correct Answer: C

Question 5

Identify two parameters of the OGG JKMs that must be set in order to configure OGG through ODI.

A. SRC__OGG__OBJECT_GROUP

B. AUTO CONFIGURATION

C. ST G_MANAGER_PORT

D. SYNC__JRN_DELETE

Correct Answer: A,C

Question 6

In an ODI interface, if a business rule is declared to calculate a sum aggregation, does a knowledge module need to be customized in order to create the correct code?

A. No, aggregation code is generated automatically by ODI according to the mapping logic rules.

B. Yes, a customization is needed only for aggregation functions.

C. No, it is not needed but, a variable must be declared in the source mapping in order to generate the correct sum.

D. Yes, business rules and the physical implementation are strictly interlayed in ODI.

Correct Answer: A

Question 7

In an ODI interface, to declare a lookup, is there a dedicated graphical object?

A. Yes, there is a specific object and you need to prepare a configuration file to use it.

B. No, in ODI you can declare a lookup only using an ODI procedure.

C. Yes, there is a specific object, you click it and a wizard helps the developer to set the lookup.

D. No, in ODI you can declare a lookup only using a join definition.

Correct Answer: C

Question 8

If an ODI user function has one syntax and one or more implementations, can it be used in an ODI interface mapping?

A. Yes, during execution, it will substitute the specific technology implementation.

B. Yes, but you need to write a custom knowledge module.

C. No, it can only have one syntax and one implementation for all technologies.

D. Yes, but to be mapped in an ODI interface it also needs an ODI variable.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Oracle Data Integrator 11g Certified Implementation Essentials - 1z1-482 Exam Practice Test

Latest Update

Useful Links

Contact Us