Question No. 1

You are working with delimited flat files and want to enforce a primary key on a flat file by using a Check Knowledge Modules (CKM). However, you encounter an error.

Why did this happen? (Choose the best answer.)

AIt is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) queries.

BIt is not possible to enforce constraints on any technology.

CIt is only possible to forward-engineer it to the flat file definition.

DIt is possible to enforce a primary key on a flat file by using a CKM; however, you have to save it as a fixed file.

Show Answer

Correct Answer: D

(http://www.oracle.com/technetwork/middleware/data-integrator/learnmore/odi-bestpractice-data-warehouse-168255.pdf)

Question No. 2

You must modify the order in which data stores are being journalized in a model. What sequence of steps do you follow to achieve this? (Choose the best answer.)

AOpenthe model, go to the Journalizing tab, and modify the order there.

BRight-click Datastore, select Changed Data Capture, and then select Order.

COpen the model, go to the Journalized tables tab, and modify the order there.

DOpen the data stores, go to the Journalizing tab, and modify the order there.

Show Answer

Correct Answer: B

(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG271)

Question No. 3

You are designing a Mapping. How are target and source tables defined? (Choose the best answer.)

ATheir definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database.

BTheir definition is imported with a reverse-engineering process directly from databases and other sources.

CForevery load the definition of the tables used, their columns and constraints must be manually built.

DAn external engine must be run to describe what metadata is needed for a Mapping.

Show Answer

Correct Answer: A

(https://docs.oracle.com/middleware/1212/odi/ODIDG/create_rev_model.htm#ODIDG234)

Question No. 4

Identify two benefits that are unique to ODI JEE Agents. (Choose two.)

Ahigh availability

Bminimal footprint

Caccess to WebLogic connection pools

Dmanagement in Enterprise Manager Cloud Control

Show Answer

Correct Answer: A, D

(http://www.ateam-oracle.com/odi-agents-standalone-jee-and-colocated/)

Question No. 5

Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.)

Aextracting source data to flat files

Btriggers

COracle GoldenGate

Dbefore-and-after database image comparison

Show Answer

Correct Answer: B, C

Free Oracle 1Z0-448 Exam Actual Questions

The questions for 1Z0-448 were last updated On Dec 20, 2024