To run multiple copies of the same job within Director, which of the following must be supplied?
A. Job name
B. Invocation ID
C. Parameter values
D. Username and password
Which restructure stage has a single reject link?
A. Split Vector
B. Column Import
C. Make Subrecord
D. Combine Records
How do you create a shared table definition from the DataStage client?
A. Use the save button on the columns tab of the stage editor
B. Use the shared table creation wizard from the repository window
C. Do nothing. They are created automatically when table definitions are imported
D. It cannot be done within the DataStage client. Use the InfoSphere Metadata Asset Manager (IMAM) utility instead.
You are experiencing performance issues for a given job. You are assigned the task of understanding what is happening at run time for that job.
What steps should you take to understand the job performance issues? (Choose two.)
A. Use the resource estimation tool
B. Use the performance analysis tool
C. Replace Join stages by Lookup stages
D. Run the job with $APT_TRACE_RUN set to true
E. Run the job with $APT_DUMP_SCORE set to true
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. Hash partition on TotalAmount. Sort on CustID, ProductType and TotalAmount
B. Hash partition on ProductType. Sort on CustID, ProductType and TotalAmount
C. Hash partition on CustID and ProductType. Sort on CustID, ProductType and TotalAmount
D. Hash partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount
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 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.)
A. Select the "highperfnodes" pool in the Execution tab of the Job Properties window
B. Add the $APT_CONFIG_FILE environment variable as an additional job parameter
C. Add a Sort stage before the Aggregator stage to sort the data before the data is aggregated
D. Change properties in the Aggregator stage to force it to use the nodes in the appropriate pool
E. Change properties in the Aggregator stage to force it to use the new non-default configuration file
Parallel job column definitions have an SQL type associated with them. Which of the following is TRUE?
A. Use the SQL type when specifying a schema via a file
B. The SQL type is what the parallel job data set understands
C. Use the Parallel tab of the Edit Column Meta Data dialog box to view the SQL type
D. The SQL type is mapped to an underlying data type that the parallel job data set understands
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 one parameter and multiple value files
In your project there is a top level Sequencer job which has multiple sub sequencers and jobs. You have to move this Sequencer job to a new project. How do you determine which objects have to be exported?
A. Select top level sequencer job and click on "Export" option
B. Select top level sequencer job and click on "Find dependencies" option
C. Select top level sequencer job and click on "Find dependencies (deep)" option
D. Select top level sequencer job and click on "Edit->Job Properties -> Dependencies"
For very large records, you may need to set the following environment variable with an appropriate value in order to allow the job to run successfully:
A. $APT_MONITOR_SIZE
B. $APT_RECORD_COUNTS
C. $APT_DISABLE_COMBINATION
D. $APT_DEFAULT_TRANSPORT_BLOCK_SIZE
