Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Home
Oracle
Oracle Data Integrator 12c Certified Implementation Spe
1z0-448
Oracle Data Integrator 12cEssentials Questions and Answers

Pass the Oracle Data Integrator 12c Certified Implementation Spe 1z0-448 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-448 Premium Access

View all detail and faqs for the 1z0-448 exam

Go to Exam

517 Students Passed

95% Average Score

97% Same Questions

Viewing page 1 out of 3 pages

Viewing questions 1-10 out of questions

Questions # 1:

You need to create a Model that works with multiple underlying technologies. How must you proceed? (Choose the best answer.)

Options:

This works only for Oracle and Informix.

This works only for Oracle and MySQL.

Create a new generic technology to support it.

Use the out-ofthe box Generic SQL technology.

Answer

Explanation

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

Questions # 2:

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

Options:

by using Opatch

by using ODI Studio

by using the import/export utilities

by using Upgrade Assistant

Answer

Explanation

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

Questions # 3:

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

Options:

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.

Answer

Explanation

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

Questions # 4:

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

Options:

numeric

alphanumeric

date

text

Answer

Explanation

(https://www.packtpub.com/packtlib/book/Big-Data-and-Business-Intelligence/9781849681742/4/ch04lvl1sec31/Using%20variables%20to%20control%20loops%20inside%20packages)

Questions # 5:

As part of your QA process you want to view code at the Step level in Operator. How must you proceed? (Choose the best answer.)

Options:

It is only possible to see code at the Session level.

It is only possible to view code at the Task level.

Depending on the audit level declared when running the execution, some of the generated code at the step level can be viewed.

All generated code can be viewed together at the step level, with a complete list of executed code.

Answer

Explanation

(https://docs.oracle.com/middleware/1212/odi/ODIDG/debugging.htm#ODIDG1641)

Questions # 6:

You create two mappings that both use the same changed data and run at different times. One runs every 15 minutes and the other runs once every day.

What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping? (Choose the best answer.)

Options:

Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change theJRN_SUBSCRIBERcolumn in the correspondingJ$table to keep the changed data present for the second Mapping.

Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.

Duplicate the source data store for each Mapping.

Create two distinct subscribers for each Mapping.

Answer

Explanation

(http://odiexperts.com/changed-data-capture-cdc/)

Questions # 7:

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

Options:

Run Exception and Restart

Run Exception and Continue

Run Exception and Ignore

Run Exception and Fail

Run Exception and Raise

Answer

C, E

Explanation

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

Questions # 8:

You need to deploy ODI JEE Components on WebLogic Server. Where should you deploy them? (Choose the best answer.)

Options:

on the Coherence Server

on the Administration Server

on the Node Manager

on the Managed Server

Answer

Explanation

(http://docs.oracle.com/cd/E25054_01/core.1111/e10106/odi.htm)

Questions # 9:

Your package logic requires you to retrieve the status of the previous package step into a variable. How must you implement this? (Choose the best answer.)

Options:

Create a variable, useodiRef.getPrevStepLog ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

Create a variable, useodiRef.getPrevInfo ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

Create a variable, useodiRef.getStep ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

Create a variable, useodiRef.getPrevStepStatus ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

Answer

Explanation

(https://docs.oracle.com/middleware/1212/odi/ODIKD/odiref_reference.htm#ODIKD1237)

Questions # 10:

If multiple changes occur on the source system but have not yet been processed by ODI, the J$ table contains entries for each change for the records sharing the same PK.

What happens at run time when a Mapping gets executed? (Choose the best answer.)