Free IBM C2090-418 Exam Dumps Questions & Answers

A DataStage job uses an Inner Join to combine data from two source parallel data sets that were written to disk in sort order based on the join key columns. Which two methods could be used to dramatically improve performance of this job? (Choose two.)

• A.  Explicitly specify hash partitioning and sorting on each input to the Join stage.
• B.  Unset the Preserve Partitioning flag on the output of each parallel data set.
• C.  Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY.
• D.  Add a parallel sort stage before each Join input, specifying the "Don't Sort, Previously Grouped" sort key mode for each key.

You complete a major debugging effort. You would like to catalog the jobs that you modified. What are two ways to determine the jobs that you last modified? (Choose two.)

• A.  Using the advanced find dialog, specify in the last modified panel,the date range of the jobs and appropriate user name.
• B.  Select a folder in your repository tree, right click and choose "Objects that I last modified".
• C.  Check the director for the latest compiled timestamps.
• D.  Sort the jobs by timestamp.

When tuning a parallel process, it is necessary to measure the amount of system resources that are used by each instance of a stage. Which two methods enable the collection of CPU time used by each instance of a stage? (Choose two.)

• A.  Invoke vmstat before the job run and after the job completes.
• B.  Set the environment variable $APT_PM_PLAYER_TIMING=true.
• C.  Set the environment variable $DS_MAKE_JOB_REPORT=2.
• D.  Select the Record job performance data check box from Job Properties.

Your job is using the DB2 Enterprise stage as a target. In this job you are inserting data into a single existing table on a remote database. You are using Run-Time Column Propagation (RCP) on all of the links. Which two job design configuration actions would you consider to effectively use RCP? (Choose two.)

• A.  Use DB2 partitioning properties on the input link to the DB2 Enterprise stage to control column layout in partitions.
• B.  In the DB2 Enterprise stage set the option named "Silently Drop Columns Not In Table" to "True".
• C.  In the DB2 Enterprise stage use Connection properties to manage column mappings.
• D.  Use a Modify stage prior to the DB2 Enterprise stage in order to drop the columns not found in the table.

You have a nullable input column that can be mapped to a non-nullable output column.
Which three NULL handling techniques can be used in the Transformer stage for that column? (Choose three.)

• A.  If IsNull(input_column) then
• B.  NullToEmpty(input_column)
• C.  If input_column = then
• D.  If input_column = NULL then
• E.  NullToValue(input_column)