1z0-448 Practice Test

1z0-448 Practice Test practice questions, page 2 of 3, with answer review and explanations.

Question 6

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

  1. by using Opatch
  2. by using ODI Studio
  3. by using the import/export utilities
  4. by using Upgrade Assistant

Question 7

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

  1. Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names.
  2. Use variables in the Logical Design of the Mapping to create unique temporary object names.
  3. Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names.
  4. Select the Use Unique Temporary Object Names check box at the Physical Design level.

Question 8

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

  1. ERR$
  2. ERROR$
  3. ODI_ERR$
  4. E$

Question 9

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

  1. The project must be explicitly mapped within an ODI mapping.
  2. A customize knowledge module is needed.
  3. An ODI procedure must be associated with it.
  4. It can be defined for every technology listed in the topology.

Question 10

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

  1. All distinct entries are processed.
  2. Only the latest entry is processed based on the JRN_DATE field.
  3. Only the first entry is processed based on the JRN_DATE field.
  4. A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.