Skip to main content

1Z0-448 Real Exam Questions

Oracle Data Integrator 12c Essentials

79 questions available · Page 1 of 8

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Multiple choice

Which two statements are true about using ODI and Oracle GoldenGate together? (Choose two.)

  1. A

    Oracle GoldenGate primarily performs aggregations for ODI.

  2. B

    Oracle GoldenGate and ODI are used together primarily for running weekly batch jobs.

  3. C

    Oracle GoldenGate provides non-invasive changed data capture capabilities to ODI.

  4. D

    ODI starts and stops Oracle GoldenGate processes automatically during a Mapping execution.

  5. E

    ODI and Oracle GoldenGate enable real-time business intelligence.

Show answer and explanation

Correct answers: A, E

Explanation

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

Question 2 Single choice

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

  1. A

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

  2. B

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

  3. C

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

  4. D

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

Show answer and explanation

Correct answer: A

Explanation

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

Question 3 Single choice

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

  1. A

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

  2. B

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

  3. C

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

  4. D

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

Show answer and explanation

Correct answer: B

Explanation

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

Question 4 Single choice

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

  1. A

    ERR$

  2. B

    ERROR$

  3. C

    ODI_ERR$

  4. D

    E$

Show answer and explanation

Correct answer: D

Explanation

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

Question 5 Single choice

You have been tasked with designing a Mapping that must perform an initial load and incremental updates using the same transformation logic.

How should you proceed? (Choose the best answer.)

  1. A

    Create a single Mapping with two Physical Designs: one for theinitialload and one for the incremental updates.

  2. B

    Create a single Mapping with a single Physical Design and modify it appropriately when an initial load is required or when an incremental update is required.

  3. C

    Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic.

  4. D

    Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise.

Show answer and explanation

Correct answer: D

Explanation

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

Question 6 Single choice

You must send the same message in multiple packages to several email addresses stored in the same database table.

How do you accomplish this by using a reusable package step? (Choose the best answer.)

  1. A

    Create a procedure and add two tasks. The first one must have a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and the second must have a Command on Target that usesOdiSendMailto send the email by using the bind variable defined in the first task.

  2. B

    Createa Knowledge Module. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Command on Target that usesOdiSendMailto send the email using the bind variable defined in the Command on Source.

  3. C

    Create a counter variable that gets the total number of email addresses stored in the database table.
    Next, create another variable that selects the email addresses from the database table.
    Then, create a loop in the packages by using the variables and anOdiSendMailstep.

  4. D

    Create a procedure. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Commandon Targetthat usesOdiSendMailto send the email using the bind variable defined in the Command on Source.

Show answer and explanation

Correct answer: B

Explanation

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

Question 7 Single choice

Updates have been made to Mappings in a package.

What must you do to ensure that the Production team runs a scenario that contains those updates while preserving the existing scenario's schedule? (Choose the best answer.)

  1. A

    Regenerate the existing scenario.

  2. B

    Nothing, the existing scenario will automaticallybe updated.

  3. C

    Generate a new scenario and create a new schedule.

  4. D

    Generate a new scenario and attach the previous scenario's schedule to it.

Show answer and explanation

Correct answer: A

Explanation

(
https://docs.oracle.com/middleware/1212/odi/ODIDG/scenarios.htm#ODIDG470)

Question 8 Single choice

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

  1. A

    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.

  2. B

    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.

  3. C

    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.

  4. D

    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.

Show answer and explanation

Correct answer: A

Explanation

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

Question 9 Single choice

You must monitor and manage a co-located stand-alone agent, OracleDIAgent1, by using the ODI plug-in for Enterprise Manager Cloud Control.

Which is the correct command to start this agent on Linux? (Choose the best answer.)

  1. A

    ./agent.sh -NAME=OracleDIAgent1 -PORT=20910

  2. B

    ./agent.sh -NAME=OracleDIAgent1

  3. C

    ./startComponent.sh OracleDIAgent1

  4. D

    ./startComponent.sh OracleDIAgent1 -PORT=20910

Show answer and explanation

Correct answer: A

Explanation

(
https://community.oracle.com/thread/3780742?start=0&tstart=0)

Question 10 Multiple choice

Which two statements are true about big data support in ODI? (Choose two.)

  1. A

    ODI uses its own transformation engine to process data in a Hadoop cluster.

  2. B

    ODI performs data transformations inside a Hadoop cluster.

  3. C

    ODI must perform data transformations outside Hadoop in an Oracle database.

  4. D

    ODI allows moving data in and out of a Hadoop cluster.

Show answer and explanation

Correct answers: B, D

Explanation

(
https://docs.oracle.com/middleware/1213/odi/develop-app-adapters/hadoop.htm#ODIAA193)