Free IBM P2090-070 Exam Dumps Questions & Answers

Which of the following statements about relationships is TRUE?

• A.  An Optim-defined relationship is as restrictive as a DB2 relationship.
• B.  An Optim-defined relationship is also enforced by the database manager.
• C.  Defining a new relationship on a pair of tables that was already identified in an existing Access Definition may affect processes that use that Access Definition.
• D.  When an Access Definition is used it can only follow relationships that were defined at the time the Access Definition was created.

Which would need to be modified/specified to populate a table with a randomly generated Social
Security Numbers?

• A.  Populate Request
• B.  Archive Request
• C.  Column Map
• D.  Table Map

When including Legacy data in Optim processes, which of the following is FALSE?

• A.  Legacy Tables are supported not only for the Move Process but also for the Archive Process.
• B.  A Legacy Table must be associated to a Data Source.
• C.  A Legacy Table's structure is specified by identifying a "copybook" or building the equivalent from
  scratch.
• D.  "Legacy Tables" includes support for sequential datasets, VSAM, and IMS.

Which of the following steps is NOT part of an Archive Definition process?

• A.  Define the Selection Criteria
• B.  Designate columns for indexing
• C.  Create a Column Map
• D.  Create an Access Definition to select tables to be included in an Archive

Which of the following statements concerning traversing valid relationships that are included in an
Access Definition is TRUE?

• A.  From the "start" table a path to a child will always be followed unless CHILD_LIMIT=0.
• B.  If every path in the Access Definition has Q1='N', then Q2 can still be important.
• C.  The Q1 rule controls whether a path from a "parent" to a "child" is followed.
• D.  Every "parent" to "child" path in the access definition will be followed