Question No. 1

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

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

Afrom the source database into flat files that are then loaded into the target database

Bdirectly from the source database to the target database

Cfrom the source database onto the server running the Agent and then into the target database

Dfrom the source database into the machine running ODI Studio and then into the target database

Show Answer

Correct Answer: B

(https://docs.oracle.com/middleware/1213/odi/ODIUN.pdfpage 2-3)

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

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

BYou must consolidate your own local metadata repositories. You have to invoke a dedicated web service to synchronize the metadata by using Oracle Service Bus.

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

DYou need not consolidate yourown local metadata repositories, because ODI uses a centralized relational metadata repository that all the developers share.

Show Answer

Correct Answer: D

Question No. 4

How should you define the Work Schema of a Physical Schema? (Choose the best answer.)

AUse a dedicated schema such asODI_STAGING.

BUseTEMP.

CUse the same schema as the Data Schema.

DUse SYSTEM.

Show Answer

Correct Answer: A

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

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

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

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

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

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

Show Answer

Correct Answer: D

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

Free Oracle 1Z0-448 Exam Actual Questions

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