1Z0-448 Online Practice Questions and Answers

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

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

A. ERR$

B. ERROR$

C. ODI_ERR$

D. E$

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 theFixedDesign check boxof 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 theModify check boxof the Physical Mapping Design.

You create two mappings that both use the same changed data and run at different times. One runs every 15 minutes and the other runs once every day.

What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping? (Choose the best answer.)

A. Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change theJRN_SUBSCRIBERcolumn in the correspondingJ$table to keep the changed data present for the second Mapping.

B. Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.

C. Duplicate the source data store for each Mapping.

D. Create two distinct subscribers for each Mapping.

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

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

C. Consistent set journalizing treats each data store individually.

D. Consistent set journalizing provides a guarantee of consistency of the captured changes.

Your project requires a loop through the same package logic 24/7. You must be able to purge those executions when required.

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

A. Link the last step of the package to its first step to create an infinite loop.

B. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save and regenerate this scenario.

C. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save.

D. Drag the package to the last step in the package, run it asynchronously, and then save.

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 theWork schema of the default schema defined for your source data server

C. the schema hosting the Staging Area

D. SYS

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.

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

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

How do you provide a timeout value for an exception step? (Choose the best answer.)

A. by using a custom Groovy script

B. by using a variable

C. by using the Timeout filed

D. by using a Timeout knowledge module

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.