IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 51:

  When using the Sequential File stage as a source, what two property options allow you to add extra columns about the file(s) you are reading onto the output link? (Choose two.)

  A. File Name Column

  B. Percent Null Column

  C. Row number Column

  D. Surrogate Key Column

  E. Number of Records Column

  Correct Answer: AC

• Question 52:

  The parallel framework supports standard and complex data types in the SQL type column tab property. Identify the two complex data types? (Choose two.)

  A. Vector

  B. VarChar

  C. Linked list

  D. Subrecord

  E. Binary trees

  Correct Answer: AD

• Question 53:

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

  Your job is using the Sequential File stage as a source. Identify two stage property configurations that will allow you to accomplish parallel reads? (Choose two.)

  A. Read Method property set to 'File Pattern' and the environment variable $APT_IMPORT_PATTERN_USES_FILESET is set to 'FALSE'.

  B. Read Method property set to 'File Pattern' and the 'Readers per Node' property value set to greater than 1.

  C. Read Method property is set to 'Parallel' with the Key property set to a Input column that has the file names.

  D. Read Method property set to 'Specific File(s)' with only one file specified and the 'Readers Per Node' property value set to greater than 1.

  E. Read Method property set to 'Specific File(s)' with more than one file specified and each file specified has the same format/column properties.

  Correct Answer: DE

• Question 55:

  In a file defining a partial schema, which two properties define the record? (Choose two.)

  A. intact

  B. delim

  C. position

  D. length_of_record

  E. record_delim_string

  Correct Answer: AE

• Question 56:

  What role must a user have to delete shared metadata assets from the repository?

  A. DataStage Administrator

  B. Business Glossary Administrator

  C. Common Metadata Administrator

  D. Information Analyzer Administrator

  Correct Answer: C

• Question 57:

  What are two advantages of using Runtime Column Propagation (RCP)? (Choose two.)

  A. RCP forces a developer to define all columns explicitly.

  B. Only columns used in the data flow need to be defined.

  C. Sequential files don't require schema files when using RCP.

  D. Only columns that are defined as VarChar need RCP enabled.

  E. Columns not specifically used in the flow are propagated as if they were.

  Correct Answer: BE

• Question 58:

  Which statement is true about table definitions created in DataStage Designer?

  A. By default, table definitions created in DataStage Designer are visible to other Information Server products.

  B. Table definitions created in DataStage Designer are local to DataStage and cannot be shared with other Information Server products.

  C. When a table definition is created in one DataStage project, it is automatically available in other DataStage projects, but not outside of DataStage.

  D. Table definitions created in DataStage Designer are not by default available to other Information Server products, but they can be shared with other Information Server products.

  Correct Answer: D

• Question 59:

  The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2).Suppose that input_column1 contains a NULL value. Assume the legacy NULL processing option is turned off.

  Which behavior is expected?

  A. The job aborts.

  B. NULL is written to the target stage variable.

  C. The input row is either dropped or rejected depending on whether the Transformer has a reject link.

  D. The target stage variable is populated with spaces or zeros depending on the stage variable data type.

  Correct Answer: B

• Question 60:

  You are processing groups of rows in a Transformer. The first row in each group contains "1" in the Flag column and "0" in the remaining rows of the group. At the end of each group you want to sum and output the QTY column values. Which technique will enable you to retrieve the sum of the last group?

  A. Output the sum that you generated each time you process a row for which the LastRow() function returns True.

  B. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column.

  C. Output a running total for each group for each row. Follow the Transformer stage by an Aggregator stage. Take the MAX of the QTY column for each group.

  D. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column. Use the FirstRow() function to determine when the group is done.

  Correct Answer: C