A2090-303 Online Practice Questions and Answers

When using Runtime Column Propagation, which two stages require a schema file? (Choose two.)

A. Peek stage

B. Pivot stage

C. Column Import stage

D. DB2 Connector stage

E. Sequential File stage

Which statement describes what happens when Runtime Column Propagation is disabled for a parallel job?

A. An input column value flows into a target column only if it matches it by name.

B. An input column value flows into a target column only if it is explicitly mapped to it.

C. You must set APT_AUTO_MAP project environment to true to allow output link mapping to occur.

D. An input column value flows into a target column based on its position in the input row. For example, first column in the input row goes into the first target column.

Which method is used to specify when to stop a job because of too many rejected rows with an ODBC Connector?

A. In the Abort when field, select Max

B. In the Abort when field, select Rows

C. In the Abort when field, select Count

D. In the Abort when field, select Amount

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.

Identify two areas that DataStage can integrate with a Hadoop environment. (Choose two.)

A. Use the Pig Activity stage in a sequencer to invoke a Pig MapReduce program.

B. Use the Hive Activity stage in a sequences to invoke a Hive MapReduce program.

C. Use the Big Data File stage to access files on the Hadoop Distributed File System.

D. Use the Oozie Workflow Activity stage in a sequencer job to invoke Oozie work flows.

E. Use the MapReduce Transformer stage to convert Hadoop Distributed File System data.

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.

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 the valid join operations for the Join stage? (Choose two.)

A. Inner join

B. Where join

C. Top outer join

D. Right outer join

E. Bottom inner join

Click the Exhibit button.

The job in the exhibit runs to successful completion with no warnings. However, a validation test identifies that the CUSTOMER_MASTER table is empty. You suspect the cause to be related to the NEW_CUSTOMERS table or a defect in the job. Examining runtime metadata may help you track down the problem. Which two product features will help you isolate the cause of the problem? (Choose two.)

A. Director job monitor tool.

B. Designer Performance Analyzer tool.

C. Designer "Show performance statistics" option.

D. The view data button in the target Connector stage.

E. InfoSphere Metadata Asset Manager (IMAM) operational metadata reports.