Labour Day Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

1z0-448 Exam Dumps - Oracle Data Integrator 12cEssentials

Question # 4

What must you set on the Definition tab of a variable to protect the variable value from being displayed in the Operator logs? (Choose the best answer.)

A.

Select the Secure Value check box.

B.

Select the Hide Value check box.

C.

Set the Keep History field to No History.

D.

Leave the Default Value field empty.

Full Access
Question # 5

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

A.

Evaluate Variable

B.

Set Variable

C.

Declare Variable

D.

Refresh Variable

Full Access
Question # 6

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.

Full Access
Question # 7

Which is the correct statement about the contents of Master repositories? (Choose the best answer.)

A.

They contain data model and security information.

B.

They contain security and topology information.

C.

They contain project and topology information.

D.

They contain project and security information.

Full Access
Question # 8

Which statement is correct about choosing the join order in an ODI Mapping when defining a join? (Choose the best answer.)

A.

This option is inherited from reverse engineering.

B.

This option is always available.

C.

You can never make this choice.

D.

This option may be available only if the underlying technology supports it.

Full Access
Question # 9

How can you define the order in which target data stores are loaded in a Mapping? (Choose the best answer.)

A.

ODI automatically computes the load order based on the order on which the data stores were added to the Mapping.

B.

You can use the Target Order field.

C.

You can use the Target Load Order field.

D.

You can use the Load Order field.

Full Access
Question # 10

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.

Full Access
Question # 11

Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)? (Choose two.)

A.

It enables developers to execute most ODI operations through a Java program.

B.

It can be used to embed ODI processes into another product.

C.

It is used to load data between Teradata and Oracle.

D.

It must be used by ETL developers to develop ODI processes.

Full Access