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

1. You are describing to your customer how to work with packages. There are two steps that must be carried out in order to move the package to a target project. Which two steps must be carried out to move the DataStage objects to the Production system? (Choose two.)

A) Deploy
B) Export
C) Compile
D) Package
E) Build

2. Which three statements are true about File Sets? (Choose three.)

A) File sets are readable by external applications.
B) File sets are stored as header file and data files.
C) File sets are partitioned.
D) File sets always execute in parallel.
E) File sets have a proprietary data format which may change in future DataStage versions.

3. Input rows to a Transformer contain a product name field and a field with a list of colors the product can be ordered with. The colors are separated by the pipe character (|). Here is an example of an input row: "Shirt"| ....| "Red, Blue, Black"|... For each input row, you want to output multiple output rows, one for each color in the list. For the above example input row, three rows are to be output, one per color: "Shirt" ... "Red", "Shirt" ... "Blue", "Shirt" ... "Black".
Which three operations will you need to accomplish this? (Choose three.)

A) Specify the following loop condition: @ITERATION <= n, where n is a stage variable initialized with number of loop iterations.
B) Use the LastRowInGroup() function to determine when the last color in the color list has been processed.
C) Use the @ITERATION variable to determine which color in the ColorList field to extract using the Field function.
D) Use the Count() function over the ColorList field to determine the number of loop iterations.
E) Use the SaveInputRecord() to save the input row for processing in the loop. Use the GetInputRecord() to extract the row for each iteration of the loop.

4. Which of the following describes what happens when Runtime Column Propagation is enabled?

A) An input column value flows into a target column based on its position in the input row. For example, first column in the input row goes into the first target column.
B) An input column value flows into a target column only if it is explicitly mapped to it.
C) An input column value flows into a target column only if it matches it by name.
D) An input column value flows into a target column based on its position in a Schema file.

5. You would like to run a particular processing job within a job sequence for each weekday of the week. How could you do this? (Select two)

A) Start Loop and End Loop activity stages on the job sequencer canvas where you loop through the days and pass a value for each day into the job via parameter.
B) Call a routine in the job sequencer that starts the processing job for each day you would like to process.
C) Set the frequency property in the job scheduler to weekdays only.
D) Have a parameter set that contains the days of the week you would like to process and routine to parse the days of the week contained in the "day" parameter.

質問と回答：