A2090-303 Online Practice Questions and Answers

In your ETL application design you have found several areas of common processing requirements in the mapping specifications. These common logic areas found include: code validation lookups and name formatting. The common logic areas have the same logic, but the jobs using them would have different column metadata. Choose the action that gives you the best reusability design to effectively implement these common logic areas in your ETL application?

A. Create parallel routines for each of the common logic areas and for each of the unique column metadata formats.

B. Create separate jobs for each layout and choose the appropriate job to run within a job sequencer.

C. Create parallel shared containers and define columns combining all data formats.

D. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary common columns needed for the logic.

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 statements are true about Data Sets? (Choose two.)

A. Data sets contain ASCII data.

B. Data Sets preserve partitioning.

C. Data Sets require repartitioning.

D. Data Sets represent persistent data.

E. Data Sets require import/export conversions.

Which job design technique can be used to give unique names to sequential output files that are used in multi-instance jobs?

A. Use parameters to identify file names.

B. Generate unique file names by using a macro.

C. Use DSJoblnvocationID to generate a unique filename.

D. Use a Transformer stage variable to generate the name.

You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed. What are two requirements on the input link data for the Change Capture stage? (Choose two.)

A. sorted

B. merged links

C. parallel mode

D. key partitioned

E. sequential mode

What are two statistics or attributes that can be added to the output of a Data Rule stage? (Choose two.)

A. Record ID

B. System timestamp

C. Number of violations

D. Job execution owner

E. Percentage of violations

In your parallel job design you have selected a parallel shared container to be included. Which area of your job design is required to be configured to use the parallel shared container?

A. List the jobs that will be allowed to use the container.

B. Configure your job properties General tab "Allow Container" option to be True.

C. Configure the job name reference the parallel shared container originates from.

D. Configure the number of input and/or output links to support the parallel shared container.

Modular development techniques should be used to maximize re-use of DataStage jobs and components. Which statement represents Modular Development techniques?

A. Job parameters should be used in Job Names.

B. Hard code the Invocation ID to improve development process.

C. Create a standard directory structure inside of the DataStage project directory for source and target files.

D. Job parameterization allows a single job design to process similar logic instead of creating multiple copies of the same job.

You have made a copy of your job and made major changes to a job in your project. You now want to identify all the changes that have been made. What task will allow you to identify these changes?

A. Export the original job to a backup directory.

B. Export the modified job to the backup directory.

C. Select the job, then right click Compare against.

D. Select the job, then right click Cross Project Compare.

A job design consists of an input Sequential Files stage, a Sort stage, followed by a Transformer stage and an output Sequential File stage. In the input Sequential Files stage, the "Number of readers per node" property has been set to 3. The job is run on an SMP machine with a configuration file defined with 3 nodes. The $APT_DISABLE_COMBINATION variable is set to True. How many player processes will this job generate?

A. 6

B. 8

C. 10

D. 12