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

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.

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.

Which statement is true about defining more than one physical schema associated to the same data server? (Choose the best answer.)

A. ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.

B. It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.

C. It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.

D. It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.

Your package logic requires you to retrieve the status of the previous package step into a variable.

How must you implement this? (Choose the best answer.)

A. Create a variable, useodiRef.getPrevStepLog ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

B. Create a variable, useodiRef.getPrevInfo ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

C. Create a variable, useodiRef.getStep ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

D. Create a variable, useodiRef.getPrevStepStatus ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

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

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.

You are defining a data store in ODI metadata and want to add a primary key even if it does not physically exist on the related database catalog.

How can you accomplish this? (Choose the best answer.)

A. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraintson the data store.

B. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints to the data store diagram.

C. You cannot add a primary key if it does not physically exist on the related database catalog. You can flag only non-null conditions to be checked.

D. You cannot add a primary key if it does not physically exist on therelated database catalog. You can reverse engineer only the existing constraints.

The source and target data stores are located on the same data server.

Which statement is correct about the need for a Loading Knowledge Module to load the data on the target? (Choose the best answer.)

A. Only an Integration KnowledgeModule single-technology is required.

B. Only an Integration Knowledge Module multitechnology is required.

C. Aloading Knowledge Module multitechnology and an IntegrationKnowledgeModule single- technology are required.

D. Both a Loading Knowledge Module multitechnology and an Integration Knowledge Module multitechnology are required.

Which two statements are true about ODI web-based components? (Choose two.)

A. ODI Console allows administrators to edit users' information.

B. Enterprise Manager Cloud Control provides access to ODI data servers' settings.

C. ODI sessions can be monitored in Enterprise Manager Cloud Control.

D. ODI Console provides access to project and mapping details.

Which ODI Agent is deployed in Oracle WebLogic Server? (Choose the best answer.)

A. ODI Runtime Agent

B. ODI Standalone Agent

C. ODI JEE Agent

D. ODI Colocated Standalone Agent

Which statement is correct about all expressions in a Mapping? (Choose the best answer.)

A. It is possible to set the execution location on source, staging area, or target.

B. All transformations are executed on the staging area.

C. Only the source and target servers can be used to execute expressions.

D. All expressions are executed on the source area.