Prep and try our C2090-421 valid and latest training questions & answers

IBM C2090-421 Exam Overview:

IBM C2090-421 Exam Syllabus Topics:

IBM InfoSphere DataStage v8.5 Sample Questions:

Question 1

You are asked to identify the jobs and shared containers that use the ADDRESS column. The Size has changed from 50 to 120 characters in the source system so the jobs must be updated with the new size. What feature of the Designer will locate where a column is used in a DataStage project?

A. From Designer Tools, open an Advanced Find dialog. Enter the column name in the Name to find field. Select Jobs and Shared Containers from the Type to find list.
B. Select a Table Definition, then right click and choose Find where column is used. Select the column to search for from the list.
C. From Designer Tools open an Advanced Find dialog. Select Columns from the Type list and enter the column name in the Name To Find field.
D. Open the Table Definition properties, Select the ADDRESS column, then right click and select Find where used.

Question 2

What conditions are necessary for a master record and an update record to merge?

A. both records have the same values for the merge key column(s) that you specify
B. all of the columns in the input record match the columns in the update record
C. some of the columns in the input record match the columns in the update record
D. none of the columns in the input record match the columns in the update record

Question 3

A customer wants to select the entire order details for the largest transaction for each of 2 million customers from a 20 million row DB2 source table containing order history. Which parallel job design would satisfy this functional requirement?

A. Partition and sort the input to a Filter stage by customer number. Filter with the clause "MAX(transaction_amount)".
B. Partition and sort the input to a RemoveDuplicates stage using the customer key and transaction amount columns. Remove duplicates on customer key.
C. Use a Sort Aggregator stage with calculated column based on the maximum value of transaction amount column.
D. Partition on customer key, sort on customer key and transaction amount, remove duplicates on customer key.

Question 4

Which three environment variables are valid job score environment variables? (Select three)

A. APT_LOW_SCORE
B. APT_DUMP_SCORE
C. APT_THIN_SCORE
D. APT_SAVE_SCORE
E. APT JAVA SCORE

Question 5

The purchase history record contains CustID, ProductID, ProductType and TotalAmount. You need to retain the record of greatest TotalAmount per CustID and ProductType using RemoveDuplicate stage. Which two statements accomplish this requirement? (Choose two.)

A. Hash-partition on CustID;
Sort on CustID, ProductType and TotalAmount.
B. Hash-partition on CustID, ProductType and TotalAmount;
Sort on CustID, ProductType and TotalAmount.
C. Hash-partition on CustID and ProductType;
Sort on CustID, ProductType and TotalAmount.
D. Hash-partition on ProductType;
Sort on ProductType, CustID and TotalAmount.

Solutions: