Free IBM P2090-045 Exam Dumps Questions & Answers


Exam Code/Number:	P2090-045Join the discussion
Exam Name:	IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1
Certification:	IBM
Free Question Number:	55
Publish Date:	Jul 23, 2026
# of views:	2304
Rating 100%

Page: 1 / 11
Total 55 questions

Question 1

In DataStage, Table Definitions can be imported through __________.

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

Question 2

Which of the following is NOT possible with a Transformer Stage?

A.Generate multiple output records for each single record
B.Use system variables and job parameters within derivations
C.Create and compile a custom function to be used in output link derivations
D.Define variables that can be referenced only within the Transformer Stage

Question 3

Which of the following statements about InfoSphere Data Architect is correct?

A.Reverse engineering data models only works for DB2 databases
B.You CANNOT create a logical model from a physical model
C.InfoSphere Data Architect is installed using the Information Server installation wizard
D.InfoSphere Data Architect can deploy physical data models directly to the database management system

Question 4

How can FastTrack speed up the process of creating new source-to-target mapping specifications? I.Reverse engineer existing DataStage jobs II.Automatically discover column mappings using matches on column names III.Leverage metadata imported from other Information Server modules IV.FastTrack automatically converts data lineage reports into mapping specifications

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

Question 5

Which of the following CANNOT be defined in the DataStage configuration file?

A.Scratch disk dedicated for sorting
B.Compilation options for DataStage jobs
C.A named pool including only part (some) of the nodes
D.Degree of parallelism