New Year Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

Note! Following P2090-045 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

P2090-045 Exam Dumps - IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1

Question # 4

Where are Table Definitions stored?

A.

Information Server metadata repository

B.

In the file system as a binary file

C.

In the file system as a csv file

D.

None of the above

Full Access
Question # 5

Which Stage requires identical metadata in order to combine data?

A.

Lookup Stage

B.

Funnel Stage

C.

Join Stage

D.

Transformer Stage

Full Access
Question # 6

Which of the following statements about Collecting methods is correct?

A.

ROUND ROBIN is the fastest algorithm

B.

SORT MERGE never performs data sorting

C.

ORDERED ensures the collected data stream being sorted

D.

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

Full Access
Question # 7

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

A.

Degree of parallelism

B.

Scratch disk dedicated for sorting

C.

Compilation options for DataStage jobs

D.

A named pool including only part (some) of the nodes

Full Access
Question # 8

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

A.

Adds a column which holds a value of 0 or 1

B.

1 indicates the key value has changed

C.

0 indicates the key value has not changed

D.

Adds a column which holds a value of true/false

Full Access