Oracle Data Integrator 11g Essentials v7.0 (1z0-482)

Page:    1 / 5   
Total 76 questions

In ODI, is it possible to reverse a COBOL flat file using a Copybook definition?

  • A. Yes, only using the file driver
  • B. Yes, using the file and complex file drivers
  • C. Yes, but only if the source file is an EBCDIC file.
  • D. No, you need to manually add the columns definition in all the cases.


Answer : A

Reference:
http://docs.oracle.com/cd/E28280_01/integrate.1111/e12643/create_rev_model.htm
(5.3.2.3)

In ODI Operator, is it possible to view code in the second level (the step) represented?

  • A. No, it is only possible to see code in the first higher level (the session) represented.
  • B. Yes, all generated code can be viewed together in the step-level, with a complete list of executed code.
  • C. Yes, depending on the auditlevel declared when running the execution, some of the generated code at the step-level can be viewed.
  • D. No, it is possible to view code in the thud level(the tasklevel)represented.


Answer : D

You have to load three tables A, B, and C in parallel, wait for them to be loaded, and then load a fourth table D. Which steps do you have to go through in order to do this?

  • A. Generate three scenarios to load A, B, and C, add them to a Package, set their Synchronization mode to Asynchronous, use an OdiWaitForChildSession step before adding an Interface to load D
  • B. Generate three scenarios to load A, B, and C, add them to a package, set their Synchronization mode to Synchronous, use an OdiWaitForChildSession step before adding an interface to load D
  • C. Add three Interfaces to load A, B, and C to a package, use an OdiWaitForChildSession step before adding another Interface to load D
  • D. Generate three scenarios to load A, B, and C, add them to a package, use an OdiWaitForChildSession step before adding an Interface to load D


Answer : A

In Topology, can a query be defined to retrieve native database sequences?

  • A. Yes, in the technology details in the Topology submodule, there is a tab that defines queries for specific database elements.
  • B. Yes, but you need to specify an option in the knowledge modules of the mapping using sequences.
  • C. No, only the timestamp definition can be set in Topology.
  • D. No, the query for native sequences is defined in ODI Data Models, under ODJ Studio Designer.


Answer : A

Identify two true statements regarding the ODI web-based components.

  • A. Enterprise Manager Fusion Middleware Control Console provides access to ODI dataservers settings.
  • B. ODI Console allows administrators to edit users' information.
  • C. ODI sessions can be monitored in Enterprise Manager Fusion Middleware Control Console.
  • D. ODI Console provides access to Project and Interface details.


Answer : C,D

Explanation:
http://docs.oracle.com/cd/E17904_01/integrate.1111/e12643/odi_console.htm

In an ODI interface, is it mandatory to use a join to describe a lookup?

  • A. Yes,there are not many other graphical Objects to describe a lookup.
  • B. Yes, it is not possible to set anything other than a join in an ODI Interface.
  • C. No, there is a graphical object dedicated to set a lookup in the source area of an interface.
  • D. No, you can use variables in ODI to declare lookups.


Answer : C

Select two correct statements about Results Books.

  • A. A Results Book can contain tabs containing the output from several different EDQ processor steps.
  • B. Results Books always link to the latest version of a process.
  • C. Results Books can be exported to a multlsheet MS Excel Workbook.
  • D. A Results Book page will always look the same as the output of the processor it is linked to,
  • E. ResultsBooks can combine pages from many projects.


Answer : A,C

Explanation: http://www.oracle.com/webfolder/technetwork/data- quality/edqhelp/Content/concepts/results_books.htm

Identify the right variable step type to use when assigning a value to a variable with a SQL query.

  • A. Refresh Variable
  • B. Declare Variable
  • C. Set Variable
  • D. Evaluate Variable


Answer : C

Reference: http://docs.oracle.com/cd/E15586_01/integrate.1111/e12643/procedures.htm
(12.2.3.1)
Set Variable is the step type to assign the value. Refresh Variable is used to calculate the value from a sql query.

Identify two Change Data Capture implementation strategies provided through the ODI knowledge modules.

  • A. Triggers
  • B. Oracle GoldenGate
  • C. Extract source data to flat files
  • D. Before and after database image comparison


Answer : A,B

Identify two true statements regarding the ODI SDK.

  • A. The ODI SDK is used to load data between Teradata and Oracle.
  • B. The ODI SDK can be used to embed ODI processes into another product.
  • C. The ODI SDK is required to be used by ETL developers in order to develop ODI processes,
  • D. The ODI SDK allows developers to execute most ODI operations through a Java program.


Answer : A,D

To use ODI efficiently in a Data Warehouse project is it necessary to have a topology with an intermediate transformation server?

  • A. It is mandatory to have an intermediate server.
  • B. It is better to load data directly from sources into a data warehouse server.
  • C. Data transformation should be distributed across several scalable nodes.
  • D. It is mandatory to collect data directly from sources into a data warehouse server using real time replication processes.


Answer : D

Is it possible to manage five metadata work repositories together with ODI and a single master repository in order to have a software lifecycle generation respecting the best practices that my company uses?

  • A. No, every repository needs as mandatory a related separated master repository.
  • B. No, unless I also have live data environments because it is mandatory that the production work repository is installed on the data production server, the test work repository on the test data server and so on.
  • C. Yes, it is possible to create separate metadata environments with work repositories, that define for instance, a current level of development work repository, next level development, maintenance, production, and so on.
  • D. Yes, but also install a mandatory agent for every work repository and compile all its Java archives separately.


Answer : C

You are running a Scenario in a Load Plan using a Run Scenario step. This scenario contains the Interfaces. In case of failure in this Scenario, you would like to restart the
Interface that failed beginning. Which Restart Type option do you need to pick for the Run
Scenario step?

  • A. Restart from new session
  • B. Restart from failed step
  • C. Restart from failed task
  • D. Restart from failure


Answer : B

Explanation:
http://docs.oracle.com/cd/E38317_01/doc.11117/e37987/manageloadplans.htm#CIHJCBH

J -

Where can users edit scenarios in ODI?

  • A. Designer Navigator
  • B. Operator Navigator
  • C. Command line
  • D. Nowhere, scenarios cannot be edited


Answer : D

Explanation: The scenario code (the language generated) is frozen, and all subsequent modifications of the components which contributed to creating it will not change it in any way http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/scenarios.htm

A step in the Package you are designing should not appear in the ODI logs. How do you implement this?

  • A. Schedule periodically a scenario that uses OdiPurgeLog to remove those steps from the ODI logs
  • B. In the Package Editor, click the step, go to the Advanced tab, and set Log Steps in the Journal to Never
  • C. Modify the Operator Navigator settings to disable that step from being displayed
  • D. Right-click the step in Package Editor and select the No Logging menu item


Answer : B

Page:    1 / 5   
Total 76 questions