1Z0-448 | Renew 1Z0-448 Exam Study Guides With New Update Exam Questions
Q31. 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)
Q32. Which two statements are true about big data support in ODI?(Choose two.)
A. ODI uses its own transformation engine to process data in a Hadoop cluster.
B. ODI performs data transformations inside a Hadoop cluster.
C. ODI must perform data transformations outside Hadoop in an Oracle database.
D. ODI allows moving data in and out of a Hadoop cluster.
Answer: B,D
Explanation: (https://docs.oracle.com/middleware/1213/odi/develop-app-adapters/hadoop.htm#ODIAA193)
Q33. 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)
Q34. You want tooverride the code generated by ODI and provide a custom SQL statementas the source of a Mapping. How must you proceed?(Choose the best answer.)
A. Duplicate theIntegration Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping.
B. Duplicate the Check Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping.
C. In the Physical tab of a Mapping, click one of the source data stores, select the Extract Options, and enter the SQL statement in theCUSTOM_TEMPLATEfield.
D. Duplicate the Loading Knowledge module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping.
Answer: C
Explanation:
(https://blogs.oracle.com/dataintegration/entry/sessionizing_data_with_match_recognize)
Q35. Which statement is correct about choosing the join order in an ODI Mapping when defining a join?(Choose the best answer.)
A. This option is inherited from reverse engineering.
B. This option is always available.
C. You can never make this choice.
D. This option may be available only if the underlying technology supports it.
Answer: B
Explanation:
(https://blogs.oracle.com/dataintegration/entry/user_interface_and_terminology_changes1)
Q36. Which statement is true about defining more than one physical schema associated to the same data server?(Choose the best answer.)
A. ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.
B. It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.
C. It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.
D. It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.
Answer: C
Explanation: (http://odiexperts.com/context-logical-and-physical-schema-how-does-it-work/)
Q37. You create two mappings that both use the same changed data and run at different times. One runs every 15 minutes and the other runs once every day.
What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping?(Choose the best answer.)
A. Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change theJRN_SUBSCRIBERcolumn in the correspondingJ$table to keep the changed data present for the second Mapping.
B. Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.
C. Duplicate the source data store for each Mapping.
D. Create two distinct subscribers for each Mapping.
Answer: A
Explanation: (http://odiexperts.com/changed-data-capture-cdc/)
Q38. Youdesign a package with mappings that consume data from journalized data stores in Consistent Set CDC mode. Which option represents the steps that must be performed at the beginning of your package to accomplish this?(Choose the best answer.)
A. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Extend Window and Lock Subscriber check boxes.
B. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Unlock Subscriber and Purge Journal check boxes.
C. Add a model to the package, set the Model step to Journalizing Model, and select the Extend Window and Lock Subscriber check boxes.
D. Add a sub model to the package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.
Answer: C
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG287)
Q39. You are designing a load plan in which you must run Mappings A and B one after the other while running Mapping C at the same time. Which option represents the steps to accomplish this?(Choose the best answer.)
A. Add a parallel step, add three serial steps underneath it, then addAto the first parallel step, B to the second one, and C to the last one.
B. Create a scenario from the variable and add the scenario to the load plan to create a case step.
C. Add a parallel step, add two parallel steps underneath it, then add A and B tooneparallel step, and C to the other.
D. Add a parallel step, add two serial steps underneath it, then add A and B to one serial step, and C to the other.
Answer: C
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1356)
Q40. A. Add a new subscriber and edit the default Journalizing filter in your Mappings.
B. Drop the journal, add a new subscriber, start the journal, and edit the defaultJournalizing filter in your Mappings.
C. Drop the journal, remove existing subscribers, add a new subscriber, start the journal, and edit the default Journalizing filter in your Mappings.
D. Add a new subscriber, start the journal, and remove the default Journalizing filter in your Mappings.
Answer: B
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG285)