[2026] IBM InfoSphere DataStage v8.5 - C2090-421 무료 시험 문제

문제1

Which three environment variables are used for reporting on DataStage jobs? (Select three)

A. $APT_DUMP_SCORE

B. $APT_PM_PLAYER_MEMORY

C. $OSH_PRINT_SCHEMAS

D. $APT_PM_STARTUP_CONCURRENCY

E. $APT_DISABLE_ROOT_FORKJOIN

정답: A,B,C

문제2

The DB2 and Oracle Enterprise stages support logged and non-logged DBMS table operations. What is the non-logged operation that is supported by the DB2 and Oracle Enterprise stages?

A. Load

B. Delete

C. Update

D. Insert

정답: A

문제3

Which two partitioning methods require keys? (Choose two.)

A. Modulus

B. Hash

C. Entire

D. Round Robin

정답: A,B

문제4

What Information Server tool provides integration with source code control repositories?

A. DataStage Designer

B. Information Server Manager

C. Information Services Director

D. Multiple Job Compile

정답: B

문제5

A scenario requires selecting only the most recent transactions for each of 2 million unique customers, from a 20 million row DB2 source table containing order history. Which parallel job design would satisfy this functional requirement?

A. Using the DB2 Enterprise stage, select all rows. Perform a unique Sort using customer number and order date sort keys in ascending order.

B. Using the DB2 API stage, select all rows. Use a Sort stage with customer number and order date sort keys in ascending order, then Remove Duplicates with Last Duplicate to retain.

C. Select all rows using the ODBC Connector stage, use a Sort Aggregator on customer number key to select the maximum order date.

D. Using the Dynamic Relational stage, use custom SQL to select all DISTINCT customer numbers from the order history table.

정답: B

문제6

How must the input data set be organized for input into the join stage? (Choose two.)

A. Unsorted

B. Hash partitioned

C. Key partitioned

D. Entire partitioned

E. Sorted in ascending order

정답: C,E

문제7

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

A. Specify the command to be executed by the Wrapper.

B. Specify how Wrapper property values are to be converted.

C. Specify whether input rows are to be processed automatically or manually.

D. Create Table Definitions that define the Wrapper's input and output columns.

E. Code and compile the C/C++ Wrapper source code.

정답: A,B,D

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

문제8

Using a DB2 for z/OS source database, a 200 million row source table with 30 million distinct values must be aggregated to calculate the average value of two column attributes. What would provide optimal performance while satisfying the business requirements?

A. Using custom SQL with an ORDER BY clause based on key columns, select all source rows using the DB2 API stage. Aggregate using a Hash Aggregator.

B. Using custom SQL with AVG functions and a DISTINCT clause, select all source rows using a DB2 Enterprise stage.

C. Select all source rows using a DB2 API stage. Aggregate using a Sort Aggregator.

D. Select all source rows using a DB2 Enterprise stage, use a parallel Sort stage with the specified sort keys, calculate the average values using a parallel Transformer with stage variables and output link constraints.

정답: C

문제9

Records in a source file must be aggregated for further processing. Which two conditions would require the use of a Transformer stage instead of or in addition to an Aggregator stage? (Choose two.)

A. Aggregation results outside of a certain range need to be flagged as abnormal.

B. The data hasn't been sorted or grouped.

C. The aggregation is a custom formula for your enterprise.

D. A global aggregation across all partitions is needed.

정답: A,C

문제10

You write a job control routine to control a sequence of jobs running as a single unit of work. What are three valid job status types you can trap for? (Choose three.)

A. DSJS.RUNERROR

B. DSJS.STOPPED

C. DSJS.RUNOK

D. DSJS.RUNFAILED

E. DSJS.START

정답: B,C,D

문제11

You found there were common functional requirements in the data mapping specification. The required functions are same but the record formats are different. Which action will allow you to effectively implement common logic?

A. Create parallel routines.

B. Create parallel shared containers and define columns combining all data formats.

C. Create separate jobs and choose appropriate job within a job sequence.

D. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary columns needed for the logic.

정답: D

문제12

Which two statements are true about Transformer loop processing? (Select two)

A. Loop variable expressions are executed before output link column expressions.

B. Stage variables can be referenced in loop conditions.

C. Loop variable expressions are executed before stage variable expressions.

D. Loop conditions are evaluated once for each input row.

정답: C,D

IBM InfoSphere DataStage v8.5 - C2090-421무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트