Online Access Free A2090-303 Exam Questions

Which two file stages allow you to configure rejecting data to a reject link? (Choose two.)

• A.Data Set Stage
• B.Compare Stage
• C.Lookup File Set Stage
• D.Complex Flat File Stage
• E.Big Data File Stage

When using the Column Export stage, what are two export column type property values allowed for the combined single output column result? (Choose two.)

• A.Binary
• B.Vector
• C.Decimal
• D.VarChar
• E.Integer

A job design consists of an input Row Generator stage, a Sort stage, followed by a Transformer stage and an output Data Set stage. The job is run on an SMP machine with a configuration file defined with four nodes. The $APT_DISABLE_COMBINATION variable is set to True. How many player processes will this job generate?

• A.13
• B.16
• C.16
• D.7

A DataStage job uses an Inner Join to combine data from two source parallel datasets 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 dataset.
• C.Add a parallel sort stage before each Join input, specifying the "Don't Sort, Previously Grouped" sort key mode for each key.
• D.Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY.
• E.Disable job monitoring.

How does the Complex Flat File stage (CFF) support the use of OCCURS clauses within COBOL files?

• A.Each element of the OCCURS clause is treated as a subrecord.
• B.The CFF stage cannot process COBOL files with OCCURS clauses.
• C.Each element of the OCCURS clause is treated as a column of raw data.
• D.Each element of the OCCURS clause is treated as a separate element in an array.