C2090-424 exam

Which of the following is the default data type for the Aggregator stage during calculation?A . IntegerB . DoubleC . VarCharD . DecimalView AnswerAnswer: B Explanation: Reference: https://datastage4u.wordpress.com/2011/04/27/the-aggregator-stage-datastage/

Given this score: It runs 3 processes on 2 nodes. How does the job run?A . On two physical nodes and two logical nodesB . On two physical nodes and single logical nodeC . On a single physical node and two logical nodesD . On a single physical node and...

Which statement about looping in sequences is TRUE?A . The Start Loop stage only supports numeric loopsB . Numeric loops must increment by one unless you supply a parameterC . The current loop counter value can be passed to the stages in the loopD . The compiler will insert an...

Which statement about the ISD input stage is NOT TRUE?A . A job must have zero or one ISD input stagesB . A job with an ISD input stage must have an ISD output stageC . Buffer size and timeout values can be supplied as job parametersD . Text over...

Which type of data can be extracted using the Unstructured Data stage?A . XML dataB . Microsoft Word dataC . Microsoft Excel dataD . BigInsights HDFS file dataView AnswerAnswer: 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

Which of the following actions are available when editing a message handler?A . Abort JobB . Demote to warningC . Promote to warningD . Promote to informationalView AnswerAnswer: C Explanation: Reference: http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_8.5.0/ com.ibm.swg.im.iis.ds.design.help.doc/topics/editmessagehandlerswindow.html

Assume you have before and after data sets and want to identify and process all of the changes between the two data sets. Assuming data is properly partitioned and sorted, which of the following should be used?A . DifferenceB . Change ApplyC . Change CaptureD . Change Capture and Change...

Which one of the following is an implicit data type conversion?A . date -> charB . char -> dateC . varchar -> charD . char -> timestampView AnswerAnswer: D

Which of the following environment variables can help in verifying whether data is evenly partitioned across all nodes?A . $OSH_PRINT_SCHEMASB . $APT_RECORD_COUNTSC . $APT_PARTITION_COUNTD . $APT_DEBUG_OPERATORView AnswerAnswer: A Explanation: Reference: http://www.element61.be/e/resourc-detail.asp?ResourceId=188

Which statement about restartable sequence jobs is TRUE?A . If a restartable sequence aborts, it can be restarted from Director.B . Choosing “Reset job” from Director will start the job where it left off.C . Checkpoints are always added to every eligible Job Activity stage in the sequence.D . There...