A Parameter Set is a named object that can contain which of the following?

Parallel job column definitions have an SQL type associated with them. Which of the following is TRUE?

Your job aggregates data before writing the results out to a DB2 table. You have since learned that this job will
be required to aggregate very large amounts of data. To ensure high performance you create a new, nondefault
configuration file for the job that defines a node pool named “highperfnodes” that includes only nodes with very
high processing power. What additional design changes do you need to make to the job to ensure that it
aggregates the data using the “highperfnodes” pool? (Choose two.)

In order to use Cognos TM1 Connector, which statement is TRUE?

Which of the following locations will allow you to obtain a job’s runtime logs? (Choose two.)

What COBOL data type is defined by Decimal data within the Complex Flat File stage?

Which client Tool is used to export environment variables from a Project?

You want to retain the record with the largest value in the TotalAmount column for each CustID and
ProductType using a Remove Duplicates stage. How can this be accomplished?

A job is designed with 3 Join stages in sequence. Join_1 keys are “Account”, “Customer” and “PO_Date”
Join_2 keys are “Account”, “Customer” and “Txn” Join_3 keys are “Account”, “Product_CD” and “Txn”
Which of the following will lead to the best run time performance?

Which statement about shared containers is TRUE?