← Back to exam page

C2090-552 – IBM InfoSphere Optim for Distributed Systems - V7.3.1

Loading demo links...

Showing 1–3 of 10 questions

Question 1 (Volume B)

An Archive File Collection is a list of Archive Files that are treated as a single data source by ODM. Which two statements are true regarding Archive Collections? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Use the Collections tab on the Archive Request Editor to specify the collection(s) in which the Archive File should be added automatically.
  • ○

    An Archive File may belong to multiple Archive Collections, and an Archive Collection may contain multiple Archive Files.
  • ○

    Archive Files contained within a collection do not need to be registered in the Archive Directory.
  • ○

    ODM, by default, processes the Archive Files in the collections in ascending date order based on the dates the Archive Files were created.
  • ○

    An Archive File containing multiple tables with the same names and creator ids, but with different DB Aliases, may be stored in an Archive Collection.
Question 2 (Volume B)

A data-driven relationship exists when a row in the parent table is related to rows in one of several child tables on the basis of the value in a particular column. Which two of the following can you use to define a data-driven relationship? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    String literals or hexadecimal literals
  • ○

    SUBSTR, RAND, or SEQ Functions
  • ○

    Data privacy functions
  • ○

    NULL, CURRENT_DATE, CURRENT_TIME
  • ○

    Numeric Constants and Boolean Constants
Question 3 (Volume B)

The Optim Directory is built as part of the installation on the first workstation. Which two statements are correct about the Optim Directory? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The Optim Directory can reside on DB2 LUW, Oracle or Microsoft Access.
  • ○

    There may be more than one Optim Directory and they may reside on both Windows and UNIX.
  • ○

    The Optim Directory can reside on DB2 z/OS, Teradata or Microsoft SQL Server.
  • ○

    The definitions can be migrated from one Optim Directory to another with an Export and Import process.
  • ○

    The Optim Directory is always stored on a Windows workstation.