Oracle Data Integrator 12c Essentials (1z1-448) Free Practice Test

Question 1

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

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

B. It is used to load data between Teradata and Oracle.

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

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

Correct Answer: A,D

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

Question 2

Which tables created by ODI contain error records? (Choose the best answer.)

A. E$

B. ERROR$

C. ODI_ERR$

D. ERR$

Correct Answer: A

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

Question 3

How does the data flow when moving records between two servers by using Database Links and an Agent installed on a middle-tier server? (Choose the best answer.)

A. from the source database onto the server running the Agent and then into the target database

B. from the source database into the machine running ODI Studio and then into the target database

C. directly from the source database to the target database

D. from the source database into flat files that are then loaded into the target database

Correct Answer: C

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

Question 4

A Mapping that uses CDC does not load any source data and you want to check the
SNP_CDC_SET table to find out the current window ID.
In which database schema must you look to find this table? (Choose the best answer.)

A. the schema hosting the Staging Area

B. the schema hosting the Work repository

C. the schema hosting theWork schema of the default schema defined for your source data server

D. SYS

Correct Answer: C

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

Question 5

You must monitor and manage a co-located stand-alone agent, OracleDIAgent1, by using the ODI plug-in for Enterprise Manager Cloud Control. Which is the correct command to start this agent on Linux? (Choose the best answer.)

A. ./agent.sh -NAME=OracleDIAgent1

B. ./agent.sh -NAME=OracleDIAgent1 -PORT=20910

C. ./startComponent.sh OracleDIAgent1

D. ./startComponent.sh OracleDIAgent1 -PORT=20910

Correct Answer: B

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

Question 6

Which statement is true about the IKM SQL Control Append that creates an intermediate integration table prefixed with I$? (Choose the best answer.)

A. Theintermediate integration table prefixed with I$is required to determine which records must be inserted.

B. IfFlow Control is not necessary, an I$ table is not created.

C. Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.

D. Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.

Correct Answer: C

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

Question 7

You need to create a package that automatically sends an alert to users in case the third step fails.
Which option represents the steps to accomplish this? (Choose the best answer.)

A. Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a red KO arrow.

B. Add anOdiSendMailstep to My Package and link the My Last Package step to it by using a red KO arrow.

C. Add anOdiReadMailstep to My Package and link the My Third Package step to it by using a red KO arrow.

D. Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a green OK arrow.

Correct Answer: B

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

Question 8

You need to troubleshoot the execution of a Mapping and visualize the data contained in the ODI Staging tables while the Mapping is being executed. How must you proceed? (Choose the best answer.)

A. Use variables in a Package to query the Staging tablesand evaluate the variable values.

B. Modifya Knowledge Module to dump the Staging tables' data into log files for review.

C. Start a Mapping in Debug mode and use breakpoints and the Get Data featureto query the data contained in the Staging tables.

D. Reverse engineer the Staging tables in a Modeland review the data contained in it.

Correct Answer: D

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

Welcome to TestSimulate

Oracle Data Integrator 12c Essentials (1z1-448) Free Practice Test