Online Access Free P2090-046 Practice Test

What action will a Lookup Stage take when "Drop" is selected as the Lookup Failure Option?

• A.Stage skips the input record
• B.Job gets aborted
• C.Stage rejects the Input record
• D.Stage reports an error

Which of the following is a standard practice when using partition parallelism?

• A.Setup a configuration file defining multiple CPUs for each logical node
• B.Avoid repartitioning if possible
• C.All of the above
• D.Disable the pipeline parallelism for all the stages that can run in parallel

Which of the following is NOT possible with a Transformer Stage?

• A.Define variables that can be referenced only within the Transformer Stage
• B.Create and compile a custom function to be used in output link derivations
• C.Generate multiple output records for each single record
• D.Use system variables and job parameters within derivations

In DataStage Sequential File Stage, how is a NULL value represented?

• A.By a 'NULL' string
• B.By a space character
• C.As defined by the Developer in the extended properties of the field
• D.A -1 for an integer field and an empty string for a VARCHAR field

The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2). Suppose that input_column1 contains a NULL value. Which behavior is expected?

• A.The input row is either dropped or rejected depending on whether the Transformer has a reject link.
• B.The job aborts.
• C.NULL is written to the target stage variable.
• D.The target stage variable is populated with spaces or zeros depending on the stage variable data type.