IBM InfoSphere DataStage v11.3 - C2090-424 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which of the following is the default data type for the Aggregator stage during calculation?

A. Decimal B. Double C. Integer D. VarChar

Discussion 0

Correct Answer: B Vote an answer

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

Question 2

Which of the following is an FTP Collection method?

A. Hash B. Sort Merge C. Same D. Random

Discussion 0

Correct Answer: B Vote an answer

Question 3

In order to use Cognos TM1 Connector, which statement is TRUE?

A. Install the Cognos TM1 API component and import the IBM Cognos TM1 certificate and create a property file that stores truststore password B. Installing the Cognos TM1 API component alone is sufficient. C. Install the Cognos TM1 API component and create a property file that stores truststore password D. Import the IBM Cognos TM1 certificate and create a property file that stores truststore password

Discussion 0

Correct Answer: A Vote an answer

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

Question 4

Which restructure stage has a single reject link?

A. Combine Records B. Split Vector C. Make Subrecord D. Column Import

Discussion 0

Correct Answer: A Vote an answer

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

Question 5

Which of the following is TRUE about Transformer Stage when $APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING is set?

A. If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column contains a null. B. If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column will be calculated ignoring the Null value. C. If an input column that is used in the derivation expression of an output column contains a null value, then that row will be dropped or, if a reject link had been defined, rejected D. A Modify Operator is inserted at run time before a Transformer stage to handle null values

Discussion 0

Correct Answer: C Vote an answer

Question 6

Which of the following actions are available when editing a message handler?

A. Demote to warning B. Promote to informational C. Abort Job D. Promote to warning

Discussion 0

Correct Answer: D Vote an answer

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

Question 7

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?

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" and "Customer"
Join_2 by "Account" and "Customer"
Join_3 by "Account" C. 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" 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

Discussion 0

Correct Answer: A Vote an answer