01. A mapping must reject rows that violate the target datastore's constraints before they are written into the target table.
Which data-integrity option achieves this?
a) Static control.
b) Journalizing (CDC).
c) Alternate-key enforcement in the JDBC driver.
d) Flow control.
02. A model is configured for CONSISTENT-SET journalizing over several related datastores.
Which statements are true of consistent-set journalizing?
(Choose three.)
a) It keeps changes across a set of related datastores transactionally consistent when they are consumed.
b) Each datastore in the set is journalized in complete isolation from the others.
c) It removes the need to register any subscriber.
d) It requires the consuming workflow to use a Load Plan instead of a Package.
e) The order in which datastores are added to the set matters because it reflects their referential dependency.
f) It is the right choice when child rows must never be processed without their matching parent rows.
03. A production runtime host needs a Work Repository that can run imported Scenarios but must not let developers create or edit mappings on it.
Which type of work repository meets this requirement?
a) A Development work repository
b) An Execution work repository
c) A read-only Design work repository
d) A Master Repository
04. An administrator wants a lightweight ODI agent that runs as its own Java process rather than inside a managed server, yet whose start/stop lifecycle is managed centrally through the WebLogic Node Manager and Fusion Middleware Control.
Which agent type is described?
a) A JEE Agent
b) The internal agent built into ODI Studio
c) A Standalone Colocated Agent
d) A pure Standalone Agent
05. An organization wants a fully scripted release pipeline that regenerates Scenarios and deploys ODI objects across DEV, TEST, and PROD with no interactive GUI steps and no manual clicks.
Which ODI capability is the right foundation for this pipeline?
a) Manual export and import through the ODI Studio wizard for each target environment
b) Driving every release step through the ODI Console browser client
c) A single large Package that rebuilds the repositories each release
d) The ODI SDK, a Java API that builds and deploys objects in code
06. The data flow of an ODI 12c Mapping is complete and validated. You now need to change where one transformation runs, moving it from the staging area to the target, without altering the components, joins, or column mappings in the data flow.
Which part of the mapping do you edit?
a) The source Model
b) The physical design
c) The enclosing Package
d) The logical design
07. Which Knowledge Module type is applied to a model to set up and run Change Data Capture (journalizing) in ODI?
a) IKM
b) CKM
c) JKM
d) LKM
08. While designing an ODI 12c Mapping, you must ensure the target receives only one row for each unique combination of column values, dropping exact duplicate rows produced upstream in the data flow.
Which mapping component performs this?
a) A Filter component
b) An Aggregate component
c) A Sort component
d) A Distinct component
09. You are enabling Change Data Capture on a model so that a mapping can consume the changes.
Which actions are required parts of setting this up?
(Choose three.)
a) Switch the model to customized reverse-engineering.
b) Apply a JKM to the model.
c) Delete the I$ integration table before each run.
d) Apply a CKM to the target datastore to enable capture.
e) Register a subscriber and start the journal.
f) Add the datastore(s) to CDC within the model.
10. You create a relational model and populate its datastores automatically rather than by hand.
When you perform standard reverse-engineering, how does ODI retrieve the datastore metadata?
a) Through the technology's JDBC driver.
b) By executing a CKM against the source.
c) By running a customized RKM supplied with the model.
d) By reading the J$ journalizing tables.
The Oracle Data Integrator Essentials (1Z0-448) Sample Question Set is designed to help you prepare for the Oracle Data Integrator 12c Certified Implementation Specialist certification exam. To become familiar with the actual Oracle Certification exam environment, we suggest you try our Sample Oracle 1Z0-448 Certification Practice Exam.
