IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 101:

  What is the correct method to process a file containing multiple record types using a Complex Flat File stage?

  A. Flatten the record types into a single record type.

  B. Manually break the file into multiple files by record type.

  C. Define record definitions on the Constraints tab of the Complex Flat File stage.

  D. Load a table definition for each record type on the Records tab of the Complex Flat File stage.

  Correct Answer: D

• Question 102:

  When using the Column Export stage, what are two export column type property values allowed for the combined single output column result? (Choose two.)

  A. Vector

  B. Binary

  C. Integer

  D. Decimal

  E. VarChar

  Correct Answer: BE

• Question 103:

  Which two statements are true about Data Sets? (Choose two.)

  A. Data sets contain ASCII data.

  B. Data Sets preserve partitioning.

  C. Data Sets require repartitioning.

  D. Data Sets represent persistent data.

  E. Data Sets require import/export conversions.

  Correct Answer: BD

• Question 104:

  When using a Sequential File stage as a source what are the two reject mode property options? (Choose two.)

  A. Set

  B. Fail

  C. Save

  D. Convert

  E. Continue

  Correct Answer: BE

• Question 105:

  Identify the two delimiter areas available to be configured in the Sequential File format tab properties? (Choose two.)

  A. File delimiter

  B. Null delimiter

  C. Final delimiter

  D. Field delimiter

  E. End of group delimiter

  Correct Answer: CD

• Question 106:

  Identify the two statements that are true about the functionality of the XML Pack 3.0. (Choose two.)

  A. XML Stages are Plug-in stages.

  B. XML Stage can be found in the Database folder on the palette.

  C. Uses a unique custom GUI interface called the Assembly Editor.

  D. It includes the XML Input, XML Output, and XML Transformer stages.

  E. A single XML Stage, which can be used as a source, target, or transformation.

  Correct Answer: CE

• Question 107:

  Your job will write its output to a fixed length data file. When configuring the sequential file stage as a target what format and column tab properties need to be considered for this type of file output?

  A. On the Output Link format tab, change the 'Delimiter' property to whitespace.

  B. On the Output Link format tab, add the 'Record Type' property to the tree and set its value to be 'F'.

  C. On the Output Link column tab, insure that all the defined column data types are fixed length types.

  D. On the Output Link column tab, specify the record size total based on all of the columns defined

  Correct Answer: C

• Question 108:

  When using Runtime Column Propagation, which two stages require a schema file? (Choose two.)

  A. Peek stage

  B. Pivot stage

  C. Column Import stage

  D. DB2 Connector stage

  E. Sequential File stage

  Correct Answer: CE

• Question 109:

  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 110:

  Which two parallel job stages allow you to use partial schemas? (Choose two.)

  A. Peek stage

  B. File Set stage

  C. Data Set stage

  D. Column Export stage

  E. External Target stage

  Correct Answer: BE