Online Access Free 000-303 Practice Test

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 prior to the Copy stage and use entire partitioning on the Aggregator and Join stages.
• B.Hash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning on the Aggregator and Join stages.
• C.Use Entire partitioning on the input links to the Aggregator and Join stages.
• D.Hash partition and sort on ZIP code column on the input links to the Aggregator and Join stages.

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

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

You are assigned to correct a job from another developer. The job contains 20 stages sourcing data from two Data Sets and many sequential files. The annotation in the job indicates who wrote the job and when, not the objective of the job. All link and stage names use the default names. One of the output columns has an incorrect value which should have been obtained using a lookup. What could the original developer have done to make this task easier for maintenance purposes?

• A.Name all stages and links based on what they do.
• B.Name all stage and links the same.
• C.Name all stage and links with column names and ideas.
• D.Indicate all stage names within the job annotation.

In addition to the table and schema names, what two element names must be specified when you create a shared table definition in DataStage Designer? (Choose two.)

• A.Project name
• B.DataStage server system name
• C.Database instance
• D.Database
• E.Host system

Which requirement must be met to read from a database in parallel using the ODBC connector?

• A.ODBC connector always reads in parallel.
• B.Configure environment variable $APT_PARTITION_COUNT.
• C.Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE.
• D.Set the Enable partitioning property to Yes.