oracle 1z0-448 online test

Question 1

Identify two implementation strategies of changed data capture provided through ODI Knowledge
Modules. (Choose two.)

• A. extracting source data to flat files
• B. triggers
• C. Oracle GoldenGate
• D. before-and-after database image comparison

Answer:

B,C

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

• A. from the source database into flat files that are then loaded into the target database
• B. directly from the source database to the target database
• C. from the source database onto the server running the Agent and then into the target database
• D. from the source database into the machine running ODI Studio and then into the target database

Answer:

B

Explanation:
(https://docs.oracle.com/middleware/1213/odi/ODIUN.pdfpage 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.)

• 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.
• 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.
• 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.
• D. You need not consolidate yourown local metadata repositories, because ODI uses a centralized relational metadata repository that all the developers share.

Answer:

D

Question 4

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

• A. Use a dedicated schema such asODI_STAGING.
• B. UseTEMP.
• C. Use the same schema as the Data Schema.
• D. Use SYSTEM.

Answer:

A

Explanation:
(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.)

• A. Create a single Mapping with two Physical Designs: one for theinitialload and one for the incremental updates.
• 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.
• C. Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic.
• D. Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise.

Answer:

D

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

Question 6

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

• A. by using Opatch
• B. by using ODI Studio
• C. by using the import/export utilities
• D. by using Upgrade Assistant

Answer:

A

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

Question 7

You must run the same mapping concurrently while avoiding clashes of ODI temporary objects. How
must you implement this? (Choose the best answer.)

• A. Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names.
• B. Use variables in the Logical Design of the Mapping to create unique temporary object names.
• C. Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names.
• D. Select the Use Unique Temporary Object Names check box at the Physical Design level.

Answer:

D

Explanation:
(https://blogs.oracle.com/dataintegration/entry/odi_12c_parallel_target_table)

Question 8

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

• A. ERR$
• B. ERROR$
• C. ODI_ERR$
• D. E$

Answer:

D

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

Question 9

Your customer wants a project in ODI, which contains a user function, to translate commands with
different syntax for different technologies but with the same functionality.
How can you achieve this? (Choose the best answer.)

• A. The project must be explicitly mapped within an ODI mapping.
• B. A customize knowledge module is needed.
• C. An ODI procedure must be associated with it.
• D. It can be defined for every technology listed in the topology.

Answer:

D

Explanation:
(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/procedures.htm#ODIDG464)

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

• A. All distinct entries are processed.
• B. Only the latest entry is processed based on theJRN_DATEfield.
• C. Only the first entry is processed based on theJRN_DATEfield.
• D. A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.

Answer:

B

Explanation:
(http://www.ateam-oracle.com/understanding-the-odi-jkms-and-how-they-work-withoracle-
goldengate/)