IBM InfoSphere DataStage v11.3 - C2090-424 Exam Questions [2026]

QUESTION NO: 1
The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)

A. Merge B. Difference C. Modify D. Funnel E. Join

Correct Answer: A,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 2
Which statement about restartable sequence jobs is TRUE?

A. There is no way to force a Job Activity stage to return if the sequence got beyond it. B. Checkpoints are always added to every eligible Job Activity stage in the sequence. C. If a restartable sequence aborts, it can be restarted from Director. D. Choosing "Reset job" from Director will start the job where it left off.

Correct Answer: C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 3
By default, how much internal memory does the Sort use per partition?

A. 10MB B. 30MB C. 25MB D. 20MB

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 4
Which of the following is TRUE about working with assets and artifacts?

A. You must import the source control project into your own source control workspace in Information Server Manager before you can submit assets B. Rational Team Connect is not supported at all C. Information Server Manager has no logging capability D. You cannot lock and unlock assets in Rational Team Concert, regardless of tool used

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
Archive files can contain assets from multiple exports of multiple tools. When importing into a project from an archive file with the istool command, which order of asset types below would yield the best performance?

A. Common metadata,
Users and groups,
Custom attributes for InfoSphere Information Governance Catalog,
InfoSphere DataStage and QualityStage assets,
Reports B. Common metadata,
Users and groups,
Custom attributes for InfoSphere Information Governance Catalog,
InfoSphere Data Stage and QualityStage assets C. Users and groups,
Common metadata,
InfoSphere DataStage and QualityStage assets,
Custom attributes for InfoSphere Information Governance Catalog,
Reports D. Users and groups,
Common metadata,
InfoSphere DataStage and QualityStage assets,
Reports,
Custom attributes for InfoSphere Information Covernance Catalog

Correct Answer: D

QUESTION NO: 6
Which one of the following is NOT an XML Pack stage?

A. XML Transformer B. XML Output C. XML Connector D. XML Input

Correct Answer: C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 7
Which client Tool is used to export environment variables from a Project?

A. InfoSphere DataStage Manager B. InfoSphere DataStage Administrator C. InfoSphere DataStage Designer D. InfoSphere DataStage Director

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).