1Z0-448 | A Review Of Highest Quality 1Z0-448 examcollection
Q11. 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)
Q12. You are using a customized reverse knowledge module. You want the execution to be performed in only the development data environment. Which statement is true?(Choose the best answer.)
A. The execution should be done only on the development data environment, as long as the other environment is a mirrored copy.
B. Only the production environment can be used.
C. All environments linked to a logical schema can be used to reverse-engineer table structures.
D. Only a Java engine intermediate environment can be processed.
Answer: C
Explanation:
(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/create_rev_model.htm#ODID G227)
Q13. A Mapping that uses CDC does not load any source data and you want to check theSNP_CDC_SETtableto find out the current window ID.
In which database schema must you look to find this table?(Choose the best answer.)
A. the schema hosting the Work repository
B. the schema hosting theWork schema of the default schema defined for your source data server
C. the schema hosting the Staging Area
D. SYS
Answer: B
Explanation: (http://www.ateam-oracle.com/understanding-the-odi-jkms-and-how-they-work-with-oracle-goldengate/ )
Q14. You are defining a data store in ODI metadata and want toadd a primary key even if it does not physically exist on the related database catalog.
How can you accomplish this?(Choose the best answer.)
A. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraintson the data store.
B. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints to the data store diagram.
C. You cannot add a primary key if it does not physically exist on the related database catalog. You can flag only non-null conditions to be checked.
D. You cannot add a primary key if it does not physically exist on therelated database catalog. You can reverse engineer only the existing constraints.
Answer: D
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIKM/teradata.htm#ODIKM1061)
Q15. The workflow you are designing requires checking to see whether there are records available in a source table before doing anything. Which ODI tool must you use to implement this?(Choose the best answer.)
A. OdiWaitForData
B. OdiWaitForCDCData
C. OdiWaitForLogData
D. OdiWaitForTable
Answer: A
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/app_tools.htm#ODIDG967)
Q16. When Oracle Data Integrator (ODI) and Oracle GoldenGate are used together, which option represents the phases of an ELT process that Oracle GoldenGate performs?(Choose the best answer.)
A. transform only
B. load and transform
C. extract and load
D. extract and transform
Answer: A
Explanation: (http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-realtime-access-2031152.pdf)
Q17. How are the domains of ODI Agents configured?(Choose the best answer.)
A. by using Upgrade Assistant
B. by using ODI Studio
C. by using Domain Creation Assistant
D. by using Configuration Wizard
Answer: D
Explanation:
(https://docs.oracle.com/middleware/1213/core/ODING/configure_jee.htm#ODING291)
Q18. You are designing a package in which you want a certain step to not appear in the ODI logs. How do you accomplish this?(Choose the best answer.)
A. Right-click the step in Package Editor and select the No Logging menu item.
B. Modify Operator Navigator settings to disable that step from being displayed.
C. In Package Editor, click the step, go to the Advanced tab, and set Log Steps in the journal to Never.
D. Periodically schedule a scenario that usesOdiPurgeLogto remove that step from the ODI logs.
Answer: C
Q19. 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)
Q20. Which two statements are true about using ODI and Oracle GoldenGate together?(Choose two.)
A. Oracle GoldenGate primarily performs aggregations for ODI.
B. Oracle GoldenGate and ODI are used together primarily for running weekly batch jobs.
C. Oracle GoldenGate provides non-invasive changed data capture capabilities to ODI.
D. ODI starts and stops Oracle GoldenGate processes automatically during a Mapping execution.
E. ODI and Oracle GoldenGate enable real-time business intelligence.
Answer: A,E
Explanation: (http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-realtime-access-2031152.pdf)