Study with C2090-421 Actual Test Questions

Failing C2090-421 means paying the registration fee all over again, which makes thorough preparation the cheaper option. The IBM InfoSphere DataStage v8.5 practice questions from Actualtests4sure give you 194 chances to rehearse before the day that counts, so you can walk in ready the first time.

IBM C2090-421 Exam Overview:

IBM C2090-421 Exam Syllabus Topics:

IBM InfoSphere DataStage v8.5 Sample Questions:

Question 1

Which requirement must be met to read from a database in parallel using the ODBC connector?

A. Configure environment variable $APT_PARTITION_COUNT.
B. Set the Enable partitioning property to Yes.
C. Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE.
D. ODBC connector always reads in parallel.

Question 2

What two data sources support direct lookups? (Select two)

A. DB2
B. SqIServer
C. ODBC
D. Oracle
E. Teradata

Question 3

You set environment variable $APT_ORACLE_LOAD_OPTIONS=PTIONS(DIRECT=TRUE, PARALLEL=TRUE)?for loading index organized tables.You set environment variable $APT_ORACLE_LOAD_OPTIONS=?PTIONS(DIRECT=TRUE, PARALLEL=TRUE)?for loading index organized tables. Which statement is accurate regarding the resulting effect of this environment variable setting?

A. The Oracle database stage will run in parallel using conventional path mode.
B. Oracle load will fail when executed.
C. The Oracle load will run in parallel using simple direct path mode.
D. Oracle load will run in parallel and bypass DataStage Director.

Question 4

Rows of data going into a Transformer stage are sorted and hash partitioned by the Input.Product column. Using stage variables, how can you determine when a new row is the first of a new group of Product rows?

A. Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".
B. Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct . Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".
C. Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct . Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".
D. Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".

Question 5

In the job fragment shown in the exhibit, the data going into the target Sequential File stage needs to be sorted by postal code. The Sort stage accomplishes this by running in Sequential mode and sorting by postal code. You have been asked to improve the performance of the job with a 4-node configuration file.

Which two changes will improve the performance of the job? (Choose two.)

A. Eliminate the existing Sort stage; define an in-stage sort in the Filter stage, sorting by postal code. In the target Sequential File stage choose the SortMerge collector.
B. Move the Sort stage in front of the Filter stage, so that the sort is performed earlier in the job.
C. Add a second Sort stage just before the existing Sort stage; run the new stage in parallel mode sorting by postal code.
D. Change the mode of the existing Sort stage to parallel mode; continue to sort by postal code. In the target Sequential File stage choose the SortMerge collector.

Solutions: