IBM Assessment: InfoSphere DataStage v8.5 - A2090-421 시험문제 [2026]

문제1
Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)

A. Look up whether a record with a matching business key value exists in a dimension table. If it does not, retrieve a new surrogate key value and insert a new row into the dimension table.

B. Look up whether a record with a matching business key value exists in a fact table. If it does not, retrieve a new surrogate key value and insert a new row into the fact table.

C. Look up whether a record with a matching business key value exists in a dimension table. If it does, mark the record as not-current, and generate a new record with new values for selected fields.

D. Look up whether a record with a matching business key value exists in a dimension table. If it does, add new values for selected fields to values lists for those fields.

정답: A,C

문제2
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 RemoveDuplicates stage using the customer key and transaction amount columns. Remove duplicates on customer key.

B. Partition on customer key, sort on customer key and transaction amount, 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 and sort the input to a Filter stage by customer number. Filter with the clause "MAX(transaction_amount)".

정답: B

문제3
The number of File Set data files created depends upon what three items? (Choose three.)

A. Number of physical processing nodes.

B. File system limitations.

C. Number of disks in the export or default disk pool connected to each processing node in the default node pool

D. Schema definition of the file.

E. Number of processing nodes in the default node pool.

정답: B,C,E

문제4
Which two statements are correct about XML stages and their usage? (Choose two.)

A. XML Output stage converts relational tables and sequential files to XML hierarchical structures.

B. XML Transformer stage converts an XML document to another XML hierarchical format.

C. XML Input stage converts XML data to hierarchical format.

D. XML Input stage transforms hierarchical XSLT data to tabular format.

정답: A,B

문제5
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 can be added several times at different locations to identify business logic.

B. The full job description can be identified within the Description Annotation stage.

C. The background for the Description Annotation stage can be changed for each unique stage.

D. The Description Annotation stage contains both the short and full descriptions for the job.

정답: B,D

문제6
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. Insert sort stage between Join_1 and Join_2, subsort ("Don't sort, previously sorted") on "account", sort "hdr_number" and "paid_date".

B. 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".

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

정답: B,C

문제7
Which three attributes are found for each segment in a Data Set descriptor file? (Select three)

A. Path names of all data files on all processing nodes.

B. Flag marking segment as valid or invalid.

C. Statistical information such as number of records in the segment and number of bytes.

D. Schema of Data Set.

E. Copy of the configuration file used when segment was created.

정답: A,C,E

문제8
If you do not alter any of the Format settings, the Sequential File stage will produce a file with what three types of format? (Choose three.)

A. All columns are delimited by a comma, except for the final column in a row.

B. All columns are delimited by a comma.

C. Variable length columns are contained within double quotes.

D. Rows are delimited by a DOS newline.

E. Rows are delimited by a UNIX newline.

정답: A,C,E

문제9
Records in a source file must be copied to multiple output streams for further processing. Which two conditions would require the use of a Transformer stage instead of a Copy stage? (Choose two.)

A. Directing selected output records down one output link rather than another.

B. Converting some input columns from integers to strings.

C. Concatenating data from multiple input columns.

D. Renaming one or more output columns.

정답: A,C

문제10
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. Set the frequency property in the job scheduler to weekdays only.

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

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

D. Call a routine in the job sequencer that starts the processing job for each day you would like to process.

정답: A,B

문제11
The result of a performance review for one of your job designs indicated this job needs to be split into two separate jobs. You also have been given the requirement to ensure you maintain parallelism (no re-partitioning) between these two new jobs.
Which single stage should you consider to accomplish maintaining parallelism and not introduce re-partitioning between these related jobs?

A. Sequential File stage

B. Named Pipe stage

C. Copy stage

D. Data Set stage

정답: A

설명: (KoreaDumps 회원만 볼 수 있음)

문제12
Which three actions can improve sort performance in a DataStage job? (Choose three.)

A. Adjust the "Restrict Memory Usage" option in the Sort stage.

B. Specify only the key columns which are necessary.

C. Minimize the number of sorts used within a job flow.

D. Run the job sequentially so that only one sort process is invoked.

E. Use the stable-sort option to avoid the random ordering of non-key data.

정답: A,B,C

문제13
A customer requires reading a fixed-length sequential file in parallel where input rows can be identified. What two tasks must be done to meet these requirements? (Choose two.)

A. Specify Multiple readers per node.

B. Set $APT_READ_MULTI_NODES to TRUE.

C. Ensure data has unique identifiers for data rows.

D. Set partitioning method to Same.

정답: A,C

문제14
Which three of the following are valid schema formats? (Choose three.)

A. Total Columns

B. Aggregator Columns

C. Raw Columns

D. Integer Columns

E. Decimal Columns

정답: C,D,E

문제15
A job design consists of an input sequential file, a Modify stage, followed by a Filter stage and an output SequentialFile stage. The job is run on an SMP machine with a configuration file defined with three nodes. No environment variables were set for the job. How many osh processes will this job create?

A. 8

B. 9

C. 11

D. 16

정답: B

최신IBM Assessment: InfoSphere DataStage v8.5 - A2090-421무료샘플문제

KoreaDumps의 제품으로 GO GO GO !

자격증의 중요성:

KoreaDumps 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공: