A2090-303 Online Practice Questions and Answers

Which partitioning method requires a key?

A. Same

B. Modulus

C. Sort Merge

D. Round Robin

Which two parallel job stages allow you to use partial schemas? (Choose two.)

A. Peek stage

B. File Set stage

C. Data Set stage

D. Column Export stage

E. External Target stage

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

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 requirement must be met to read from a database in parallel using the ODBC connector?

A. ODBC connector always reads in parallel.

B. Set the Enable partitioning property to Yes.

C. Configure environment variable $APT_PARTITION_COUNT.

D. Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE.

Which Oracle Connector stage property can be set to tune job performance?

A. Array size

B. Memory size

C. Partition size

D. Transaction size

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

Click on the Exhibit button.

Provided you have enough system resources, what is the maximum number of jobs that could be running concurrently in this image?

A. 2

B. 3

C. 4

D. 5

Each row contains the CustID, ProductID, ProductType and TotalAmount columns. You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a RemoveDuplicates stage. How can this be accomplished?

A. Hash-partition on CustID. Sort on CustID, ProductType and TotalAmount.

B. Hash-partition on TotalAmount. Sort on CustID, ProductType and TotalAmount.

C. Hash-partition on ProductType. Sort on ProductType, CustID and TotalAmount.

D. Hash-partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount.

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.