Free IBM P2090-046 Exam Dumps Questions & Answers

Which of the following statements about the Lookup Stage is correct?

• A.  The default partition method for Lookup is Hash
• B.  It is a Real-Time Stage
• C.  It combines data horizontally
• D.  It can have only one input link defined

Which of the following is NOT a function provided by the DB2 Connector Stage?

• A.  Automatically updates table definitions when a SQL type mismatch is detected
• B.  Performs a lookup directly on a DB2 table
• C.  Deletes rows from a DB2 table
• D.  Reads a DB2 table

What are the file format types when you use DataStage Designer to export objects?

• A.  TXT and CSV
• B.  DSX and XML
• C.  DSX and CSV
• D.  TXT and XML

Which of the following statements about partitioning algorithms is correct?

• A.  MODULUS and HASH ensure balanced data volumes in all the partitions
• B.  SAME partitioning method is the fastest algorithm because it does not require additional processing
• C.  The grouping methods available in the Aggregator stage are MODULUS and HASH
• D.  For the Lookup reference stage, DataStage always uses the MODULUS method

Which of the following statements is not a supported matching option of the Lookup Stage?

• A.  Range on the Target Link
• B.  Equality match
• C.  Caseless match
• D.  Range on the Reference Link