最新のA2090-421問題集で試験を準備する

IBM A2090-421 試験概要:

IBM A2090-421 試験シラバストピック:

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

1. A customer requires that a single output file generated by a parallel job be created in sort order. Which two job designs would achieve this goal? (Choose two.)

A) Insert a sorted Funnel stage before the input to the output SequentialFile stage.
B) Use a parallel sort and partition the input to the SequentialFile stage using a Sort Merge collector.
C) Write the result to a parallel dataset, then write a shell script to convert the dataset records to text format, in sorted order.
D) Set the "Execution Mode" in the Advanced stage properties tab of the parallel Sort stage to execute sequentially.
E) Specify both partition and sort key columns on the input to the target SequentialFile stage.

2. A customer requests you to configure a Sequential File stage in a clustered environment. The stage must read a varying number of files each run in a single pass and append the name of the file the row was read from when an error occurs. What three steps are required to achieve this? (Select three)

A) Specify a file pattern option along with a file name mask that captures entire file list.
B) Set environment variable $APT_IMPORT_PATTERN_USES_FILESET.
C) Specify File Name Column property.
D) Set environment variable $APT_SEQ_FILE_INCL_FILENAMES.
E) Specify multiple "File" properties.

3. When using Runtime Column Propagation, which three stages require a schema file? (Select three)

A) Peek stage
B) File Set stage
C) Sequential File stage
D) DB2 Enterprise stage
E) Column Import stage

4. The DB2 and Oracle Enterprise stages support logged and non-logged DBMS table operations. What is the non-logged operation that is supported by the DB2 and Oracle Enterprise stages?

A) Delete
B) Load
C) Update
D) Insert

5. 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.

質問と回答：