IBM Assessment: InfoSphere DataStage v8.5 認定 A2090-421 試験問題:

1. Which two statements are true for named node pools? (Select two)

A) Using appropriately named node pool constraints limit stages to be executed only on the nodes defined in the node pools.
B) Named node pools are required for DataStage jobs to scale across multiple machines on a grid or cluster.
C) Using appropriately named node pools allow the separation of buffering from sorting disks.
D) Using appropriately named node pools is only available in clustered environments.
E) Using appropriately named node pools force DataStage jobs to use named pipes between stages.

2. You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed.
What are two requirements on the input link data for the Change Capture stage? (Select two)

A) Sequential mode
B) Key partitioned
C) Sorted
D) Merged links

3. In a Transformer Stage you have a nullable input column that is mapped to a non-nullable output column. What two techniques can be used to handle NULL values? (Choose two.)

A) IF input_column = NULL THEN 'unknown' ELSE input_column.
B) IF input_column = '' THEN 'unknown' ELSE input_column.
C) NullToValue(input_column, 'unknown').
D) IF IsNULL(input_column) THEN 'unknown' ELSE input_column.

4. Which three statements are true about stage variables? (Select three)

A) Stage variables are executed before loop variables.
B) A derivation for a stage variable can reference stage variables that are later in the execution order.
C) Stage variables are executed after constraints but before derivations.
D) Stage variables cannot contain NULL values.
E) Stage variables retain their values between rows in the stage.

5. You are assigned to correct a job from another developer. The job contains 20 stages sourcing data from two Data Sets and many sequential files. The annotation in the job indicates who wrote the job and when, not the objective of the job. All link and stage names use the default names. One of the output columns has an incorrect value which should have been obtained using a lookup. What could the original developer have done to make this task easier for maintenance purposes?

A) Indicated all stage names within the job annotation.
B) Named all stage and links the same.
C) Named all stage and links with column names and ideas.
D) Named all stages and links based on what they do.

質問と回答：