Free IBM P2090-045 Exam Dumps Questions & Answers

Which description below about the Sort Stage is invalid?

• A.  All the incoming records must have different values for sorting key
• B.  Sort can be executed in sequential mode or parallel mode
• C.  It has a property to create a Key Change Column
• D.  Sort Stage uses temporary disk space while performing sort

Which Stage requires identical metadata in order to combine data?

• A.  Funnel Stage
• B.  Join Stage
• C.  Lookup Stage
• D.  Transformer Stage

In DataStage, Table Definitions can be imported through __________.

• A.  DataStage Administrator
• B.  Information Server Web Console
• C.  DataStage Director
• D.  DataStage Designer

Which functionalities are supported by InfoSphere Discovery? I.Discover primary / foreign key relationships between tables II.Discover statistics about usage of data by users III.Discover matching source and target columns IV.Discover suggested transformations that, when applied, will transform the data from the source columns to match the data in the target columns

• A.  II, III, IV
• B.  I, II, III
• C.  I, II, IV
• D.  I, III, IV

In DataStage, which client can be used to set environment variables at project level?

• A.  DataStage Administrator
• B.  Information Server Web Console
• C.  DataStage Director
• D.  DataStage Designer