IBM C2060-350 Online Practice Questions and Exam Preparation

IBM C2060-350 Online Questions & Answers

• Question 1:

  What is the first thing that must be done in order to create a map to use a database as a source in an input card?

  A. Create an MDQ file.
  B. Create a database query.
  C. Create a type tree to match the database table.
  D. Create a functional map using the name and location of the database.
  A. Create an MDQ file.

• Question 2:

  What is the primary difference between a choice group and a partitioned group?

  A. A choice group requires that data must be distinguishable; a partitioned group does not.
  B. A partitioned group requires that data must be distinguishable; a choice group does not.
  C. A choice group can have both items and groups as components; a partition group can only have groups as subtypes.
  D. A partitioned group can contain both items and groups as components; a choice group can only contain groups as components.
  C. A choice group can have both items and groups as components; a partition group can only have groups as subtypes.

• Question 3:

  A map is being developed to process input data that contains invoices and purchase orders. The first five records of the data are provided here:

  

  The characters INV in the second field identify the record as an invoice.

  The characters PO from the second field identify the record as a purchase order. The application requires only processing purchase orders. Which function can be used in the functional map call to process only the purchase orders?

  A. UNIQUE
  B. LOOKUP
  C. CHOOSE
  D. EXTRACT
  D. EXTRACT

• Question 4:

  An application developer needs to split a file consisting of 10 records into 10 output files each with one record. The file name of the output files must contain the record number from the input file. Which two functions can be used in this map to achieve this task?

  A. INDEX and RUN
  B. CHOOSE and GETANDSET
  C. INDEX and SETFILENAME
  D. COUNT and CREATEFILE
  A. INDEX and RUN

• Question 5:

  In this scenario, there is one input file (SOHeader), which contains 200,000 records. The records in SOHeader file are comprised of three fields: SONumber, SOOrdType, and ShipToCustomer. The file is sorted by SOOrdType (ascending order).

  Here is a snapshot of a few records in the file:

  

  What is the MOST EFFICIENT function to use to find the first record where ShipToCustomer = "John"?

  A. LOOKUP()
  B. CHOOSE()
  C. EXTRACT()
  D. SEARCHUP()
  E. SEARCHDOWN()
  D. SEARCHUP()

• Question 6:

  Review the following excerpt from a map trace file:

  

  Which of the following is the MOST LIKELY cause of the error?

  A. The input file contains data not described in the type tree.
  B. The LegacyRecord component was defined with a range of (1:1) instead of (1:s).
  C. The sixth component of LegacyRecord was defined using an incorrect data type.
  D. A component of the LegacyRecord was defined with a range of (1:1) but the data does not appear in the LegacyRecord.
  D. A component of the LegacyRecord was defined with a range of (1:1) but the data does not appear in the LegacyRecord.

• Question 7:

  When a map target is an XML document, which of the following is always TRUE?

  A. When mapping into a Xerces type tree, the schema must be present at run time.
  B. When mapping into a Xerces type tree, the root element of the schema will be the first component of the Global choice group.
  C. When mapping into a native XML schema, empty elements will be created for elements with minOccurs=0 when the rule evaluates to NONE.
  D. When mapping into a native XML schema, namespace references used in the schema will be automatically created in the output instance document.
  D. When mapping into a native XML schema, namespace references used in the schema will be automatically created in the output instance document.

• Question 8:

  If a map contains two input cards with default settings and the second card fails validation, what happens to the map execution?

  A. The map fails.
  B. The map executes successfully.
  C. The map execution continues the mapping process.
  D. Trace and Audit log will turn on to capture the error.
  A. The map fails.

• Question 9:

  Which two of the following statements are TRUE of syntax items? Syntax items:

  A. are limited to 10 bytes.
  B. can only be defined as character data.
  C. can be defined as character or binary data.
  D. are used as separators between portions of data.
  B. can only be defined as character data.
  D. are used as separators between portions of data.

• Question 10:

  Complex objects in a data stream:

  A. are binary.
  B. contain other objects.
  C. must be in a choice group.
  D. contain special characters.
  B. contain other objects.