IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 111:

  In your DB2 database you have column names that use characters # and $. Which two steps should be completed to allow DataStage to convert these characters into internal format and back as necessary? (Select two)

  A. Set environment variable $DS_ENABLE_RESERVED_NUM_CONVERT to true.
  B. Set environment variable $DS_ENABLE_RESERVED_CHAR_CONVERT to true.
  C. Avoid using the strings_025_and_026_in your IBM DB2 column names.
  D. Avoid using the strings_035_and_036_in your IBM DB2 column names.
  B. Set environment variable $DS_ENABLE_RESERVED_CHAR_CONVERT to true.

• Question 112:

  You are asked by your customer to collect partition level runtime meta-data for DataStage Parallel jobs. You must collect this data after each job completes. What two options allow you to automatically save row counts and CPU time for each instance of an operator? (Select two)

  A. $APT_PERFORMANCE_DATA
  B. $APT_PM_PLAYER_TIMINGS
  C. Enable the job property "Record job performance data".
  D. Enable the job property "Log report messages after each job run".
  B. $APT_PM_PLAYER_TIMINGS
  D. Enable the job property "Log report messages after each job run".

• Question 113:

  You are assigned to correct a job from another developer. The job contains 20 stages sourcing data from two Data Sets and many sequential files. The annotation in the job indicates who wrote the job and when, not the objective of the job. All link and stage names use the default names. One of the output columns has an incorrect value which should have been obtained using a lookup. What could the original developer have done to make this task easier for maintenance purposes?

  A. Named all stage and links the same.
  B. Named all stages and links based on what they do.
  C. Indicated all stage names within the job annotation.
  D. Named all stage and links with column names and ideas.
  B. Named all stages and links based on what they do.

• Question 114:

  Which option is required to identify a particular job player processes?Which option is required to identify a particular job? player processes?

  A. Set $APT_DUMP_SCORE to true.
  B. Set $APT_PM_SHOW_PIDS to true.
  C. Log onto the server and issue the command "ps -ef | grep ds".
  D. Use the DataStage Director Job administration screen to display active player processes.
  B. Set $APT_PM_SHOW_PIDS to true.

• Question 115:

  Which three of the following options does the dsjob command have? (Choose three.)

  A. Stopping a job
  B. Setting an alias for a job
  C. Specifying an appropriate log file
  D. Listing projects,jobs,stages,links,and parameters
  A. Stopping a job
  B. Setting an alias for a job
  D. Listing projects,jobs,stages,links,and parameters

• Question 116:

  Which three statements are true about stage variables? (Select three)

  A. Stage variables cannot contain NULL values.
  B. Stage variables are executed before loop variables.
  C. Stage variables retain their values between rows in the stage.
  D. Stage variables are executed after constraints but before derivations.
  E. A derivation for a stage variable can reference stage variables that are later in the execution order.
  A. Stage variables cannot contain NULL values.
  C. Stage variables retain their values between rows in the stage.
  E. A derivation for a stage variable can reference stage variables that are later in the execution order.

• Question 117:

  You are required to use a Make Vector stage in your job. What three requirements must be met in order to use this stage? (Choose three.)

  A. Columns must be in consecutive order.
  B. Input columns must all be of the same data type.
  C. Input columns must form a numeric sequence.
  D. All columns are combined into a vector of the same length as the number of columns.
  E. Input columns that do not have a name of form 0 to n,where is the column name and 0 andn are the first and last of its consecutive numbers will not be included in the vector and will be dropped.
  B. Input columns must all be of the same data type.
  C. Input columns must form a numeric sequence.
  D. All columns are combined into a vector of the same length as the number of columns.

• Question 118:

  A client has multiple servers connected with a high bandwidth switch and has installed DataStage on one of them. There are five files (with the same record layout) that must be retrieved from three other servers using FTP. Which approach will retrieve and process all five files in the minimal amount of time?

  A. Use a single FTP Enterprise stage and specify five URI properties (one for each file). Next,process the records without landing to disk.
  B. In a single job,use five separate FTP Enterprise stages with output links to a single Sort Funnel stage. Next,process the records withoutlanding to disk.
  C. In a single job,use three separate FTP Enterprise stages (one for each machine) with output links to a single Sort Funnel stage. Next,processthe records without landing to disk.
  D. Create a sequence containing five separate DataStage jobs which each retrieve a single file and append it to a common Data Set. Next,process the resulting Data Set in an sixth DataStage job.
  A. Use a single FTP Enterprise stage and specify five URI properties (one for each file). Next,process the records without landing to disk.

• Question 119:

  The DB2 and Oracle Enterprise stages support logged and non-logged DBMS table operations. What is the non-logged operation that is supported by the DB2 and Oracle Enterprise stages?

  A. Load
  B. Delete
  C. Update
  D. Insert
  A. Load

• Question 120:

  Records in a source file must be aggregated for further processing. Which two conditions would require the use of a Transformer stage instead of or in addition to an Aggregator stage? (Choose two.)

  A. The data hasn't been sorted or grouped.
  B. A global aggregation across all partitions is needed.
  C. The aggregation is a custom formula for your enterprise.
  D. Aggregation results outside of a certain range need to be flagged as abnormal.
  C. The aggregation is a custom formula for your enterprise.
  D. Aggregation results outside of a certain range need to be flagged as abnormal.