IBM InfoSphere Business Information Exchange Technical Mastery v1

1.

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

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

2.

In DataStage Sequential File Stage, how is a NULL value represented?

By a space character By a 'NULL' string A -1 for an integer field and an empty string for a VARCHAR field As defined by the Developer in the extended properties of the field

3.

Which of the following is NOT an option for the Reject Mode setting of a Sequential File Stage?

Continue Reject Fail Output

4.

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

Adds a column which holds a value of 0 or 1 1 indicates the key value has changed 0 indicates the key value has not changed Adds a column which holds a value of true/false

5.

Under which scenario may a user benefit from using InfoSphere Discovery?

Automate data relationship discovery Prototype a data model for the first time Automate transformation rule discovery Automate business object identification All of the above

6.

Which of the following statements about Blueprint Director is incorrect?

Blueprint Director will display the time needed to perform individual tasks You can browse and search Information Server metadata assets You can create new blueprints from standard reference architecture templates Reference architectures contain detailed method guidance for required activities

7.

Which of the following is a valid Write Mode action in the Connector Stages?

Insert Update Delete All of the above

8.

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

I, II, III, IV II, III, IV I, II, IV I, II, III

9.

Which of the following statements about partitioning algorithms is correct?

MODULUS and HASH ensure balanced data volumes in all the partitions For the Lookup reference stage, DataStage always uses the MODULUS method SAME partitioning method is the fastest algorithm because it does not require additional processing The grouping methods available in the Aggregator stage are MODULUS and HASH

10.

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

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

IBM InfoSphere Business Information Exchange Technical Mastery v1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM InfoSphere Business Information Exchange Technical Mastery v1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner