Free IBM C2090-421 Practice Test & Real Exam Questions, Page 1

Question #1

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 AVG functions and a DISTINCT clause, select all source rows using a DB2 Enterprise stage.

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

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

Discussion 0

Correct Answer: D Vote an answer

Question #2

What is the correct method to process a file containing multiple record types using a Complex Flat File stage?

A. Define record definitions on the Constraints tab of the Complex Flat File stage.

B. Use a Modify stage to convert the output array from the Complex Flat File to a subrecord.

C. Define record ID constraints on the Records ID tab of the Complex Flat File stage.

D. Manually break the file into multiple files by record type.

Discussion 0

Correct Answer: C Vote an answer

Question #3

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

A. Configure environment variable $APT_PARTITION_COUNT.

B. Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE.

C. Set the Enable partitioning property to Yes.

D. ODBC connector always reads in parallel.

Discussion 0

Correct Answer: C Vote an answer

Question #4

You are running a DataStage job using a 2-node configuration file. How can a fixed-width single sequential file be read in parallel? (Choose two.)

A. Set the "Number of Readers per Node" optional property to a value greater than 1.

B. Set the "Read From Multiple Nodes" optional property to a value greater than 1.

C. Specify a node constraint for the SequentialFile stage.

D. Set the Execution Mode to the SequentialFile stage to "Parallel".

E. Use an external Source stage.

Discussion 0

Correct Answer: A,B Vote an answer

Question #5

In a Transformer expression for a stage variable, there is a nullable input column. What happens when a row is processed that contains NULL in that input column?

A. The row is rejected.

B. The value written to the stage variable is undetermined.

C. The job aborts.

D. NULL is written to the stage variable.

Discussion 0

Correct Answer: D Vote an answer

Question #6

Your customer is using Source Code Control Integration for Information server and have tagged artifacts for version 1. You must create a deployment package from the version 1.
Before you create the package you will have to ensure the project is up to date with version 1.
What two things must you do to update the meta-data repository with the artifacts tagged as version 1? (Select two)

A. Right-click the asset and click Replace From Source Control Workspace.

B. Right-click the asset and click the Deploy command.

C. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.

D. Right-click the asset and click the Team Import command.

Discussion 0

Correct Answer: C,D Vote an answer

Question #7

A job is using the Load method in the DB2 and Oracle Enterprise stage for parallel loading into a single table. The job fails at runtime and you see there are new table rows added. What would explain this result? (Select two)

A. Load operations are parallel.

B. Commit size is smaller than source data.

C. Load operations are sequential.

D. Some partitions completed before failure.

Discussion 0

Correct Answer: A,B Vote an answer

Question #8

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

Discussion 0

Correct Answer: A Vote an answer

Question #9

What two stages are required to place Header and Detail records, which have different formats, into a single format? (Choose two.)

A. Combine Stage

B. Column Export Stage

C. Funnel Stage

D. Column Import Stage

Discussion 0

Correct Answer: B,C Vote an answer

Question #10

A job validates credit card numbers with a reference file using a Join stage, which is hash partitioned by card number. Examination of Job Monitor reveals that some partitions process many more rows than others. Assuming adequate hardware resources, which action can be used to improve the performance of the job?

A. Use Round Robin partitioning on the stream and Entire partitioning on the reference.

B. Alter the number of partitions in the $APT_CONFIG_FILE.

C. Replace the Join with a Merge stage.

D. Break the input file into multiple files.

Discussion 0

Correct Answer: B Vote an answer

Question #11

Which three parallel job stages allow you to use partial schemas? (Select three)

A. Sequential File stage

B. Peek stage

C. Dataset stage

D. External Source stage

E. Column Import stage

Discussion 0

Correct Answer: A,D,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #12

DataStage offers database connectivity through connectors, native parallel and plug-in stage types. Which two statements are correct? (Choose two.)

A. The connector stage offers better functionality and performance and is the best to use.

B. ODBC API is a plug-in stage.

C. Next to the connector stage it is best to use the native parallel database stages.

D. For maximum parallel performance, scalability, and features it is best to use the native parallel database stages.

Discussion 0

Correct Answer: A,C Vote an answer

Free IBM C2090-421 Practice Test & Real Exam Questions

Download Free IBM C2090-421 Demo