Online Access Free 000-303 Exam Questions

In a file defining a partial schema, which two properties define the record? (Choose two.)

• A.length_of_record
• B.record_delim_string
• C.intact
• D.position
• E.delim

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

• A.8
• B.12
• C.16
• D.10

Configuring the weighting column of an Aggregator stage affects which two options. (Choose two.)

• A.Maximum Value
• B.Average of Weights
• C.Coefficient of Variation
• D.Uncorrected Sum of Squares
• E.Sum

You are asked to optimize the fork join job design in the exhibit. This job uses the sort aggregator and a left outer join on the ZIP code column. Currently all partitioning is set to "Auto" and automatic sort insertion is allowed.

Which change will reduce the cost of partitioning that occurs in this job?

• A.Hash partition and sort on ZIP code column on the input links to the Aggregator and Join stages.
• B.Use Entire partitioning on the input links to the Aggregator and Join stages.
• C.Hash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning on the Aggregator and Join stages.
• D.Hash partition and sort on ZIP code column prior to the Copy stage and use entire partitioning on the Aggregator and Join stages.

Which two statements are true about Data Sets? (Choose two.)

• A.Data Sets represent persistent data.
• B.Data sets contain ASCII data.
• C.Data Sets preserve partitioning.
• D.Data Sets require import/export conversions.
• E.Data Sets require repartitioning.