A2090-303 Online Practice Questions and Answers

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. Use Entire partitioning on the input links to the Aggregator and Join stages.

B. Hash partition and sort on ZIP code column 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 entire partitioning on the Aggregator and Join stages.

D. Hash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning on the Aggregator and Join stages.

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. Database

B. Host system

C. Project name

D. Database instance

E. DataStage server system name

Your job will write its output to a fixed length data file. When configuring the sequential file stage as a target what format and column tab properties need to be considered for this type of file output?

A. On the Output Link format tab, change the 'Delimiter' property to whitespace.

B. On the Output Link format tab, add the 'Record Type' property to the tree and set its value to be 'F'.

C. On the Output Link column tab, insure that all the defined column data types are fixed length types.

D. On the Output Link column tab, specify the record size total based on all of the columns defined

In a Transformer, which two mappings can be handled by default type conversions. (Choose two.)

A. Integer input column mapped to raw output column.

B. Date input column mapped to a string output column.

C. String input column mapped to a date output column.

D. String input column mapped to integer output column.

E. Integer input column mapped to string output column.

The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2).Suppose that input_column1 contains a NULL value. Assume the legacy NULL processing option is turned off.

Which behavior is expected?

A. The job aborts.

B. NULL is written to the target stage variable.

C. The input row is either dropped or rejected depending on whether the Transformer has a reject link.

D. The target stage variable is populated with spaces or zeros depending on the stage variable data type.

The parallel framework supports standard and complex data types in the SQL type column tab property. Identify the two complex data types? (Choose two.)

A. Vector

B. VarChar

C. Linked list

D. Subrecord

E. Binary trees

What are two properties dependent of both Column for Calculation and Summary Column for Recalculation? (Choose two.)

A. Summary

B. Missing Value

C. Sum of Squares

D. Mean Deviation

E. Coefficient of Variation

Identify two restructure stages that allow you to create or organize vectors in the output link results? (Choose two.)

A. Split Vector

B. Column Import

C. Split Subrecord

D. Merge records

E. Make Subrecord