IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 41:

  Indicate two possible job design topologies that Information Services Director (ISD) parallel jobs can conform to. (Choose two.)

  A. A job with a single ISD Transformation stage.

  B. A job with one ISD Input stage and no ISD Output stage.

  C. A job with no ISD Input stage and with one ISD Output stage.

  D. A job with greater then one ISD input stage and one ISD Output stage.

  E. A job with one ISD Input stage and greater then one ISD Output stage.

  Correct Answer: BC

• Question 42:

  What are two statistics or attributes that can be added to the output of a Data Rule stage? (Choose two.)

  A. Record ID

  B. System timestamp

  C. Number of violations

  D. Job execution owner

  E. Percentage of violations

  Correct Answer: AB

• Question 43:

  What are two properties dependent of both Column for Calculation and Summary Column for Recalculation? (Choose two.)

  A. Summary

  B. Missing Value

  C. Sum of Squares

  D. Mean Deviation

  E. Coefficient of Variation

  Correct Answer: AB

• Question 44:

  You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed. What are two requirements on the input link data for the Change Capture stage? (Choose two.)

  A. sorted

  B. merged links

  C. parallel mode

  D. key partitioned

  E. sequential mode

  Correct Answer: AD

• Question 45:

  Identify two restructure stages that allow you to create or organize vectors in the output link results? (Choose two.)

  A. Split Vector

  B. Column Import

  C. Merge records

  D. Split Subrecord

  E. Make Subrecord

  Correct Answer: DE

• Question 46:

  What are the two Transfer Protocol Transfer Mode property options for the FTP Enterprise stage? (Choose two.)

  A. FTP

  B. EFTP

  C. TFTP

  D. SFTP

  E. RFTP

  Correct Answer: AD

• Question 47:

  The number of File Set data files created depends upon what two items? (Choose two.)

  A. Amount of memory.

  B. Schema definition of the file.

  C. Operating system limitations.

  D. Number of logical processing nodes.

  E. Number of disks in the export or default disk pool connected to each processing node in the default node pool.

  Correct Answer: DE

• Question 48:

  You are using the Complex Flat File stage as a source in your job. What are two types of data specifically supported by the Complex Flat File stage for your job? (Choose two.)

  A. XML files.

  B. Mainframe data sets with VSAM files.

  C. Mainframe data files with DB2 tables.

  D. Data from files that contain Hadoop record types.

  E. Data from flat files that contain multiple record types.

  Correct Answer: BE

• Question 49:

  Identify two areas that DataStage can integrate with a Hadoop environment. (Choose two.)

  A. Use the Pig Activity stage in a sequencer to invoke a Pig MapReduce program.

  B. Use the Hive Activity stage in a sequences to invoke a Hive MapReduce program.

  C. Use the Big Data File stage to access files on the Hadoop Distributed File System.

  D. Use the Oozie Workflow Activity stage in a sequencer job to invoke Oozie work flows.

  E. Use the MapReduce Transformer stage to convert Hadoop Distributed File System data.

  Correct Answer: CD

• Question 50:

  How does the Complex Flat File stage (CFF) support the use of OCCURS clauses within COBOL files?

  A. Each element of the OCCURS clause is treated as a subrecord.

  B. The CFF stage cannot process COBOL files with OCCURS clauses.

  C. Each element of the OCCURS clause is treated as a column of raw data.

  D. Each element of the OCCURS clause is treated as a separate element in an array.

  Correct Answer: D