Which one of the following stages requires a schema file when using Runtime Column Propagation? A. Modify Stage B. Data Set Stage C. Transformer Stage D. Sequential File Stage
Archive files can contain assets from multiple exports of multiple tools. When importing into a project from an archive file with the istool command, which order of asset types below would yield the best performance? A. Users and groups, Common…
By default, how much internal memory does the Sort use per partition? A. 10MB B. 20MB C. 25MB D. 30MB
Which Slowly Changing Dimension (SCD) stage statement is TRUE? A. Surrogate keys are used to join a dimension table to a fact table in a normalized schema database B. Each SCD stage processes multiple dimensions and performs lookups by using…
A Parameter Set is a named object that can contain which of the following? A. Multiple parameters and only one value file B. Only one parameter and only one value file C. Multiple parameters and multiple value files D. Only…
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, non-default configuration…
In order to use Cognos TM1 Connector, which statement is TRUE? A. Installing the Cognos TM1 API component alone is sufficient. B. Import the IBM Cognos TM1 certificate and create a property file that stores truststore password C. Install the…
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…
Which statement about shared containers is TRUE? A. A shared container is an independently compiled unit B. A local container can be converted to a shared container C. A shared container can be converted to a local container D. A…
Which of the following is the correct schema format for a Time column? A. record (tField:time[hour:minute:second];) B. record (tField:nullable time[];) C. record (tField:time;) D. record (tField:time[microseconds];)