IBM IBM Certifications C2090-424 Questions & Answers

• Question 1:

  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.

  Correct Answer: D

• Question 2:

  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

  Correct Answer: C

• Question 3:

  Which Connector Stage doesn't support reject Link

  A. DB2 Connector

  B. ODBC Connector

  C. Oracle Connector

  D. Netezza Connector

  Correct Answer: B

• Question 4:

  Which of the following is TRUE?

  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

  Correct Answer: D

• Question 5:

  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?

  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"

  Correct Answer: D

• Question 6:

  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

  Correct Answer: D

• Question 7:

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

  A. XML Input

  B. XML Output

  C. XML Connector

  D. XML Transformer

  Correct Answer: C

• Question 8:

  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 DataStage and 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

  Correct Answer: A

• Question 9:

  Which one of the following stages requires a schema file when using Runtime Column Propagation?

  A. Modify Stage

  B. Data Set Stage

  C. Transformer Stage

  D. Sequential File Stage

  Correct Answer: D

• Question 10:

  By default, how much internal memory does the Sort use per partition?

  A. 10MB

  B. 20MB

  C. 25MB

  D. 30MB

  Correct Answer: B