New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best70

Note! IBM has retired the C2090-424 Exam Contact us through Live Chat or email us for more information.

C2090-424 InfoSphere DataStage v11.3 Questions and Answers

Questions 4

To run multiple copies of the same job within Director, which of the following must be supplied?

Options:

A.

Job name

B.

Invocation ID

C.

Parameter values

D.

Username and password

Buy Now
Questions 5

A job is designed with 3 Join stages in sequence.

Join_1 keys are “Account”, “Customer” and “PO_Date”

Join_2 keys are “Account”, “Customer” and “Txn”

Join_3 keys are “Account”, “Product_CD” and “Txn”

Which of the following will lead to the best run time performance?

Options:

A.

Left links are Hash partitioned on “Account” for all joins

Right links are Hash partitioned on “Account” for all joins

B.

Both left and right links are Hash partitioned as follows:

Join_1 by “Account”, “Customer” and “PO_Date”

Join_2 by “Account”, “Customer” and “Txn”

Join_3 by “Account”, “Product_CD” and “Txn”

C.

Both left and right links are Hash partitioned as follows:

Join_1 by “Account” and “Customer”

Join_2 by “Account” and “Customer”

Join_3 by “Account”

D.

Left links are Hash partitioned on “Account” for the first two joins and on “Product_CD” for the third.

Right links are Hash partitioned on “Account” for all joins

Buy Now
Questions 6

The APT_SubProcessOperator is used for what purpose?

Options:

A.

It allows you to incorporate a third-party executable into the framework

B.

It provides the capability to break predefined operatorsinto sub processes

C.

It provides the capability to define custom operators at the sub process level

D.

It allows you to incorporatecomposite operators, which contain more than one operator

Buy Now
Questions 7

Which statement is TRUE?

Options:

A.

The configuration file needs to be copied to all processing nodes

B.

The configuration file needs to be copied to the conductor nodes and all processing nodes

C.

The configuration file needs to be copied to all nodes to which the parallel engine has been configured

D.

The configuration file only needs to be copied to the conductor nodes from which parallel engine applications are started

Buy Now
Questions 8

The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)

Options:

A.

Join

B.

Merge

C.

Modify

D.

Funnel

E.

Difference

Buy Now
Questions 9

Given this score:

It runs 3 processes on 2 nodes.

How does the job run?

Options:

A.

On two physical nodes and two logical nodes

B.

On two physical nodes and single logical node

C.

On a single physical node and two logical nodes

D.

On a single physical node and single logical node

Buy Now
Exam Code: C2090-424
Exam Name: InfoSphere DataStage v11.3
Last Update: Dec 27, 2024
Questions: 0