C2090-424: InfoSphere DataStage v11.3 - Free download from ExamHUB

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

XML data
Microsoft Word data
Microsoft Excel data
BigInsights HDFS file data

Correct answer: C

Explanation:

Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.unstructureddatastage.usage.doc/topics/uds_extract_data.html

Consider a customer with multiple environments, Development, Test and Production. Which statement is TRUE?

Each environment must have a C++ compiler.
QualityStage rule sets are not a type of deployable asset.
It is not possible to revert to a previous version of a package.
A package can contain an improved version of a job which will replace the old one.

Correct answer: B

Which of the following is TRUE when using a data set created with a 4 node config file?

Data sets are operating system files
Data is stored in a non-persistent form
The data set control file holds all your data
A Data Set stage can have 1 input link and multiple output links

Correct answer: B

Given this configuration file:

Which of the following describes the resulting behavior for a job consisting of Row Generator -> data set?

Conductor, section leader and player processes are executed on the server is1 and is2.
Conductor process is executed on the server is1. Section leader and Player processes are executed on the server is2.
Conductor and section leader processes are executed on the server is1. Player processes are executed on the server is2.
Conductor process and player processes are executed on the server is1. Section leader process is executed on the server is2.

Correct answer: C

Given this score:

It runs 3 processes on 2 nodes.

How does the job run?

On two physical nodes and two logical nodes
On two physical nodes and single logical node
On a single physical node and two logical nodes
On a single physical node and single logical node

Correct answer: D

Which one of the following is an implicit data type conversion?

date -> char
char -> date
varchar -> char
char -> timestamp

Correct answer: D

Which of the following are valid stage options for a parallel DataStage job which uses a configuration file with multiple nodes and a File Connector as a source running in parallel mode? (Choose two.)

Provide a specific file name in the file name property.
In the file name property, provide a file name with a wildcard that matches the existing file names.
Provide a specific file name in the file name property and select the option “Number of Readers Per Node” to be greater than 1.
Set the read method with specific file(s), set the Read From Multiple Nodes = yes, and provide the specific file in the file property.
Set the read method with a file pattern and provide a file name with a wildcard that matches the existing file names in the file pattern property.

Correct answer: CD

Which statement about the ISD input stage is NOT TRUE?

A job must have zero or one ISD input stages
A job with an ISD input stage must have an ISD output stage
Buffer size and timeout values can be supplied as job parameters
Text over JMS binding is only available if you are using Network Deployment

Correct answer: D

Explanation:

Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.infoservdir.user.doc/topics/t_isd_user_configuring_wisd_input_stage.html

Which of the following environment variables can help in verifying whether data is evenly partitioned across all nodes?

$OSH_PRINT_SCHEMAS
$APT_RECORD_COUNTS
$APT_PARTITION_COUNT
$APT_DEBUG_OPERATOR

Correct answer: A

Explanation:

Reference: http://www.element61.be/e/resourc-detail.asp?ResourceId=188

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

A Modify Operator is inserted at run time before a Transformer stage to handle null values
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.
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
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.

Correct answer: C

Vendor:	IBM
Exam Code:	C2090-424
Exam Name:	InfoSphere DataStage v11.3
Date:	Oct 14, 2018
File Size:	295 KB

Download InfoSphere DataStage v11.3.C2090-424.PracticeTest.2018-10-14.31q.vcex

How to open VCEX files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown