1Z0-448 Oracle Exam Questions and Free Practice Test

Question 7

Which statement is true about theIKM SQL Control Append thatcreates 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 inserte

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

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

D. Neither the LKM northe IKM create intermediate table

E. Most of their work is performed in the ODI Agent memor

Correct Answer:D
(http://www.oracle.com/us/products/middleware/data-integration/odi-performance-guide-wp-2147067.pdf)

Question 8

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

Correct Answer:B

Question 9

Which statement is correct about all expressions in a Mapping?(Choose the best answer.)

A. It is possible to set the execution location on source, staging area, or targe

B. All transformations are executed on the staging are

C. Only the source and target servers can be used to execute expression

D. All expressions are executed on the source are

Correct Answer:A

(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/interfaces.htm#ODIDG1040)

Question 10

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

A. ODI uses its own transformation engine to process data in a Hadoop cluste

B. ODI performs data transformations inside a Hadoop cluste

C. ODI must perform data transformations outside Hadoop in an Oracle databas

D. ODI allows moving data in and out of a Hadoop cluste

Correct Answer:BD
(https://docs.oracle.com/middleware/1213/odi/develop-app-adapters/hadoop.htm#ODIAA193)

Question 11

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

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

B. Modifya Knowledge Module to dump the Staging tables’ data into log files for revie

C. Use variables in a Package to query the Staging tablesand evaluate the variable value

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

Correct Answer:D
(https://docs.oracle.com/middleware/1212/odi/ODIKD/rkm.htm#ODIKD909)

Question 12

You must ensure that your Mappings do not run into connectivity issues when moving data from server A to server B by using an AGT agent that is running on server B.
How must you test this by using ODI Studio running on machine C?(Choose the best answer.)

A. UseOdiPingAgentin a package to ping AGT agen

B. In Topology, test the connections to servers A and B by using the AGT agen

C. In Topology, test the connections to the AGT agen

D. In Topology, test the connections to servers A and B by using Local (No Agent).

Correct Answer:B
(http://www.ateam-oracle.com/how-to-understand-and-diagnose-odi-connectivity-issues/) as per this link even choice A is right as its alternative/additional method for testing connectivity

START 1Z0-448 EXAM