Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: cramtreat

Note! Following C2090-424 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

C2090-424 InfoSphere DataStage v11.3 Questions and Answers

Questions 4

When you read or write to a sequential file, and wish to have a value be identified with DataStage as NULL, which of the following is the correct option?

Options:

A.

Set format’s fill char option using the value

B.

Set string type default option using the value

C.

Set format’s null field value option using the value

D.

Set $APT_IMPEXP_REJECT_NULLS using the value

Buy Now
Questions 5

Which partitioning method requires a key?

Options:

A.

Entire

B.

Same

C.

Range

D.

Random

Buy Now
Questions 6

Which of the following is an FTP Collection method?

Options:

A.

Hash

B.

Same

C.

Random

D.

Sort Merge

Buy Now
Questions 7

When building an UPDATE statement in SQL Query builder, which of the following is TRUE?

Options:

A.

Predicates cannot refine what rows are updated

B.

Table(s) referenced must have table definitions imported previously

C.

Column values can be job parameters or input columns but not expressions

D.

Columns to update must be selected individually from the column selection grid

Buy Now
Questions 8

Which type of data can be extracted using the Unstructured Data stage?

Options:

A.

XML data

B.

Microsoft Word data

C.

Microsoft Excel data

D.

BigInsights HDFS file data

Buy Now
Questions 9

Which one of the following is NOT an XML Pack stage?

Options:

A.

XMLInput

B.

XML Output

C.

XML Connector

D.

XML Transformer

Buy Now

IBM Certified Solution Developer |

Exam Code: C2090-424
Exam Name: InfoSphere DataStage v11.3
Last Update: Mar 20, 2024
Questions: 0