1z0-448: Oracle Data Integrator 12c Essentials

How are the ODI repositories upgraded? (Choose the best answer.)

by using Opatch
by using ODI Studio
by using the import/export utilities
by using Upgrade Assistant

Correct answer: A

Explanation:

(http://odibeginnertutorials.blogspot.in/2013/12/odi-12c-installation-and-odi-12c.html)

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

Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names.
Use variables in the Logical Design of the Mapping to create unique temporary object names.
Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names.
Select the Use Unique Temporary Object Names check box at the Physical Design level.

Correct answer: D

Explanation:

(https://blogs.oracle.com/dataintegration/entry/odi_12c_parallel_target_table)

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

ERR$
ERROR$
ODI_ERR$
E$

Correct answer: D

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIKD/ckm.htm#ODIKD925)

Your customer wants a project in ODI, which contains a user function, to translate commands with different syntax for different technologies but with the same functionality.

How can you achieve this? (Choose the best answer.)

The project must be explicitly mapped within an ODI mapping.
A customize knowledge module is needed.
An ODI procedure must be associated with it.
It can be defined for every technology listed in the topology.

Correct answer: D

Explanation:

(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/procedures.htm#ODIDG464)

You want to ensure that the Physical Mapping Design cannot be modified even if the Logical Design of the Mapping is changed. What sequence of steps must you follow to achieve this? (Choose the best answer)

Go to the Physical tab, select the Fixed Design check box of the Physical Mapping Design.
Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design.
Go to the Physical tab, select the Read-only check box of the Physical Mapping Design.
Go to the Physical tab, deselect the Modify check box of the Physical Mapping Design.

Correct answer: C

Explanation:

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

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

It enables developers to execute most ODI operations through a Java program.
It can be used to embed ODI processes into another product.
It is used to load data between Teradata and Oracle.
It must be used by ETL developers to develop ODI processes.

Correct answer: AD

Explanation:

(https://foursconsultancy.wordpress.com/odi/oracle-data-integrator-12c-components/)

How do you reuse a configuration of OdiSendMail across multiple packages? (Choose the best answer.)

Add a sub-model to a package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.
Add an OdiSendMail step to a knowledge module.
Duplicate the OdiSendMail step into multiple packages.
Create a procedure with a step that uses OdiSendMail and add this procedure into multiple packages.

Correct answer: D

Explanation:

(https://blogs.perficient.com/oracle/2014/08/26/how-to-create-an-oracle-data-integrator-odi-package/)

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

transform only
load and transform
extract and load
extract and transform

Correct answer: A

Explanation:

(http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-realtime-access-2031152.pdf)

Identify two correct exception behavior values for Run Scenario steps in load plans. (Choose two.)

Run Exception and Restart
Run Exception and Continue
Run Exception and Ignore
Run Exception and Fail
Run Exception and Raise

Correct answer: CE

Explanation:

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

Which statement is true about defining more than one physical schema associated to the same data server? (Choose the best answer.)

ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.
It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.
It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.
It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.

Correct answer: C

Explanation:

(http://odiexperts.com/context-logical-and-physical-schema-how-does-it-work/)

Vendor:	Oracle
Exam Code:	1z0-448
Exam Name:	Oracle Data Integrator 12c Essentials
Date:	Nov 26, 2018
File Size:	34 KB
Downloads:	2

Download Oracle Data Integrator 12c Essentials.1z0-448.ActualTests.2018-11-26.49q.vcex

How to open VCEX files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown