oracle 1z0-448 practice test

Oracle Data Integrator 12c Essentials Exam


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

C

Discussions

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

A

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

Discussions

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

D

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

Discussions

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

D

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

Discussions

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

B

Discussions

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

C

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

Discussions

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

D

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

Discussions

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

B

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

Discussions

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

A

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

Discussions

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

C

Discussions
To page 2