Oracle Data Integrator 12c Essentials - 1z0-448 Exam Practice Test

Question 1

When Oracle Data Integrator (ODI) and Oracle GoldenGate are used together, which option represents the phases of an ELT process that Oracle GoldenGate performs? (Choose the best answer.)

A. transform only

B. extract and load

C. extract and transform

D. load and transform

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

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

A. Select the Use Unique Temporary Object Names check box at the Physical Design level.

B. Use variables in the Logical Design of the Mapping to create unique temporary object names.

C. Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names.

D. Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

You are working with delimited flat files and want to enforce a primary key on a flat file by using a Check Knowledge Modules (CKM). However, you encounter an error.
Why did this happen? (Choose the best answer.)

A. It is possible to enforce a primary key on a flat file by using a CKM; however, you have to save it as a fixed file.

B. It is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) queries.

C. It is not possible to enforce constraints on any technology.

D. It is only possible to forward-engineer it to the flat file definition.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

The workflow you are designing requires checking to see whether there are records available in a source table before doing anything. Which ODI tool must you use to implement this? (Choose the best answer.)

A. OdiWaitForData

B. OdiWaitForLogData

C. OdiWaitForCDCData

D. OdiWaitForTable

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

You are working on notifications in a package and you must send an email containing an error message in case a Package step fails.
Which odiRef method do you use to access the error message? (Choose the best answer.)

A. odiRef.getPrevStepLog()

B. odiRef.getSession()

C. odiRef.getInfo()

D. odiRef.getStep()

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

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

A. Only the latest entry is processed based on theJRN_DATEfield.

B. Only the first entry is processed based on theJRN_DATEfield.

C. All distinct entries are processed.

D. A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

Identify two correct statements about reusable Mappings. (Choose two.)

A. They can have generic input and output signatures.

B. They contain both a Logical and Physical Mapping design.

C. They can be used within regular Mappings.

D. They can be executed directly.

E. They can be shared across projects.

Correct Answer: A,B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 8

Your package logic requires you to retrieve the status of the previous package step into a variable.
How must you implement this? (Choose the best answer.)

A. Create a variable, useodiRef.getStep ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

B. Create a variable, useodiRef.getPrevInfo ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

C. Create a variable, useodiRef.getPrevStepLog ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

D. Create a variable, useodiRef.getPrevStepStatus ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Oracle Data Integrator 12c Essentials - 1z0-448 Exam Practice Test

Latest Update

Useful Links

Contact Us