Oracle Data Integrator 12c Certified Implementation Spe Changed 1z0-448 Questions

Oracle Data Integrator 12cEssentials Questions and Answers

Question 5

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

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

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

It is only possible to see code at the Session level.

It is only possible to view code at the Task level.

Depending on the audit level declared when running the execution, some of the generated code at the step level can be viewed.

All generated code can be viewed together at the step level, with a complete list of executed code.

Question 7

Identify the correct variable step type to use when assigning a value to a variable with an SQL query. (Choose the best answer.)

Evaluate Variable

Set Variable

Declare Variable

Refresh Variable

Question 8

Which statement is true about defining more than one physical schema associated to the same data server? (Choose the best answer.)

ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.

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.

It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.

It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.