Free IBM P2090-070 Exam Dumps Questions & Answers

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

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

What statement is TRUE about Optim Data Growth solution?

• A.  During Delete Process, a row is deleted even if the table has a Delete Restrict relationship to another
  table that still contains rows.
• B.  Group selection processing is available for Archive Processes.
• C.  The ARC and ACT commands are available for Access Definitions used in both Archive Process and
  Extract Process.
• D.  ARCHIVE offers Direct or Offline Delete processing when data deletion is deferred.

Which of the following file formats is NOT supported by the Browse Utility?

• A.  Extract File
• B.  Control File
• C.  Compare File
• D.  Sequential File

What is used during data masking to preserve the relational integrity?

• A.  TRANS RI
• B.  RAND_LOOKUP()
• C.  PROP()
• D.  RI Request

Which features should one use to select specific rows from a Start Table to begin an Extract?

• A.  Table Map
• B.  Group
• C.  Point and Shoot
• D.  Column Map