Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-448

Oracle 1z0-448 Exam Practice Questions (P. 3)

  • Full Access (79 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #11
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)
  1. A
    Go to the Physical tab, select the Fixed Design check box of the Physical Mapping Design.
  2. B
    Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design.
  3. C
    Go to the Physical tab, select the Read-only check box of the Physical Mapping Design.
  4. D
    Go to the Physical tab, deselect the Modify check box of the Physical Mapping Design.

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

Question #12
Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)? (Choose two.)
  1. A
    It enables developers to execute most ODI operations through a Java program.
  2. B
    It can be used to embed ODI processes into another product.
  3. C
    It is used to load data between Teradata and Oracle.
  4. D
    It must be used by ETL developers to develop ODI processes.

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

Question #13
How do you reuse a configuration of OdiSendMail across multiple packages? (Choose the best answer.)
  1. A
    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.
  2. B
    Add an OdiSendMail step to a knowledge module.
  3. C
    Duplicate the OdiSendMail step into multiple packages.
  4. D
    Create a procedure with a step that uses OdiSendMail and add this procedure into multiple packages.

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

Question #14
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.)
  1. A
    transform only
  2. B
    load and transform
  3. C
    extract and load
  4. D
    extract and transform

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

Question #15
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.)
  1. A
    Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change the JRN_SUBSCRIBER column in the corresponding J$ table to keep the changed data present for the second Mapping.
  2. B
    Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.
  3. C
    Duplicate the source data store for each Mapping.
  4. D
    Create two distinct subscribers for each Mapping.

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

Previous Questions Next Questions

All Pages