Oracle Oracle Certifications 1Z0-448 Questions & Answers

• Question 21:

  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

  Correct Answer: D

  (https://docs.oracle.com/middleware/1213/core/ODING/configure_jee.htm#ODING291)

• Question 22:

  You want to deploy the generated code manually in a source or target server, before executing a mapping in ODI.

  How can you accomplish this? (Choose the best answer.)

  A. You need not deploy the generated code manually in a source or target server. ODI Agent coordinates the execution of commands prepared for the job, and executes them on the correct server.

  B. You must deploy the generated code manually in a source or target server. You must then compile the generated code and then double-check if the code prepared for the development server is the same as the code for the production server.

  C. You need not deploy the generated code manually in a source or target server. ODI prepares a package for the development environment.

  D. You must deploy the generated code manually in a source or target server. You must copy all procedures generated into the development, test, and production servers.

  Correct Answer: A

  (https://docs.oracle.com/middleware/1212/odi/ODIDG/intro.htm#ODIDG149)

• Question 23:

  What must you set on the Definition tab of a variable to protect the variable value from being displayed in the Operator logs? (Choose the best answer.)

  A. Select the Secure Value check box.

  B. Select the Hide Value check box.

  C. Set the Keep History field to No History.

  D. Leave the Default Value field empty.

  Correct Answer: C

  (https://docs.oracle.com/middleware/1212/odi/ODIDG/procedures.htm#ODIDG464)

• Question 24:

  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.

  Correct Answer: D

  (https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG272)

• Question 25:

  You are setting up the topology for an infrastructure with three different environments: Dev, QA, and Prod. How must you create Logical Schemas? (Choose the best answer.)

  A. Create one Logical Schema per Physical Schema.

  B. Create one Logical Schema per Physical Schema that stores the same type of data.

  C. Create one Logical Schema per Data Server.

  D. Create one Logical Schema per Context.

  Correct Answer: D

  (https://docs.oracle.com/middleware/1213/odi/develop/setup_topology.htm#ODIDG174)

• Question 26:

  Your project requires a loop through the same package logic 24/7. You must be able to purge those executions when required.

  How do you accomplish this? (Choose the best answer.)

  A. Link the last step of the package to its first step to create an infinite loop.

  B. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save and regenerate this scenario.

  C. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save.

  D. Drag the package to the last step in the package, run it asynchronously, and then save.

  Correct Answer: B

  (http://www.rittmanmead.com/2015/04/di-tips-odi-convert-to-flow/)

• Question 27:

  You are designing a Mapping. How are target and source tables defined? (Choose the best answer.)

  A. Their definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database.

  B. Their definition is imported with a reverse-engineering process directly from databases and other sources.

  C. Forevery load the definition of the tables used, their columns and constraints must be manually built.

  D. An external engine must be run to describe what metadata is needed for a Mapping.

  Correct Answer: A

  (https://docs.oracle.com/middleware/1212/odi/ODIDG/create_rev_model.htm#ODIDG234)

• Question 28:

  Updates have been made to Mappings in a package.

  What must you do to ensure that the Production team runs a scenario that contains those updates while preserving the existing scenario's schedule? (Choose the best answer.)

  A. Regenerate the existing scenario.

  B. Nothing, the existing scenario will automaticallybe updated.

  C. Generate a new scenario and create a new schedule.

  D. Generate a new scenario and attach the previous scenario's schedule to it.

  Correct Answer: A

  (https://docs.oracle.com/middleware/1212/odi/ODIDG/scenarios.htm#ODIDG470)

• Question 29:

  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

  Correct Answer: BE

  (https://docs.oracle.com/middleware/1212/odi/ODIDG/intro.htm#ODIDG113)

• Question 30:

  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

  Correct Answer: D

  (http://docs.oracle.com/cd/E25054_01/core.1111/e10106/odi.htm)