We provide real 1Z0-448 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Oracle 1Z0-448 Exam quickly & easily. The 1Z0-448 PDF type is available for reading and printing. You can print more and practice many times. With the help of our Oracle 1Z0-448 dumps pdf and vce product and material, you can easily pass the 1Z0-448 exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-448 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-448 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-448-exam-dumps.html
Q31. 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/)
Q32. Which tables created by ODI contain error records?(Choose the best answer.)
A. ERR$
B. ERROR$
C. ODI_ERR$
D. E$
Answer: D
Explanation: (https://docs.oracle.com/middleware/1212/odi/ODIKD/ckm.htm#ODIKD925)
Q33. 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)
Q34. 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.)
A. from the source database into flat files that are then loaded into the target database
B. directly from the source database to the target database
C. from the source database onto the server running the Agent and then into the target database
D. from the source database into the machine running ODI Studio and then into the target database
Answer: B
Explanation: (https://docs.oracle.com/middleware/1213/odi/ODIUN.pdfpage 2-3)
Q35. What is the main benefit of using consistent set journalizing compared to simple journalizing?(Choose the best answer.)
A. Consistent set journalizing runs faster than simple journalizing.
B. Consistent set journalizing always uses Oracle GoldenGate.
C. Consistent set journalizing treats each data store individually.
D. Consistent set journalizing provides a guarantee of consistency of the captured changes.
Answer: D
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG272)
Q36. 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)
Q37. Identify the correct variable step type to use when assigning a value to a variable with an SQL query.(Choose the best answer.)
A. Evaluate Variable
B. Set Variable
C. Declare Variable
D. Refresh Variable
Answer: B
Q38. Which statement is true about theIKM SQL Control Append thatcreates an intermediate integration table prefixed with I$?(Choose the best answer.)
A. Theintermediate integration table prefixed with I$is required to determine which records must be inserted.
B. IfFlow Control is not necessary, an I$ table is not created.
C. Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.
D. Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.
Answer: D
Explanation: (http://www.oracle.com/us/products/middleware/data-integration/odi-performance-guide-wp-2147067.pdf)
Q39. Which two statements are true about ODI web-based components?(Choose two.)
A. ODI Console allows administrators to edit users’ information.
B. Enterprise Manager Cloud Control provides access to ODI data servers’ settings.
C. ODI sessions can be monitored in Enterprise Manager Cloud Control.
D. ODI Console provides access to project and mapping details.
Answer: A,D
Explanation: (http://www.oracle.com/technetwork/middleware/data-integrator/overview/oracledi-architecture-1-129425.pdf)
Q40. 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)
