we provide Printable Oracle 1Z0-448 answers which are the best for clearing 1Z0-448 test, and to get certified by Oracle Oracle Data Integrator 12c Essentials. The 1Z0-448 Questions & Answers covers all the knowledge points of the real 1Z0-448 exam. Crack your Oracle 1Z0-448 Exam with latest dumps, guaranteed!
Q1. How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.)
A. The Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI.
B. The Knowledge Module must be customized only for aggregation functions.
C. The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.
D. The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.
Answer: D
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1625)
Q2. How can you define the order in which target data stores are loaded in a Mapping?(Choose the best answer.)
A. ODI automatically computes the load order based on the order on which the data stores were added to the Mapping.
B. You can use the Target Order field.
C. You can use the Target Load Order field.
D. You can use the Load Order field.
Answer: C
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1562)
Q3. Identify the name of the default WebLogic data source created for the Master Repository when setting up a JEE domain.(Choose the best answer.)
A. odiMasterRepository
B. MasterRepository
C. odimasterrepository
D. ODIMasterRepository
Answer: A
Explanation:
(https://docs.oracle.com/cd/E23943_01/install.1111/e16453/configure.htm#ODING303)
Q4. You are working with delimited flat files and want to enforce a primary key on a flat file by using a Check Knowledge Modules (CKM). However, you encounter an error.
Why did this happen?(Choose the best answer.)
A. It is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) queries.
B. It is not possible to enforce constraints on any technology.
C. It is only possible to forward-engineer it to the flat file definition.
D. It is possible to enforce a primary key on a flat file by using a CKM; however, you have to save it as a fixed file.
Answer: D
Explanation: (http://www.oracle.com/technetwork/middleware/data-integrator/learnmore/odi-best-practice-data-warehouse-168255.pdf)
Q5. 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
Q6. Which two objects can be dragged to a Mapping?(Choose two.)
A. Variables
B. Datastores
C. Knowledge Modules D. Reusable Mappings
Answer: B,D
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1560)
Q7. Which statement is correct about all expressions in a Mapping?(Choose the best answer.)
A. It is possible to set the execution location on source, staging area, or target.
B. All transformations are executed on the staging area.
C. Only the source and target servers can be used to execute expressions.
D. All expressions are executed on the source area.
Answer: A
Explanation:
(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/interfaces.htm#ODIDG1040)
Q8. How do youprovide a timeout value for an exception step?(Choose the best answer.)
A. by using a custom Groovy script
B. by using a variable
C. by using the Timeout filed
D. by using a Timeout knowledge module
Answer: B
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#CHDGFEGJ)
Q9. You want to deploy the generated code manually in a source or target server, before executing a mapping in ODI. How can you accomplish this?(Choose the best answer.)
A. You need not deploy the generated code manually in a source or target server. ODI Agent coordinates the execution of commands prepared for the job, and executes them on the correct server.
B. You must deploy the generated code manually in a source or target server. You must then compile the generated code and then double-check if the code prepared for the development server is the same as the code for the production server.
C. You need not deploy the generated code manually in a source or target server. ODI prepares a package for the development environment.
D. You must deploy the generated code manually in a source or target server. You must copy all procedures generated into the development, test, and production servers.
Answer: A
Explanation: (https://docs.oracle.com/middleware/1212/odi/ODIDG/intro.htm#ODIDG149)
Q10. 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-with-oracle-goldengate/)
Q11. 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
Q12. Identify three capabilities of load plans. (Choose three.)
A. restart from failed tasks
B. exception handling
C. native support for parallelism
D. support for Open Tools
E. restart of an agent
Answer: A,B,C
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1352) This link says “restartability” as one of options, so it can be either A or E, most likely its A
Q13. In a Mapping, you want to load the data by using a specific partition that is declared for a target table. Which statement is correct in this situation?(Choose the best answer)
A. It is not possible to use a specific partition.
B. Only ODI variables can be used to filter the target table loading.
C. An option in the Mapping can be used to declare partitions but an ODI variable must be used to evaluate the correct partition value.
D. An option in the Mapping can be used to declare the partition that has to be used for the loading.
Answer: D
Explanation:
(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/interfaces.htm#ODIDG1044)
Q14. You need totroubleshoot the execution of a Mapping and visualize the data contained in the ODI Staging tableswhile the Mapping is being executed. How must you proceed?(Choose the best answer.)
A. Start a Mapping in Debug mode and use breakpoints and the Get Data featureto query the data contained in the Staging tables.
B. Modifya Knowledge Module to dump the Staging tables’ data into log files for review.
C. Use variables in a Package to query the Staging tablesand evaluate the variable values.
D. Reverse engineer the Staging tables in a Modeland review the data contained in it.
Answer: D
Explanation: (https://docs.oracle.com/middleware/1212/odi/ODIKD/rkm.htm#ODIKD909)
Q15. Which product is included in ODI web-based components?(Choose the best answer.)
A. Oracle BPEL Process Manager
B. Oracle GoldenGate
C. ODI Console
D. Oracle WebLogic Server
Answer: C
Explanation: (http://www.oracle.com/technetwork/middleware/data-integrator/overview/oracledi-architecture-1-129425.pdf)