1Z0-448 Free Practice Test

Identify the ODI tool used to write content into a file in a package.(Choose the best answer.)

1. A. OdiOutFile
2. B. OdiFileCopy
3. C. OdiFileMove
4. D. OdiInFile

Correct Answer: A

(https://docs.oracle.com/middleware/1212/odi/ODIDG/app_tools.htm#ODIDG875)

You are designing a Mapping. How are target and source tables defined?(Choose the best answer.)

1. A. Their definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the databas
2. B. Their definition is imported with a reverse-engineering process directly from databases and other source
3. C. Forevery load the definition of the tables used, their columns and constraints must be manually buil
4. D. An external engine must be run to describe what metadata is needed for a Mappin

Correct Answer: A

(https://docs.oracle.com/middleware/1212/odi/ODIDG/create_rev_model.htm#ODIDG234)

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 repositorie
2. B. The local metadata must be transmitted via ftp and synchronized with a dedicated proprietary engine, creating a common metadata model for all the developer
3. C. You must consolidate your own local metadata repositorie
4. D. You have to invoke a dedicated web service to synchronize the metadata by using Oracle Service Bu
5. E. 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 projec
6. F. You need not consolidate yourown local metadata repositories, because ODI uses a centralized relational metadata repository that all the developers shar

Correct Answer: D

Which statement is correct about all expressions in a Mapping?(Choose the best answer.)

1. A. It is possible to set the execution location on source, staging area, or targe
2. B. All transformations are executed on the staging are
3. C. Only the source and target servers can be used to execute expression
4. D. All expressions are executed on the source are

Correct Answer: A

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

You need to create a Model that works with multiple underlying technologies. How must you proceed?(Choose the best answer.)

1. A. This works only for Oracle and Informi
2. B. This works only for Oracle and MySQ
3. C. Create a new generic technology to support i
4. D. Use the out-ofthe box Generic SQL technolog

Correct Answer: D

(https://docs.oracle.com/middleware/1212/odi/ODIDG/projects.htm#ODIDG326)