01. The source and target data stores are located on the same data server. Which statement is correct about the need for a Loading Knowledge Module to load the data on the target?
(Choose the best answer.)
a) Only an Integration KnowledgeModule single-technology is required.
b) Only an Integration Knowledge Module multitechnology is required.
c) A loading Knowledge Module multitechnology and an Integration Knowledge Module single-technology are required.
d) Both a Loading Knowledge Module multitechnology and an Integration Knowledge Module multitechnology are required.
02. A Mapping that uses CDC does not load any source data and you want to check the SNP_CDC_SET table to 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 the Work schema of the default schema defined for your source data server
c) the schema hosting the Staging Area
d) SYS
03. Identify two constraints that can be used to ensure uniqueness in ODI.
(Choose two.)
a) conditions
b) foreign keys
c) primary keys
d) alternate keys
e) not null
04. 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.
05. 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.
06. You need to deploy ODI JEE Components on WebLogic Server. Where should you deploy them?
(Choose the best answer.)
a) on the Coherence Server
b) on the Administration Server
c) on the Node Manager
d) on the Managed Server
07. You must monitor and manage a co-located stand-alone agent, Oracle DI Agent1, by using the ODI plug-in for Enterprise Manager CloudControl.
Which is the correct command to start this agent on Linux?
(Choose the best answer.)
a) ./agent.sh –NAME=OracleDIAgent1 –PORT=20910
b) ./agent.sh –NAME=OracleDIAgent1
c) ./startComponent.sh OracleDIAgent1
d) ./startComponent.sh OracleDIAgent1 –PORT=20910
08. 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 your own local metadata repositories, because ODI uses a centralized relational metadata repository that all the developers share.
09. How do you reuse a configuration of Odi Send Mail across multiple packages?
(Choose the best answer.)
a) Add a sub-model to a package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.
b) Add an OdiSendMail step to a knowledge module.
c) Duplicate the OdiSendMail step into multiple packages.
d) Create a procedure with a step that uses Odi Send Mail and add this procedure into multiple packages.
10. You need to create a package that automatically sends an alert to users in case the third step fails. Which option represents the steps to accomplish this?
(Choose the best answer.)
a) Add an OdiSendMail step to My Package and link the My Third Package step to it by using a green OK arrow.
b) Add an OdiSendMail step to My Package and link the My Third Package step to it by using a red KO arrow.
c) Add an OdiReadMail step to My Package and link the My Third Package step to it by using a red KO arrow.
d) Add an OdiSendMail step to My Package and link the My Last Package step to it by using a red KO arrow.
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 (OCS) certification exam. To become familiar with the actual Oracle Certification exam environment, we suggest you try our Sample Oracle 1Z0-448 Certification Practice Exam.