C2090-424 Dumps C2090-424 Braindumps C2090-424 Real Questions C2090-424 Practice Test C2090-424 Actual Questions IBM C2090-424 InfoSphere DataStage v11.3 https://killexams.com/pass4sure/exam-detail/C2090-424 QUESTION: 58 Archive files can contain assets from multiple exports of multiple tools. When importing into a project from an archive file with the istool command, which order of asset types below would yield the best performance? A. Users and groups, Common metadata, InfoSphere DataStage and QualityStage assets, Reports, Custom attributes for InfoSphere Information Covernance Catalog B. Common metadata, Users and groups, Custom attributes for InfoSphere Information Governance Catalog, InfoSphere DataStageand QualityStage assets, Reports C. Common metadata, Users and groups, Custom attributes for InfoSphere Information Governance Catalog, InfoSphere Data Stage and QualityStage assets D. Users and groups, Common metadata, InfoSphere DataStage and QualityStage assets, Custom attributes for InfoSphere Information Governance Catalog, Reports Answer: A QUESTION: 59 In your project there is a top level Sequencer job which has multiple sub sequencers and jobs. You have to move this Sequencer job to a new project. How do you determine which objects have to be exported? 37 A. Select top level sequencer job and click on "Export" option B. Select top level sequencer job and click on "Find dependencies" option C. Select top level sequencer job and click on "Find dependencies (deep)" option D. Select top level sequencer job and click on "Edit->Job Properties -> Dependencies" Answer: D QUESTION: 60 For very large records, you may need to set the following environment variable with an appropriate value in order to allow the job to run successfully: A. $APT_MONITOR_SIZE B. $APT_RECORD_COUNTS C. $APT_DISABLE_COMBINATION D. $APT_DEFAULT_TRANSPORT_BLOCK_SIZE Answer: D QUESTION: 61 Which of the following is TRUE? 38 A. The Modify stage can keep or drop records B. The DB2 Connector stage can have, at most, one input link C. The Copy stage can be used for implicit data type conversions D. When runtime column propagation is enabled, you can use output mapping on a stage to rename or drop columns Answer: D Reference: https://www- 01.ibm.com/support/knowledgecenter/SSZJPZ_9.1.0/com.ibm.swg.im.iis.conn.oracon.usage.doc/t opics/r_runtime_column_propagation.html(Useage). QUESTION: 62 Which Connector Stage doesn't support reject Link A. DB2 Connector B. ODBC Connector C. Oracle Connector D. Netezza Connector Answer: B 39 Explanation: Reject links are not supported by any connectivity source stage. This includes the Px Sybase, Px ODBC, Px DB2Z, Px Classic Federation stages,Px DB2and Px Oracle stages. QUESTION: 63 password to Info1234 for user srv_etl in the Information Server internal Select the correct command to reset a 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 Answer: C QUESTION: 64 Which of the following statements about real time job design is TRUE? A. DSJobInvocationId is not required for the target sequential file. B. A non-Multiple Instance DataStage job can be activated for ISD service. C. A DataStage job must have an ISD Input stage, but an ISD Output stage is not required. D. The Information Services Director server starts job instances on one or more DataStage servers for load balancing and scalability. 40 Answer: D Reference: https://www- 01.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.infoservdir.user.doc/topi cs/c_isd_user_ds_qs_job_topologies.html(See 2nd paragraph). 41 6$03/( 48(67,216 7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\ )XOO YHUVLRQ LV XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV .LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ H[DP SUHSDUDWLRQ 7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV H[DP GXPSV DQG SUDFWLFH WHVWV WR KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH +HUH DUH VRPH NH\ IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP $FWXDO ([DP 4XHVWLRQV .LOOH[DPV FRP SURYLGHV DFWXDO H[DP TXHVWLRQV WKDW DUH H[SHULHQFHG LQ WHVW FHQWHUV 7KHVH TXHVWLRQV DUH XSGDWHG UHJXODUO\ WR HQVXUH WKH\ DUH XS WR GDWH DQG UHOHYDQW WR WKH ODWHVW H[DP V\OODEXV %\ VWXG\LQJ WKHVH DFWXDO TXHVWLRQV FDQGLGDWHV FDQ IDPLOLDUL]H WKHPVHOYHV ZLWK WKH FRQWHQW DQG IRUPDW RI WKH UHDO H[DP ([DP 'XPSV .LOOH[DPV FRP RIIHUV H[DP GXPSV LQ 3') IRUPDW 7KHVH GXPSV FRQWDLQ D FRPSUHKHQVLYH FROOHFWLRQ RI TXHVWLRQV DQG DQVZHUV WKDW FRYHU WKH H[DP WRSLFV %\ XVLQJ WKHVH GXPSV FDQGLGDWHV FDQ HQKDQFH WKHLU NQRZOHGJH DQG LPSURYH WKHLU FKDQFHV RI VXFFHVV LQ WKH FHUWLILFDWLRQ H[DP 3UDFWLFH 7HVWV .LOOH[DPV FRP SURYLGHV SUDFWLFH WHVWV WKURXJK WKHLU GHVNWRS 9&( H[DP VLPXODWRU DQG RQOLQH WHVW HQJLQH 7KHVH SUDFWLFH WHVWV VLPXODWH WKH UHDO H[DP HQYLURQPHQW DQG KHOS FDQGLGDWHV DVVHVV WKHLU UHDGLQHVV IRU WKH DFWXDO H[DP 7KH SUDFWLFH WHVWV FRYHU D ZLGH UDQJH RI TXHVWLRQV DQG HQDEOH FDQGLGDWHV WR LGHQWLI\ WKHLU VWUHQJWKV DQG ZHDNQHVVHV *XDUDQWHHG 6XFFHVV .LOOH[DPV FRP RIIHUV D VXFFHVV JXDUDQWHH ZLWK WKHLU H[DP GXPSV 7KH\ FODLP WKDW E\ XVLQJ WKHLU PDWHULDOV FDQGLGDWHV ZLOO SDVV WKHLU H[DPV RQ WKH ILUVW DWWHPSW RU WKH\ ZLOO UHIXQG WKH SXUFKDVH SULFH 7KLV JXDUDQWHH SURYLGHV DVVXUDQFH DQG FRQILGHQFH WR LQGLYLGXDOV SUHSDULQJ IRU FHUWLILFDWLRQ H[DPV 8SGDWHG &RQWHQW .LOOH[DPV FRP UHJXODUO\ XSGDWHV LWV TXHVWLRQ EDQN DQG H[DP GXPSV WR HQVXUH WKDW WKH\ DUH FXUUHQW DQG UHIOHFW WKH ODWHVW FKDQJHV LQ WKH H[DP V\OODEXV 7KLV KHOSV FDQGLGDWHV VWD\ XS WR GDWH ZLWK WKH H[DP FRQWHQW DQG LQFUHDVHV WKHLU FKDQFHV RI VXFFHVV 7HFKQLFDO 6XSSRUW .LOOH[DPV FRP SURYLGHV IUHH [ WHFKQLFDO VXSSRUW WR DVVLVW FDQGLGDWHV ZLWK DQ\ TXHULHV RU LVVXHV WKH\ PD\ HQFRXQWHU ZKLOH XVLQJ WKHLU VHUYLFHV 7KHLU FHUWLILHG H[SHUWV DUH DYDLODEOH WR SURYLGH JXLGDQFH DQG KHOS FDQGLGDWHV WKURXJKRXW WKHLU H[DP SUHSDUDWLRQ MRXUQH\ 'PS .PSF FYBNT WJTJU IUUQT LJMMFYBNT DPN WFOEPST FYBN MJTU .LOO \RXU H[DP DW )LUVW $WWHPSW *XDUDQWHHG