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

  • 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 #1
Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.)
  1. A
    extracting source data to flat files
  2. B
    triggers
  3. C
    Oracle GoldenGate
  4. D
    before-and-after database image comparison

Correct Answer:
BC

Question #2
How does the data flow when moving records between two servers by using Database Links and an Agent installed on a middle-tier server? (Choose the best answer.)
  1. A
    from the source database into flat files that are then loaded into the target database
  2. B
    directly from the source database to the target database
  3. C
    from the source database onto the server running the Agent and then into the target database
  4. D
    from the source database into the machine running ODI Studio and then into the target database

Correct Answer:
B
(https://docs.oracle.com/middleware/1213/odi/ODIUN.pdf page 2-3)

Question #3
You are a project developer using ODI and want to consolidate your own local metadata repositories. Identify the true statement. (Choose the best answer.)
  1. A
    You must consolidate your own local metadata repositories. The local metadata must be transmitted via ftp and synchronized with a dedicated proprietary engine, creating a common metadata model for all the developers.
  2. B
    You must consolidate your own local metadata repositories. You have to invoke a dedicated web service to synchronize the metadata by using Oracle Service Bus.
  3. C
    You need not consolidate your own local metadata repositories, because the ODI proprietary metadata server allows all developers to share the common metadata of a specific project.
  4. D
    You need not consolidate your own local metadata repositories, because ODI uses a centralized relational metadata repository that all the developers share.

Correct Answer:
D

Question #4
How should you define the Work Schema of a Physical Schema? (Choose the best answer.)
  1. A
    Use a dedicated schema such as ODI_STAGING.
  2. B
    Use TEMP.
  3. C
    Use the same schema as the Data Schema.
  4. D
    Use SYSTEM.

Correct Answer:
A
(http://www.rittmanmead.com/2014/12/data-integration-tips-one-data-server/)

Question #5
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 the initial load 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.

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

Next Questions

All Pages