Free 1z0-448 – Oracle Data Integrator 12c Essentials Practice Test Question

Free demo downloads

Loading demo links...

Showing 4–6 of 10 questions

Question 4

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

Select all that apply, then click Submit answer.

  • ○

    conditions

  • ○

    foreign keys

  • ○

    primary keys

  • ○

    alternate keys

  • ○

    not null

Question 5

Which two statements are true about big data support in ODI? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    ODI uses its own transformation engine to process data in a Hadoop cluster.

  • ○

    ODI performs data transformations inside a Hadoop cluster.

  • ○

    ODI must perform data transformations outside Hadoop in an Oracle database.

  • ○

    ODI allows moving data in and out of a Hadoop cluster.

Question 6

You are designing a Mapping. How are target and source tables defined? (Choose the best answer.)

Select an option, then click Submit answer.

  • ○

    Their definition is imported with a reverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database.

  • ○

    Their definition is imported with a reverse-engineering process directly from databases and other sources.

  • ○

    For every load the definition of the tables used, their columns and constraints must be manually built.

  • ○

    An external engine must be run to describe what metadata is needed for a Mapping.