QUESTION NO: 1
You are asked to optimize the fork join job design in the exhibit. This job uses the sort aggregator and a left outer join on the ZIP code column. Currently all partitioning is set to "Auto" and automatic sort insertion is allowed.
Which change will reduce the cost of partitioning that occurs in this job?
You are asked to optimize the fork join job design in the exhibit. This job uses the sort aggregator and a left outer join on the ZIP code column. Currently all partitioning is set to "Auto" and automatic sort insertion is allowed.
Which change will reduce the cost of partitioning that occurs in this job?
Correct Answer: D
Vote an answer
QUESTION NO: 2
You are editing the configuration file. Which statement is true about file system efficiency?
You are editing the configuration file. Which statement is true about file system efficiency?
Correct Answer: A
Vote an answer
QUESTION NO: 3
Which statement is true about Information Server logging?
Which statement is true about Information Server logging?
Correct Answer: A
Vote an answer
QUESTION NO: 4
A job design consists of an input Row Generator stage, a Filter stage, followed by a Transformer stage and an output Sequential File stage. The job is run on an SMP machine with a configuration file defined with three nodes. The $APT_DISABLE_COMBINATION variable is set to True. How many player processes will this job generate?
A job design consists of an input Row Generator stage, a Filter stage, followed by a Transformer stage and an output Sequential File stage. The job is run on an SMP machine with a configuration file defined with three nodes. The $APT_DISABLE_COMBINATION variable is set to True. How many player processes will this job generate?
Correct Answer: B
Vote an answer
QUESTION NO: 5
You want to find out which table definitions have been loaded into a job, and specifically which stages of the job they has been loaded into? How will you determine this?
You want to find out which table definitions have been loaded into a job, and specifically which stages of the job they has been loaded into? How will you determine this?
Correct Answer: B
Vote an answer
QUESTION NO: 6
Which two actions are available when editing a message handler? (Choose two.)
Which two actions are available when editing a message handler? (Choose two.)
Correct Answer: C,D
Vote an answer
QUESTION NO: 7
In your job you are using a Sequential File stage as a source. You have decided to use a schema file as an alternative way of specifying column definitions and record format properties. What two items are true in configuring this stage in your parallel job? (Choose two.)
In your job you are using a Sequential File stage as a source. You have decided to use a schema file as an alternative way of specifying column definitions and record format properties. What two items are true in configuring this stage in your parallel job? (Choose two.)
Correct Answer: A,E
Vote an answer
QUESTION NO: 8
In a file defining a partial schema, which two properties define the record? (Choose two.)
In a file defining a partial schema, which two properties define the record? (Choose two.)
Correct Answer: A,D
Vote an answer
QUESTION NO: 9
When using a Sequential File stage as a source what are the two reject mode property options? (Choose two.)
When using a Sequential File stage as a source what are the two reject mode property options? (Choose two.)
Correct Answer: B,E
Vote an answer
QUESTION NO: 10
On the DataStage development server, you have been making enhancements to a copy of a DataStage job running on the production server. You have been asked to document the changes you have made to the job. What tool in DataStage Designer would you use?
On the DataStage development server, you have been making enhancements to a copy of a DataStage job running on the production server. You have been asked to document the changes you have made to the job. What tool in DataStage Designer would you use?
Correct Answer: B
Vote an answer