IBM P2090-046 Actual Free Exam Questions & Community Discussion

Exam Code/Number: P2090-046
Exam Name/Title: IBM InfoSphere Business Information Exchange Technical Mastery Test v1
Certification Provider: IBM
Corresponding Certification: IBM Information Management

Exam Questions: 60
Updated On: May 28, 2026

Question #19

Which of the following statements is an INVALID description of the Sort Stage Option Create Key Change Column?

A. 0 indicates the key value has not changed

B. Adds a column which holds a value of true/false

C. Adds a column which holds a value of 0 or 1

D. 1 indicates the key value has changed

Discussion 0

Correct Answer: B Vote an answer

Question #20

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

A. DataStage Director

B. Information Server Web Console

C. DataStage Administrator

D. DataStage Designer

Discussion 0

Correct Answer: C Vote an answer

Question #21

With DataStage Designer you CANNOT __________.

A. Create and reuse Table Definitions

B. Design jobs that extract, integrate, and transform the data for data warehouse

C. Configure the deployment model

D. Compile and execute the DataStage jobs

Discussion 0

Correct Answer: C Vote an answer

Question #22

The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2). Suppose that input_column1 contains a NULL value. Which behavior is expected?

A. The job aborts.

B. The input row is either dropped or rejected depending on whether the Transformer has a reject link.

C. NULL is written to the target stage variable.

D. The target stage variable is populated with spaces or zeros depending on the stage variable data type.

Discussion 0

Correct Answer: C Vote an answer

Question #23

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, IV

C. I, II, III

D. I, III, IV

Discussion 0

Correct Answer: D Vote an answer

Question #24

Which of the following statements about Collecting methods is correct?

A. AUTO chooses the best method between ROUND ROBIN, SORT MERGE, and ORDERED

B. ROUND ROBIN is the fastest algorithm

C. SORT MERGE never performs data sorting

D. ORDERED ensures the collected data stream being sorted

Discussion 0

Correct Answer: C Vote an answer

Download Free IBM P2090-046 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM P2090-046 exam.