oracle 1z0-448 practice test

Oracle Data Integrator 12c Essentials Exam

Last exam update: Jul 16 ,2024
Page 1 out of 6. Viewing questions 1-15 out of 79

Question 1

You are designing a package in which you want a certain step to not appear in the ODI logs. How do
you accomplish this? (Choose the best answer.)

  • A. Right-click the step in Package Editor and select the No Logging menu item.
  • B. Modify Operator Navigator settings to disable that step from being displayed.
  • C. In Package Editor, click the step, go to the Advanced tab, and set Log Steps in the journal to Never.
  • D. Periodically schedule a scenario that usesOdiPurgeLogto remove that step from the ODI logs.
Mark Question:
Answer:

C

User Votes:
A 2 votes
50%
B
50%
C 4 votes
50%
D 1 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
vikasnigam
3 months, 2 weeks ago

C uncheck box to not log


Question 2

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 target.
  • B. All transformations are executed on the staging area.
  • C. Only the source and target servers can be used to execute expressions.
  • D. All expressions are executed on the source area.
Mark Question:
Answer:

A

User Votes:
A 4 votes
50%
B
50%
C
50%
D
50%

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

Discussions
vote your answer:
A
B
C
D
0 / 1000
vikasnigam
3 months, 2 weeks ago

ODI supports executoon location based on yopology design


Question 3

How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate
the correct code? (Choose the best answer.)

  • A. The Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI.
  • B. The Knowledge Module must be customized only for aggregation functions.
  • C. The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.
  • D. The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.
Mark Question:
Answer:

D

User Votes:
A
50%
B
50%
C 1 votes
50%
D 3 votes
50%

Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1625)

Discussions
vote your answer:
A
B
C
D
0 / 1000
vikasnigam
3 months, 2 weeks ago

Variables set the workflows based on business processes.


Question 4

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.
Mark Question:
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D 3 votes
50%

Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/projects.htm#ODIDG326)

Discussions
vote your answer:
A
B
C
D
0 / 1000
vikasnigam
3 months, 2 weeks ago

Sql is generic for many technologies


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
Mark Question:
Answer:

B

User Votes:
A
50%
B 3 votes
50%
C 1 votes
50%
D 1 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
vikasnigam
3 months, 2 weeks ago

Set variable


Question 6

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.
Mark Question:
Answer:

C

User Votes:
A
50%
B 2 votes
50%
C 2 votes
50%
D
50%

Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1562)

Discussions
vote your answer:
A
B
C
D
0 / 1000
vikasnigam
3 months, 2 weeks ago

Target will be used based on knowledge module


Question 7

You need to implement security mechanisms that allow only user “A” to view all the Mappings
contained in a specific project named “P1.” How must you proceed? (Choose the best answer.)

  • A. Go to Security, assign the NG DESIGNER profile to user A. Next, drag project P1 to user A and finally setView privilegesto Active for the Mapping objects.
  • B. Go to Security, assign the DESIGNER profile to user A. Next, drag project P1 to user A and finally set View privileges to Active for the Mapping objects.
  • C. Go to Security, assign the NG DESIGNER profile to user A. Next, drag project P1 to user A and finally set View privileges to Active for the Project, Folder, and Mapping objects.
  • D. Go to Security, assign the DESIGNER profile to user A. Next, drag project P1 to user A and finally set View privileges to Active for the Project, Folder, and Mapping objects.
Mark Question:
Answer:

D

User Votes:
A
50%
B 1 votes
50%
C 1 votes
50%
D 3 votes
50%

Explanation:
(https://docs.oracle.com/cd/B12037_01/network.101/b10777/protdata.htm#1006312)

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

How do you provide a timeout value for an exception step? (Choose the best answer.)

  • A. by using a custom Groovy script
  • B. by using a variable
  • C. by using the Timeout filed
  • D. by using a Timeout knowledge module
Mark Question:
Answer:

B

User Votes:
A 1 votes
50%
B 3 votes
50%
C 2 votes
50%
D
50%

Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#CHDGFEGJ)

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

Identify the ODI tool used to write content into a file in a package. (Choose the best answer.)

  • A. OdiOutFile
  • B. OdiFileCopy
  • C. OdiFileMove
  • D. OdiInFile
Mark Question:
Answer:

A

User Votes:
A 3 votes
50%
B
50%
C
50%
D
50%

Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/app_tools.htm#ODIDG875)

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 10

Which statement is true about the need to have a topology with an intermediate server, in order to
use ODI correctly in a data warehouse project? (Choose the best answer.)

  • A. Data transformation must be distributed across several scalable nodes.
  • B. It is mandatory to have an intermediate server.
  • C. It is better to load data directly from sources into a data warehouse server.
  • D. It is mandatory to collect data directly from sources to a data warehouse server by using real time replication processes.
Mark Question:
Answer:

C

User Votes:
A
50%
B
50%
C 3 votes
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 11

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. OdiWaitForCDCData
  • C. OdiWaitForLogData
  • D. OdiWaitForTable
Mark Question:
Answer:

A

User Votes:
A 3 votes
50%
B
50%
C
50%
D
50%

Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/app_tools.htm#ODIDG967)

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 12

You have to loop through a Mapping step three times in a package by using variables. Identify the
correct variable data type to create the loop. (Choose the best answer.)

  • A. numeric
  • B. alphanumeric
  • C. date
  • D. text
Mark Question:
Answer:

A

User Votes:
A 3 votes
50%
B
50%
C
50%
D
50%

Explanation:
(https://www.packtpub.com/packtlib/book/Big-Data-and-
BusinessIntelligence/9781849681742/4/ch04lvl1sec31/Using%20variables%20to%20control%20loop
s%20i nside%20packages)

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 13

Which ODI Agent is deployed in Oracle WebLogic Server? (Choose the best answer.)

  • A. ODI Runtime Agent
  • B. ODI Standalone Agent
  • C. ODI JEE Agent
  • D. ODI Colocated Standalone Agent
Mark Question:
Answer:

C

User Votes:
A 1 votes
50%
B
50%
C 2 votes
50%
D
50%

Explanation:
(http://www.oracle.com/technetwork/middleware/data-integrator/overview/oraclediarchitecture-1-
129425.pdf)

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 14

You want to draw directly in the data flow all the details about how the different servers involved are
connected, in order to load a specific table by using ODI.
What must you do to accomplish this? (Choose the best answer.)

  • A. In the ODI Interface palette, choose the more convenient graphic objects to link the involved servers.
  • B. You need not draw directly in the data flow all the details about how the different servers involved are connected. ODI automatically designs the flow and how servers are connected.
  • C. You need not draw directly in the data flow all the details about how the different servers involved are connected. The code will be the black box generated directly by ODI.
  • D. You must draw directly in the data flow all the details about how the different servers involved are connected, and also specify with variables the passwords for connecting to the data contained in the servers.
Mark Question:
Answer:

B

User Votes:
A
50%
B 2 votes
50%
C
50%
D 2 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15

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. Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.
  • D. Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.
Mark Question:
Answer:

D

User Votes:
A 2 votes
50%
B
50%
C
50%
D 3 votes
50%

Explanation:
(http://www.oracle.com/us/products/middleware/data-integration/odi-
performanceguide-wp-2147067.pdf)

Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2