Free C2090-424 – InfoSphere DataStage v11.3 Practice Test Question

Select all that apply, then click Submit answer.

• ○

  Join

• ○

  Merge

• ○

  Modify

• ○

  Funnel

• ○

  Difference
  
  

Select all that apply, then click Submit answer.

• ○

  Use the resource estimation tool

• ○

  Use the performance analysis tool

• ○

  Replace Join stages by Lookup stages

• ○

  Run the job with $APT_TRACE_RUN set to true

• ○

  Run the job with $APT_DUMP_SCORE set to true
  
  

Select all that apply, then click Submit answer.

• ○

  Designer

• ○

  ISManager

• ○

  Workload Manager

• ○

  Operations Console

• ○

  Performance Monitor
  
  

Select all that apply, then click Submit answer.

• ○

  Data Set

• ○

  Column Import

• ○

  Internal Source

• ○

  External Target

• ○

  Make Subrecord
  
  

Select all that apply, then click Submit answer.

• ○

  Select the “highperfnodes” pool in the Execution tab of the Job Properties window

• ○

  Add the $APT_CONFIG_FILE environment variable as an additional job parameter

• ○

  Add a Sort stage before the Aggregator stage to sort the data before the data is aggregated

• ○

  Change properties in the Aggregator stage to force it to use the nodes in the appropriate pool

• ○

  Change properties in the Aggregator stage to force it to use the new non-default configuration file
  
  

Select an option, then click Submit answer.

• ○

  Secure sensitive personal data

• ○

  To set up credentials files used by the dsjob command

• ○

  Assisting in decoding encrypted rows of input during debugging

• ○

  Assisting in preparing encrypted rows of output during job execution
  
  

Select an option, then click Submit answer.

• ○

  Surrogate keys are used to join a dimension table to a fact table in a normalized schema database

• ○

  Each SCD stage processes multiple dimensions and performs lookups by using an equality matching

• ○

  Purpose codes are part of the table metadata that the SCD stage propagates to the dimension insert link.

• ○

  Actual dimensions changes are applied to the lookup table in memory and are mirrored to the dimension update link
  
  

Select an option, then click Submit answer.

• ○

  All Rows

• ○

  One Row

• ○

  Zero Rows

• ○

  2000 Rows
  
  

Select an option, then click Submit answer.

• ○

  Multiple parameters and only one value file

• ○

  Only one parameter and only one value file

• ○

  Multiple parameters and multiple value files

• ○

  Only one parameter and multiple value files
  
  

Select an option, then click Submit answer.

• ○

  A job must have zero or one ISD input stages

• ○

  A job with an ISD input stage must have an ISD output stage

• ○

  Buffer size and timeout values can be supplied as job parameters

• ○

  Text over JMS binding is only available if you are using Network Deployment