C2090-424 Real Exam
Question: 1
When building an UPDATE statement in SQL Query builder, which of the following is TRUE?
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
Answer: D
Question: 2
Which type of data can be extracted using the Unstructured Data stage?
A.XML data
B.Microsoft Word data
C.Microsoft Excel data
D.BigInsights HDFS file data
Answer: C
Reference:
https://www01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.unstructur
eddatastage.usage.doc/topics/uds_extract_data.html
Question: 3
Record Count property is set to zero in Connector stage. How many rows are written out?
A.All Rows
B.One Row
C.Zero Rows
D.2000 Rows
Answer: A
Reference:
http://www01.ibm.com/support/knowledgecenter/SSZJPZ_8.7.0/com.ibm.swg.im.iis.conn.db2db.hel
p.doc/topics/props_input_db2.html?lang=en
Question: 4
In the Masking Policy Editor in the Data Masking stage of your job, you have specified for a
column containing credit card numbers the Random Replacement masking policy. For the Copy
option you have specified "(1,2)(3,4)".
What changes will be made to a credit card number, such as 6327664369, to mask it?
A.Digits 1 through 2 and digits 3 through 4 will be randomly changed. The rest of the digits will
remain the same.
B.Digits 1 through 2 and digits 3 through 4 will remain the same. The rest of the digits will be
randomly changed.
C.The 2 digits starting at digit 1 and the 4 digits starting at digit 3 will remain the same. The rest of the
digits will be randomly changed.
D.The 2 digits starting at digit 1 and the 4 digits starting at digit 3 will be randomly changed. The rest
of the digits will remain the same.
Answer: D
Question: 5
Which of the following is TRUE about Transformer Stage when
$APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING is set?
A.A Modify Operator is inserted at run time before a Transformer stage to handle null values
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 contains a null.
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.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.
Answer: C
Question: 6
Which of the following is the correct schema format for a Time column?
A.record (tField:time[hour:minute:second];)
B.record (tField:nullable time[];)
C.record (tField:time[seconds];)
D.record (tField:time[microseconds];)
Answer: C
Reference:
https://www01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.parjob.dev
.doc/topics/r_deeref_Time_Columns.html
Question: 7
Which statement about shared containers is TRUE?
A.A shared container is an independently compiled unit
B.A local container can be converted to a shared container
C.A shared container can be converted to a local container
D.A container cannot be created by selecting a group of stages and links in a job
Answer: B
Reference:
https://www01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.design.doc
/topics/t_ddesref_Converting_Containers.html
Question: 8
How do you create a shared table definition from the DataStage client?
A.Use the save button on the columns tab of the stage editor
B.Use the shared table creation wizard from the repository window
C.Do nothing. They are created automatically when table definitions are imported
D.It cannot be done within the DataStage client. Use the InfoSphere Metadata Asset Manager
(IMAM) utility instead.
Answer: B
Question: 9
Your job consists of a DB2 Connector stage followed by a Sort stage followed by a Transformer
stage followed by another DB2 Connector stage.
The following two Balanced Optimizer options have been selected:
Push processing to data sources
Push processing to data targets
The following two Balanced Optimizer options have NOT been selected:
Push data reduction processing to data targets
Push all processing into the (target) data server
Assuming the job design allows for maximum optimization, what does the optimized job design look
like?
A.Row Generator stage followed by a DB2 Connector stage
B.DB2 Connector stage followed by a DB2 Connector stage
C.DB2 stage followed by a Transformer stage followed by a DB2 Connector stage
D.DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another
DB2 Connector stage
Answer: A
Question: 10
Select the correct command to reset a password to Info1234 for user srv_etl in the
Information Server internal registry, in the Unix environment.
A.iisAdmin.sh -user srv_etl -password Info1234
B.iisAdmin.sh -user -userid srv_etl -password Info1234
C.SessionAdmin.sh -user -userid srv_etl -password Info1234
D.DirectoryAdmin.sh -user -userid srv_etl -password Info1234