IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 61:

  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
  A. FTP
  D. SFTP

• Question 62:

  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.
  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.

• Question 63:

  Identify two different types of custom stages you can create to extend the Parallel job syntax? (Choose two.)

  A. Input stage
  B. Basic stage
  C. Group stage
  D. Custom stage
  E. Wrapped stage
  D. Custom stage
  E. Wrapped stage

• Question 64:

  In a Transformer, which two mappings can be handled by default type conversions. (Choose two.)

  A. Integer input column mapped to raw output column.
  B. Date input column mapped to a string output column.
  C. String input column mapped to a date output column.
  D. String input column mapped to integer output column.
  E. Integer input column mapped to string output column.
  D. String input column mapped to integer output column.
  E. Integer input column mapped to string output column.

• Question 65:

  Which DB2 to InfoSphere DataStage data type conversion is correct when reading data with the DB2 Connector stage?

  A. XML to SQL_WVARCHAR
  B. BIGINT to SQL_BIGINT (INT32)
  C. VARCHAR, 32768 to SQL_VARCHAR
  D. CHAR FOR BIT DATA to SQL_VARBINARY
  A. XML to SQL_WVARCHAR

• Question 66:

  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
  A. Summary
  B. Missing Value

• Question 67:

  The data going into the target Sequential File stage is sorted in each partition by the Date field.

  You want the data in the sequential file to be sorted by Date.

  Which collection algorithm should you choose in the Sequential File stage?

  A. Auto
  B. Ordered
  C. Sort Merge
  D. Round Robin
  C. Sort Merge

• Question 68:

  The Score is divided into which two sections? (Choose two.)

  A. Stages
  B. File sets
  C. Schemas
  D. Data sets
  E. Operators
  D. Data sets
  E. Operators

• Question 69:

  In addition to the table and schema names, what two element names must be specified when you create a shared table definition in DataStage Designer? (Choose two.)

  A. Database
  B. Host system
  C. Project name
  D. Database instance
  E. DataStage server system name
  A. Database
  B. Host system

• Question 70:

  Which two environment variables add additional reporting information in the job log for DataStage jobs? (Choose two.)

  A. $APT_IO_MAP
  B. $OSH_EXPLAIN
  C. $APT_STARTUP_STATUS
  D. $APT_EXPORT_FLUSH_COUNT
  E. $APT_PM_STARTUP_CONCURRENCY
  B. $OSH_EXPLAIN
  C. $APT_STARTUP_STATUS