IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 111:

  What is used to configure the DataStage QualityStage Operations Console?

  A. DataStage Administrator
  B. The DSODBCConfig.cfg file
  C. The DSAppWatcher.sh script
  D. Information Server Web Console
  B. The DSODBCConfig.cfg file

• Question 112:

  Which statement is true when using the SaveInputRecord() function in a Transformer stage.

  A. You can only use the SaveInputRecord() function in Loop variable derivations.
  B. You can access the saved queue records using Vector referencing in Stage variable derivations.
  C. You must retrieve all saved queue records using the GetSavedInputRecord() function within Loop variable derivations.
  D. You must retrieve all saved queue records using the GetSavedInputRecord() function within Stage variable derivations.
  C. You must retrieve all saved queue records using the GetSavedInputRecord() function within Loop variable derivations.

• Question 113:

  Which job design technique can be used to give unique names to sequential output files that are used in multi-instance jobs?

  A. Use parameters to identify file names.
  B. Generate unique file names by using a macro.
  C. Use DSJoblnvocationID to generate a unique filename.
  D. Use a Transformer stage variable to generate the name.
  A. Use parameters to identify file names.

• Question 114:

  You are asked by management to document all jobs written to make future maintenance easier. Which statement is true about annotations?

  A. The short job description can be identified within the Description Annotation stage.
  B. The Description Annotation stage contains both the short and full descriptions for the job.
  C. The background for the Description Annotation stage can be changed for each unique stage.
  D. The Description Annotation stage can be added several times at different locations to identify business logic.
  A. The short job description can be identified within the Description Annotation stage.

• Question 115:

  You are experiencing performance issues for a given job. You are assigned the task of understanding what is happening at run time for that job.

  What step should you take to understand the job performance issues?

  A. Replace Join stages by Lookup stages.
  B. Run the job with $APT_TRACE_RUN set to true.
  C. Run the job with $APT_DUMP_SCORE set to true.
  D. Replace Transformer stages with custom operators.
  C. Run the job with $APT_DUMP_SCORE set to true.

• Question 116:

  In a Transformer expression for a stage variable, there is a nullable input column. Assume the legacy NULL processing option is turned off.

  What happens when a row is processed that contains NULL in that input column?

  A. The job aborts.
  B. The row is rejected.
  C. NULL is written to the stage variable.
  D. The value written to the stage variable is undetermined.
  C. NULL is written to the stage variable.

• Question 117:

  Which statement describes a SCD Type One update in the Slowly Changing Dimension stage?

  A. Adds a new row to the fact table.
  B. Adds a new row to a dimension table.
  C. Overwrites an attribute in the fact table.
  D. Overwrites an attribute in a dimension table.
  D. Overwrites an attribute in a dimension table.

• Question 118:

  What two project environment variables can be considered in your parallel jobs to support your optimization strategy of partitioning and sorting? (Choose two.)

  A. $APT_NO_PART_INSERTION
  B. $APT_OPT_SORT_INSERTION
  C. $APT_RESTRICT_SORT_USAGE
  D. $APT_PARTITION_FLUSH_COUNT
  E. $APT_TSORT_STRESS_BLOCKSIZE
  A. $APT_NO_PART_INSERTION
  E. $APT_TSORT_STRESS_BLOCKSIZE

• Question 119:

  You have a parallel job that based on operational recoverability requirements needs to be broken up into two separate parallel jobs. You have decided to use the Data Set stage to support this job design change. What two characteristics of Data Sets make them a good design consideration in your jobs design change? (Choose two.)

  A. They sort the data in a staging area.
  B. They automatically convert data types.
  C. They persist the parallelism of the job creating them.
  D. They use the same data types as the parallel framework.
  E. They persist parallelism into a temporary repository table.
  C. They persist the parallelism of the job creating them.
  D. They use the same data types as the parallel framework.

• Question 120:

  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