File Info
| Exam | Oracle Data Integrator 12c Essentials |
| Number | 1z0-448 |
| File Name | Oracle.1z0-448.CertDumps.2018-01-13.79q.vcex |
| Size | 71 KB |
| Posted | Jan 13, 2018 |
| Download | Oracle.1z0-448.CertDumps.2018-01-13.79q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.)
- extracting source data to flat files
- triggers
- Oracle GoldenGate
- 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.)
- from the source database into flat files that are then loaded into the target database
- directly from the source database to the target database
- from the source database onto the server running the Agent and then into the target database
- from the source database into the machine running ODI Studio and then into the target database
Correct answer: B
Explanation:
(https://docs.oracle.com/middleware/1213/odi/ODIUN.pdf page 2-3) (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.)
- 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.
- 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.
- 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.
- 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.)
- Use a dedicated schema such as ODI_STAGING.
- Use TEMP.
- Use the same schema as the Data Schema.
- Use SYSTEM.
Correct answer: A
Explanation:
(http://www.rittmanmead.com/2014/12/data-integration-tips-one-data-server/) (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.)
- Create a single Mapping with two Physical Designs: one for the initial load and one for the incremental updates.
- 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.
- Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic.
- 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
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1614) (https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1614)
Question 6
How are the ODI repositories upgraded? (Choose the best answer.)
- by using Opatch
- by using ODI Studio
- by using the import/export utilities
- by using Upgrade Assistant
Correct answer: A
Explanation:
(http://odibeginnertutorials.blogspot.in/2013/12/odi-12c-installation-and-odi-12c.html) (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.)
- Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names.
- Use variables in the Logical Design of the Mapping to create unique temporary object names.
- Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names.
- Select the Use Unique Temporary Object Names check box at the Physical Design level.
Correct answer: D
Explanation:
(https://blogs.oracle.com/dataintegration/entry/odi_12c_parallel_target_table) (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.)
- ERR$
- ERROR$
- ODI_ERR$
- E$
Correct answer: D
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIKD/ckm.htm#ODIKD925) (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.)
- The project must be explicitly mapped within an ODI mapping.
- A customize knowledge module is needed.
- An ODI procedure must be associated with it.
- It can be defined for every technology listed in the topology.
Correct answer: D
Explanation:
(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/procedures.htm#ODIDG464) (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.)
- All distinct entries are processed.
- Only the latest entry is processed based on the JRN_DATE field.
- Only the first entry is processed based on the JRN_DATE field.
- A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.
Correct answer: B
Explanation:
(http://www.ateam-oracle.com/understanding-the-odi-jkms-and-how-they-work-with-oracle-goldengate/) (http://www.ateam-oracle.com/understanding-the-odi-jkms-and-how-they-work-with-oracle-goldengate/)
