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

A. Command line

B. Designer Navigator

C. Operator Navigator

D. Nowhere, scenarios cannot be edited

A. Yes, ODI only allows manual insertion of information related to source-target mappings.

B. Yes, either the work area can be used to write the functions or a configuration file can be prepared for ODI to read.

C. No, a graphical expression editor can be used to drag and drop columns and the required function definitions.

D. No, a developer must prepare a configuration file and associate to it a user function,

A. Create a scenario from the variable and add the scenario to Load Plan to create a Case Step

B. Add a Case Step, then drag the variable into Case Step

C. Add a Case Step in Load Plan and select variable- in the wizard

D. Drag the variable into Load Plan and define a Case Step

A. connects to a Work Repository r

B. is a Big Data Connector

C. connects to a Master Repository

D. is an Agent configuration

A. They use an Oracle DB as a repository and Tomcat to host the web application

B. They use an Oracle DB as a repository and WebSphere to host the web application

C. They use an Oracle DB as a repository and WebLogic to host the web application

D. They use any DB as a repository and any compatible web application server

E. ODI and EDQ cannot share the same infrastructure, they both have different architecture

A. It is better to load data directly from sources into a data warehouse server.

B. It is mandatory to have an intermediate server.

C. It is mandatory to collect data directly from sources into a data warehouse server using real time replication processes.

D. Data transformation should be distributed across several scalable nodes.

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

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

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

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

A. Create a variable, use it in Topology at the File dataserver-level, and add it to a package as a Set Variable step

B. Create a variable, use it as the Resource Name of the File datastore, and add it to a package as a Set Variable step

C. Create a variable, use it as the Resource Name of the File datastore, and add it to a package as a Declare Variable step

D. Create a variable, use it in Topology at the File dataserver-level, and add it to a package as a Declare Variable step