Pass with A2090-421 Practice Materials 100% for sure

IBM A2090-421 Exam Overview:

IBM A2090-421 Exam Syllabus Topics:

IBM Assessment: InfoSphere DataStage v8.5 Sample Questions:

1. There is a requirement to load mainframe data with array columns having redefined fields into a flat file. How can the Complex Flat File

A) Select the Records ID tab on the Stage page. Select a record from the Records list. Select the column(s) with the redefine from the Column list. Within CFF, use the Complex File Load Option window with "Flatten selective arrays" option selected.
B) CFF does not support flattening for redefined fields.
C) Within CFF, use the Complex File Load Option window with "Flatten all arrays" option selected. CFF will handle flattening automatically.
D) Within CFF, use the Complex File Load Option window with "Flatten selective arrays" option selected. Select the array with redefine column(s) and click redefine check box option.

2. When creating a Wrapper stage, which three tasks need to be done? (Select three)

A) Specify how Wrapper property values are to be converted.
B) Specify the command to be executed by the Wrapper.
C) Specify whether input rows are to be processed automatically or manually.
D) Code and compile the C/C++ Wrapper source code.
E) Create Table Definitions that define the Wrapper's input and output columns.

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

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

4. You are asked by management to document all jobs written to make future maintenance easier. Which two statements are true about annotations? (Choose two.)

A) The Description Annotation stage contains both the short and full descriptions for the job.
B) The full job description can be identified within the Description Annotation stage.
C) The Description Annotation stage can be added several times at different locations to identify business logic.
D) The background for the Description Annotation stage can be changed for each unique stage.

5. Refer to the exhibit.

You are responsible for improving performance for a given job. From reviewing the job dump score, you notice that many tsort operators are inserted. Join_1 is on columns "account", "po_date" and "hdr_number". Join_2 is based on "account", "hdr_number", "paid_date".
Which two actions will help you improve the performance without changing the business logic?
(Select two)

A) Partition on "account" and "hdr_number" for all joins. Change Join_1 to join on "account", "hdr_number" and "po_date". Add Add $APT_SORTJNSERTION_CHECK_ONLY to job parameter list and set it to "True".
B) Insert sort stage between Join_1 and Join_2, subsort ("Don't sort, previously sorted") on "account", sort "hdr_number" and "paid_date".
C) Partition on account and hdrnumber for all joins. Change Join_1 to join on "account", "hdrnumber" and "po_date". Insert Sort between Join_1 and Join_2 and subsort ("Don't sort previously sorted") on "account" and "hdr_number" and sort on "paid_date".
D) Partition on account and hdr_numberfor all joins. Change Join_1 to join on "account", "hdr_number" and "po_date". Insert Sort between Join_1 and Join_2 and subsort ("Don't sort previously sorted") on "account".

Solutions: