Odi Gorka

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

How does the data flow when moving records between two servers by using Database Links and an
Agent installed on a middle–tier server? (Choose the best answer.)

A. from the source database into flat files that are then loaded into the target database
B. directly from the source database to the target database
C. from the source database onto the server running the Agent and then into the target database
D. from the source database into the machine running ODI Studio and then into the target databa

You are a project developer using ODI and want to consolidate your own local metadata repositories.
Identify the true statement. (Choose the best answer.)

A. You must consolidate your own local metadata repositories. The local metadata must be
transmitted via ftp and synchronized with a dedicated proprietary engine, creating a common
metadata model for all the developers.

B. You must consolidate your own local metadata repositories. You have to invoke a dedicated web
service to synchronize the metadata by using Oracle Service Bus.

C. You need not consolidate your own local metadata repositories, because the ODI proprietary
metadata server allows all developers to share the common metadata of a specific project.

D. You need not consolidate your own local metadata repositories, because ODI uses a centralized
relational metadata repository that all the developers share.

How should you define the Work Schema of a Physical Schema? (Choose the best answer.)

A. Use a dedicated schema such as ODI_STAGING.
B. Use TEMP.
C. Use the same schema as the Data Schema.
D. Use SYSTEM.

You have been tasked with designing a Mapping that must perform an initial load and incremental
updates using the same transformation logic. How should you proceed? (Choose the best answer.)

A. Create a single Mapping with two Physical Designs: one for theinitialload and one for the
incremental updates.
B. Create a single Mapping with a single Physical Design and modify it appropriately when an initial
load is required or when an incremental update is required.
C. Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the
transformation logic.
D. Create a single Mapping and use variables in the Logical Design to do an initial load when required
or an incremental update otherwise.

How are the ODI repositories upgraded? (Choose the best answer.)

A. by using Opatch
B. by using ODI Studio
C. by using the import/export utilities
D. by using Upgrade Assistant

You are designing a package in which you want a certain step to not appear in the ODI logs. How do you accomplish this? (Choose the best answer.)

A. Right–click the step in Package Editor and select the No Logging menu item.

B. Modify Operator Navigator settings to disable that step from being displayed.

C. In Package Editor, click the step, go to the Advanced tab, and set Log Steps in the journal to Never.

D. Periodically schedule a scenario that uses OdiPurgeLog to remove that step from the ODI logs

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

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.

Which tables created by ODI contain error records? (Choose the best answer.)

"A. ERR$"
"B. ERROR$"
"C. ODI_ERR$"
"D. E$

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.

If multiple changes occur on the source system but have not yet been processed by ODI, the J$ table contains entries for each change for the records sharing the same PK."
What happens at run time when a Mapping gets executed? (Choose the best answer.)

"A. All distinct entries are processed."
"B. Only the latest entry is processed based on the JRN_DATE field."
"C. Only the first entry is processed based on the JRN_DATE field."
"D. A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.

You have to loop through a Mapping step three times in a package by using variables. Identify the correct variable data type to create the loop. (Choose the best answer.)"

"A. numeric"
"B. alphanumeric"
"C. date"
"D. text

Which statement is true about the need to have a topology with an intermediate server, in order to use ODI correctly in a data warehouse project? (Choose the best answer.)"

"A. Data transformation must be distributed across several scalable nodes."
"B. It is mandatory to have an intermediate server."
"C. It is better to load data directly from sources into a data warehouse server."
"D. It is mandatory to collect data directly from sources to a data warehouse server by using real time replication processes.

The workflow you are designing requires checking to see whether there are records available in a source table before doing anything. Which ODI tool must you use to implement this? (Choose the best answer.)"

"A. OdiWaitForData"
"B. OdiWaitForCDCData"
"C. OdiWaitForLogData"
"D. OdiWaitForTable

Which product is included in ODI web–based components? (Choose the best answer.)"

"A. Oracle BPEL Process Manager"
"B. Oracle GoldenGate"
"C. ODI Console"
"D. Oracle WebLogic Server

When Oracle Data Integrator (ODI) and Oracle GoldenGate are used together, which option"
represents the phases of an ELT process that Oracle GoldenGate performs?
"A. transform only"
"B. load and transform"
"C. extract and load"
"D. extract and transform

You need to implement security mechanisms that allow only user “A” to view all the Mappings contained in a specific project named “P1.” How must you proceed? (Choose the best answer.)"

"A. Go to Security, assign the NG DESIGNER profile to user “A.” Next, drag project “P1” to user “A” and finally setView privilegesto Active for the Mapping objects."
"B. Go to Security, assign the DESIGNER profile to user “A.” Next, drag project “P1” to user “A” and finally set View privileges to Active for the Mapping objects."
"C. Go to Security, assign the NG DESIGNER profile to user “A.” Next, drag project “P1” to user “A” and finally set View privileges to Active for the Project, Folder, and Mapping objects."
"D. Go to Security, assign the DESIGNER profile to user “A.” Next, drag project “P1” to user “A” and finally set View privileges to Active for the Project, Folder, and Mapping objects.

You must modify the order in which data stores are being journalized in a model. What sequence of steps do you follow to achieve this? (Choose the best answer.)"

"A. Open the model, go to the Journalizing tab, and modify the order there."
"B. Right–click Datastore, select Changed Data Capture, and then select Order."
"C. Open the model, go to the Journalized tables tab, and modify the order there."
"D. Open the data stores, go to the Journalizing tab, and modify the order there.

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 Informix."
"B. This works only for Oracle and MySQL."
"C. Create a new generic technology to support it."
"D. Use the out–ofthe box Generic SQL technology.

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"

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

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 engineering."
"B. This option is always available."
"C. You can never make this choice."
"D. This option may be available only if the underlying technology supports it.

You need to reverse engineer a flat file that contains multiple record formats. How must you proceed? (Choose the best answer.)"

"A. Create a Data Server by using the File technology and specify the various record formats while reverse engineering the file."
"B. Create a Data Server by using the XML technology, create and nXSD file by using the Native Format Builder, and then reverse engineer it in a Model."
"C. Create a Data Server by using the File technology, create and nXSD file by using the Native Format Builder, and then reverse engineer it in a Model."
"D. Create a Data Server by using the Complex File technology, create and XSD file by using the Native Format Builder, and then reverse engineer it in a Model.

Identify two benefits that are unique to ODI JEE Agents. (Choose two.)"

"A. high availability"
"B. minimal footprint"
"C. access to WebLogic connection pools"
"D. management in Enterprise Manager Cloud Control

Identify the ODI tool used to write content into a file in a package. (Choose the best answer.)

"A. OdiOutFile"
"B. OdiFileCopy"
"C. OdiFileMove"
"D. OdiInFile

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

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

"A. conditions"
"B. foreign keys"
"C. primary keys"
"D. alternate keys"
"E. not null

You want to modify the code generated by a failed Task and restart the session. How must you proceed? (Choose the best answer.)

"A. Open the Task in Operator, go to Code, click Edit, use Pre–execution Code to edit the code, and save it."
"B. It is not possible to modify the code once it has been generated."
"C. Open the Step in Operator, edit the code, and save it."
"D. Open the Task in Operator, go to Code, click Query/Execution Plan to edit the code, and save it.

You want to ensure that the Physical Mapping Design cannot be modified even if the Logical Design of the Mapping is changed. What sequence of steps must you follow to achieve this? (Choose the best answer)"

"A. Go to the Physical tab, select the Fixed Design check box of the Physical Mapping Design."
"B. Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design."
"C. Go to the Physical tab, select the Read–only check box of the Physical Mapping Design."
"D. Go to the Physical tab, deselect the Modify check box of the Physical Mapping Design.

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 constraints on 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 the related database catalog. You can reverse engineer only the existing constraints.

Identify two correct Restart values for parallel steps in load plans. (Choose two.)"

"A. Restart from new session."
"B. Restart from failure."
"C. Restart from failed children."
"D. Restart all children.

What is the main benefit of using consistent set journalizing compared to simple journalizing? (Choose the best answer.)

"A. Consistent set journalizing runs faster than simple journalizing."
"B. Consistent set journalizing always uses Oracle Golden Gate."
"C. Consistent set journalizing treats each data store individually."
"D. Consistent set journalizing provides a guarantee of consistency of the captured changes.

Identify the name of the default WebLogic data source created for the Master Repository when setting up a JEE domain. (Choose the best answer.)"

"A. odiMasterRepository"
"B. MasterRepository"
"C. odimasterrepository"
"D. ODIMasterRepository

You must send the same message in multiple packages to several email addresses stored in the same database table. How do you accomplish this by using a reusable package step? "

"A. Create a procedure and add two tasks. "

"B. Create a Knowledge Module. "

"C. Create a counter variable."

"D. Create a procedure

Updates have been made to Mappings in a package. What must you do to ensure that the Production team runs a scenario that contains those updates while preserving the existing scenario’s schedule? (Choose the best answer.)"

"A. Regenerate the existing scenario."
"B. Nothing, the existing scenario will automatically be updated."
"C. Generate a new scenario and create a new schedule."
"D. Generate a new scenario and attach the previous scenario’s schedule to it.

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.

Identify two correct exception behavior values for Run Scenario steps in load plans. (Choose two.)

"A. Run Exception and Restart"
"B. Run Exception and Continue"
"C. Run Exception and Ignore"
"D. Run Exception and Fail"
"E. Run Exception and Raise

Which are the two correct statements about Work repositories? (Choose two.)

"A. They contain project and security information."
"B. They contain data models and execution information."
"C. They contain data and security information."
"D. They contain data models and project information.

You must ensure that your Mappings do not run into connectivity issues when moving data from server A to server B by using an AGT agent that is running on server B.
How must you test this by using ODI Studio running on machine C? (Choose the best answer.)

"A. Use OdiPingAgent in a package to ping AGT agent."
"B. In Topology, test the connections to servers A and B by using the AGT agent."
"C. In Topology, test the connections to the AGT agent."
"D. In Topology, test the connections to servers A and B by using Local (No Agent).

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, use odiRef.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, use odiRef.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, use odiRef.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, use odiRef.getPrevStepStatus () in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

You want to add a new CDC subscriber in ODI after you have started the journal process. Which option represents the steps to use this new subscriber? (Choose the best answer.)

"A. Add a new subscriber and edit the default Journalizing filter in your Mappings."
"B. Drop the journal, add a new subscriber, start the journal, and edit the default Journalizing filter in your Mappings."
"C. Drop the journal, remove existing subscribers, add a new subscriber, start the journal, and edit the default Journalizing filter in your Mappings."
"D. Add a new subscriber, start the journal, and remove the default Journalizing filter in your Mappings.

As part of your QA process you want to view code at the Step level in Operator. How must you proceed? (Choose the best answer.)"

"A. It is only possible to see code at the Session level."
"B. It is only possible to view code at the Task level."
"C. Depending on the audit level declared when running the execution, some of the generated code at the step level can be viewed."
"D. All generated code can be viewed together at the step level, with a complete list of executed code.

You design 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 boxes."
"B. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Unlock Subscriber and Purge Journal check boxes."
"C. Add a model to the package, set the Model step to Journalizing Model, and select the Extend Window and Lock Subscriber check boxes."
"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 boxes.

You need to troubleshoot the execution of a Mapping and visualize the data contained in the ODI Staging tables while the Mapping is being executed. How must you proceed? (Choose the best answer.)"

"A. Start a Mapping in Debug mode and use breakpoints and the Get Data feature to query the data contained in the Staging tables."
"B. Modify a Knowledge Module to dump the Staging tables’ data into log files for review."
"C. Use variables in a Package to query the Staging tables and evaluate the variable values."
"D. Reverse engineer the Staging tables in a Mode land review the data contained in it.

Which two objects can be dragged to a Mapping? (Choose two.)"

"A. Variables"
"B. Datastores"
"C. Knowledge Modules"
"D. Reusable Mappings

A Mapping that uses CDC does not load any source data and you want to check the SNP_CDC_SET table to find out the current window ID.
In which database schema must you look to find this table? (Choose the best answer.)

"A. the schema hosting the Work repository"
"B. the schema hosting the Work schema of the default schema defined for your source data server"
"C. the schema hosting the Staging Area"
"D. SYS

Which is the correct statement about the contents of Master repositories? (Choose the best answer.)"

"A. They contain data model and security information."
"B. They contain security and topology information."
"C. They contain project and topology information."
"D. They contain project and security information.

How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.)"

"A. The Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI."
"B. The Knowledge Module must be customized only for aggregation functions."
"C. The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic."
"D. The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.

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 Knowledge Module single–technology is required."
"B. Only an Integration Knowledge Module multitechnology is required."
"C. A loading Knowledge Module multitechnology and an Integration Knowledge Module single– technology are required."
"D. Both a Loading Knowledge Module multitechnology and an Integration Knowledge Module multitechnology are required.

You are working with delimited flat files and want to enforce a primary key on a flat file by using a Check Knowledge Modules (CKM). However, you encounter an error."
Why did this happen? (Choose the best answer.)

"A. It is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) queries."
"B. It is not possible to enforce constraints on any technology."
"C. It is only possible to forward–engineer it to the flat file definition."
"D. It is possible to enforce a primary key on a flat file by using a CKM"

"A. ./agent.sh –NAME=OracleDIAgent1 –PORT=20910"
"B. ./agent.sh –NAME=OracleDIAgent1"
"C. ./startComponent.sh OracleDIAgent1"
"D. ./startComponent.sh OracleDIAgent1 –PORT=20910

How do you reuse a configuration of OdiSendMail across multiple packages? (Choose the best answer.)"

"A. Add a sub–model to a package, set the Sub–model step to Journalizing Sub–model, and select the Extend Window and Lock Subscriber check boxes."
"B. Add an OdiSendMail step to a knowledge module."
"C. Duplicate the OdiSendMail step into multiple packages."
"D. Create a procedure with a step that uses OdiSendMail and add this procedure into multiple packages.

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

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

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.