A2090-303 Online Practice Questions and Answers

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 stage and links the same.

B. Name all stages and links based on what they do.

C. Indicate all stage names within the job annotation.

D. Name all stage and links with column names and ideas.

You are responsible for deploying objects into your customers production environment. To ensure the stability of the production system the customer does not permit compilers on production machines. They have also protected the project and only development machines have the required compiler. What option will enable jobs with a parallel transformer to execute in the customers production machines?

A. Add $APT_COMPILE_OPT=-portable

B. Set $APT_COPY_TRANSFORM_OPERATOR

C. Use protected projects in the production environment.

D. Create a package with Information Server Manager and select the option to include executables.

You are asked by your customer to collect partition level runtime metadata for DataStage parallel jobs. You must collect this data after each job completes. What two options allow you to automatically save row counts and CPU time for each instance of an operator? (Choose two.)

A. $APT_CPU_ROWCOUNT

B. $APT_PERFORMANCE_DATA

C. Enable the job property "Record job performance data".

D. Open up the job in Metadata Workbench and select the "Data Lineage" option.

E. Click the Performance Analysis icon in the toolbar to open the Performance Analyzer utility.

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

A. Data Set Stage

B. Compare Stage

C. Big Data File Stage

D. Lookup File Set Stage

E. Complex Flat File Stage

Identify two different types of custom stages you can create to extend the Parallel job syntax? (Choose two.)

A. Input stage

B. Basic stage

C. Group stage

D. Custom stage

E. Wrapped stage

Which statement describes a SCD Type One update in the Slowly Changing Dimension stage?

A. Adds a new row to the fact table.

B. Adds a new row to a dimension table.

C. Overwrites an attribute in the fact table.

D. Overwrites an attribute in a dimension table.

The number of File Set data files created depends upon what two items? (Choose two.)

A. Amount of memory.

B. Schema definition of the file.

C. Operating system limitations.

D. Number of logical processing nodes.

E. Number of disks in the export or default disk pool connected to each processing node in the default node pool.

Which statement is true about improving job performance when using Balanced Optimization?

A. Convert a job to use bulk staging tables for Big Data File stages.

B. Balance optimization attempts to balance the work between the source server, target sever, and the job.

C. If the job contains an Aggregator stage, data reduction stages will be pushed into a target data server by default.

D. To ensure that a particular stage can only be pushed into a source or target connector, you can set the Stage Affinity property to source or target.

Which option is required to identify a particular job player processes?Which option is required to identify a particular job? player processes?

A. Set $APT_DUMP_SCORE to true.

B. Set $APT_PM_SHOW_PIDS to true.

C. Log onto the server and issue the command "ps -ef | grep ds".

D. Use the DataStage Director Job administration screen to display active player processes.

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

B. 4

C. 6

D. 8