IBM InfoSphere DataStage v9.1 認定 C2090-303 試験問題:

1. A job validates account numbers with a reference file using a Join stage, which is hash partitioned by account number. Runtime monitoring reveals that some partitions process many more rows than others. Assuming adequate hardware resources, which action can be used to improve the performance of the job?

A) Add a Sort stage in front of the Join stage. Sort by account number.
B) Use Round Robin partitioning on the stream and Entire partitioning on the reference.
C) Replace the Join with a Merge stage.
D) Change the number of nodes in the configuration file.

2. The number of File Set data files created depends upon what two items? (Choose two.)

A) Number of logical processing nodes.
B) Operating system limitations.
C) Schema definition of the file.
D) Amount of memory.
E) Number of disks in the export or default disk pool connected to each processing node in the default node pool.

3. Identify the two delimiter areas available to be configured in the Sequential File format tab properties? (Choose two.)

A) Final delimiter
B) Null delimiter
C) File delimiter
D) End of group delimiter
E) Field delimiter

4. Click on the Exhibit button.

Provided you have enough system resources, what is the maximum number of jobs that could be running concurrently in this image?

A) 2
B) 3
C) 4
D) 5

5. Rows of data going into a Transformer stage are sorted and hash partitioned by the Input.Product column. Using stage variables, how can you determine when a new row is the first of a new group of Product rows?

A) Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".
B) Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".
C) Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".
D) Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".

質問と回答：