Passing exam with C2090-421 latest training materials

IBM C2090-421 Exam Overview:

IBM C2090-421 Exam Syllabus Topics:

IBM InfoSphere DataStage v8.5 Sample Questions:

1. A job reads from a sequential file using a SequentialFile stage with option "number of readers" set to 2. This data goes to a Transformer stage and then is written to a dataset using the DataSet stage. The default configuration file has three nodes. The environment variable $APT_DISABLE_COMBINATION is set to "True" and partitioning is set to "Auto". How many processes will be created?

A) 12
B) 5
C) 7
D) 9

2. In the exhibit, the Aggregator stage aggregates over CustomerID. The Join stage joins by CustomerID. When the score is created, DataStage will insert hash partitioners and tsort operators to ensure the correct results.

Which two choices will eliminate sort operators from being inserted at run-time? (Select two)

A) Add a Sort stage before the Copy stage and specify Same partitioners for the links going into the Aggregator and Join stages.
B) Add a Sort stage before the Copy stage and specify Auto partitioned for the links going into the Aggregator and Join stages.
C) Add a Sort stage before the Aggregator stage and specify the Same partitioner for the link going into the Aggregator Set the $APT_SORTJNSERTION_CHECK_ONLY environment variable to "True".
D) Add Sort stages in front of the Join stage and specify the Same partitioner for the links going into the Join. Set the $APT_NO_SORT_INSERTION environment variable to "True".

3. In your DB2 database you have column names that use characters # and $. Which two steps should be completed to allow DataStage to convert these characters into internal format and back as necessary? (Select two)

A) Set environment variable $DS_ENABLE_RESERVED_CHAR_CONVERT to true.
B) Avoid using the strings_035_and_036_in your IBM DB2 column names.
C) Set environment variable $DS_ENABLE_RESERVED_NUM_CONVERT to true.
D) Avoid using the strings_025_and_026_in your IBM DB2 column names.

4. The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2). Suppose that input_column1 contains a NULL value. Which behavior is expected?

A) The job aborts.
B) NULL is written to the target stage variable.
C) The input row is either dropped or rejected depending on whether the Transformer has a reject link.
D) The target stage variable is populated with spaces or zeros depending on the stage variable data type.

5. Your job sequence must be restartable. It runs Job1, Job2, and Job3 serially. It has been compiled with "Add checkpoints so sequence is restartable". Job1 must execute every run even after a failure. Which two properties must be selected to ensure that Job1 is run each time, even after a failure? (Choose two.)

A) Set the Job1 Activity stage to "Do not checkpoint run.".
B) Set trigger on the Job1 Activity stage to "Unconditional".
C) Use the Nested Condition Activity with a trigger leading to Job1; set the trigger expression type to "Unconditional".
D) In the Job1 Activity stage set the Execution action to "Reset if required, then run.".

Solutions: