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

Select all that apply, then click Submit answer.

• ○

  Run Exception and Restart

• ○

  Run Exception and Continue

• ○

  Run Exception and Ignore

• ○

  Run Exception and Fail

• ○

  Run Exception and Raise
  
  

Select all that apply, then click Submit answer.

• ○

  They can have generic input and output signatures.

• ○

  They contain both a Logical and Physical Mapping design.

• ○

  They can be used within regular Mappings.

• ○

  They can be executed directly.

• ○

  They can be shared across projects.
  
  

Select all that apply, then click Submit answer.

• ○

  Restart from new session.

• ○

  Restart from failure.

• ○

  Restart from failed children.

• ○

  Restart all children.
  
  

Select all that apply, then click Submit answer.

• ○

  conditions

• ○

  foreign keys

• ○

  primary keys

• ○

  alternate keys

• ○

  not null
  
  

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.
  
  

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.
  
  

Select an option, then click Submit answer.

• ○

  The execution should be done only on the development data environment, as long as the other environment is a mirrored copy.

• ○

  Only the production environment can be used.

• ○

  All environments linked to a logical schema can be used to reverse-engineer table structures.

• ○

  Only a Java engine intermediate environment can be processed.
  
  

Select an option, then click Submit answer.

• ○

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

• ○

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

• ○

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

• ○

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

Select an option, then click Submit answer.

• ○

  The Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI.

• ○

  The Knowledge Module must be customized only for aggregation functions.

• ○

  The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.

• ○

  The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.
  
  

Select an option, then click Submit answer.

• ○

  It is not possible to use a specific partition.

• ○

  Only ODI variables can be used to filter the target table loading.

• ○

  An option in the Mapping can be used to declare partitions but an ODI variable must be used to evaluate the correct partition value.

• ○

  An option in the Mapping can be used to declare the partition that has to be used for the loading.