Oracle Data Integrator 12cEssentials v7.0 (1z0-448)

Page:    1 / 6   
Total 79 questions

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.


Answer : A

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

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


Answer : D

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

You need to reverse engineer a flat file that contains multiple record formats. How must you proceed?(Choose the best answer.)

  • A. Create a Data Server by using the File technology and specify the various record formats while reverse engineering the file.
  • B. Create a Data Server by using the XML technology, create annXSDfile by using the Native Format Builder, and then reverse engineer it in a Model.
  • C. Create a Data Server by using theFile technology, create annXSDfile by using the Native Format Builder, and then reverse engineer it in a Model.
  • D. Create a Data Server by using the Complex File technology, create annXSDfile by using the NativeFormat Builder, and then reverse engineer it in aModel.


Answer : D

Explanation: (https://blogs.oracle.com/dataintegration/entry/oracle_data_integrator_11_1)

You want tooverride the code generated by ODI and provide a custom SQL statementas the source of a Mapping. How must you proceed?(Choose the best answer.)

  • A. Duplicate theIntegration Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping.
  • B. Duplicate the Check Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping.
  • C. In the Physical tab of a Mapping, click one of the source data stores, select the Extract Options, and enter the SQL statement in theCUSTOM_TEMPLATEfield.
  • D. Duplicate the Loading Knowledge module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping.


Answer : C

Explanation:
(https://blogs.oracle.com/dataintegration/entry/sessionizing_data_with_match_recognize)

You are working on notifications in a package and you must send an email containing an error message incase a Package step fails.
WhichodiRefmethod do you use to access the error message?(Choose the best answer.)

  • A. odiRef.getSession()
  • B. odiRef.getInfo()
  • C. odiRef.getPrevStepLog()
  • D. odiRef.getStep()


Answer : B

Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIKD/odiref_reference.htm#ODIKD1147)

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)

  • A. Add a new subscriber and edit the default Journalizing filter in your Mappings.
  • B. Drop the journal, add a new subscriber, start the journal, and edit the defaultJournalizing filter in your Mappings.
  • C. Drop the journal, remove existing subscribers, add a new subscriber, start the journal, and edit the default Journalizing filter in your Mappings.
  • D. Add a new subscriber, start the journal, and remove the default Journalizing filter in your Mappings.


Answer : B

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

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)

You must monitor and managea co-located stand-alone agent,OracleDIAgent1, 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


Answer : A

Explanation: (https://community.oracle.com/thread/3780742?start=0&tstart=0)

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)

In a Mapping, you want to load the data by using a specific partition that is declared for a target table. Which statement is correct in this situation?(Choose the best answer)

  • A. It is not possible to use a specific partition.
  • B. Only ODI variables can be used to filter the target table loading.
  • C. An option in the Mapping can be used to declare partitions but an ODI variable must be used to evaluate the correct partition value.
  • D. An option in the Mapping can be used to declare the partition that has to be used for the loading.


Answer : D

Explanation:
(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/interfaces.htm#ODIDG1044)

You want to ensure that thePhysical Mapping Design cannot be modifiedeven if the Logical
Design of the Mapping is changed. What sequence of steps must you follow to achieve this?(Choosethe best answer)

  • A. Go to the Physical tab, select theFixedDesign check boxof the Physical Mapping Design.
  • B. Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design.
  • C. Go to the Physical tab, select the Read-only check box of the Physical Mapping Design.
  • D. Go to the Physical tab, deselect theModify check boxof the Physical Mapping Design.


Answer : C

Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1560)

Which is the correct statement about the contents of Master repositories?(Choose the best answer.)

  • A. They contain data model and security information.
  • B. They contain security and topology information.
  • C. They contain project and topology information.
  • D. They contain project and security information.


Answer : B

Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/admin_reps.htm#ODIDG155)

How are the ODI repositories upgraded?(Choose the best answer.)

  • A. by using Opatch
  • B. by using ODI Studio
  • C. by using the import/export utilities
  • D. by using Upgrade Assistant


Answer : A

Explanation: (http://odibeginnertutorials.blogspot.in/2013/12/odi-12c-installation-and-odi-
12c.html)

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

Page:    1 / 6   
Total 79 questions