000-415 Exam

- Covers the entire recommended syllabus
- Comprehensive questions and answers about 000-415 exam
- Verified Answers Researched by Industry Experts and almost 100% correct
- 000-415 exam questions updated on regular basis
- Same type as the certification exams, 000-415 exam preparation is in multiple-choice questions (MCQs)
- Tested by multiple times before publishing
- Try free 000-415 exam demo before you decide to buy it in Hiexam
- Technical support through Live Chat or Email

　
　
Exam : IBM 000-415
Title : IBM WebSphere IIS DataStage Enterprise Edition v7.5


1. Your input rows contain customer data from a variety of locations. You want to select just those rows from a specified location based on a parameter value. You are trying to decide whether to use a Transformer or a Filter stage to accomplish this. Which statement is true?
A. You cannot use a Filter stage because you cannot use parameters in a Filter stage Where clause.
B. The Filter stage will yield better performance because it has less overhead than a Transformer stage.
C. The Transformer stage will yield better performance because the Filter stage Where clause is interpreted at runtime.
D. You cannot use the Transformer stage because you cannot use parameters in a Transformer stage constraint.
Answer: C

2. You have a parallel job that does not scale beyond two nodes. After investigation you find that the data has been partitioned on gender and you have an Aggregator stage that is accumulating totals based on gender using a sort method. Which technique should you use to allow the job to scale?
A. Add an additional column for partitioning to result in additional data partitions.
B. Change the aggregation method to hash to eliminate the blocking sort operation.
C. Change the preserve partitioning option on the stage ahead of the aggregator to clear partitioning.
D. Change the partitioning key to one that results in more partitions, add a second Aggregator stage that re-aggregates based on gender.
Answer: D

3. Which three features of datasets make them suitable for job restart points? (Choose three.)
A. They are persistent.
B. They are partitioned.
C. They are indexed for fast data access.
D. They are compressed to minimize storage space.
E. They use datatypes that are in the parallel engine internal format.
Answer: ABE

4. Which "Reject Mode" option in the Sequential File stage will write records to a reject link?
A. Fail
B. Drop
C. Output
D. Continue
Answer: C

5. How are transaction commit operations handled by the DB2/UDB Enterprise stage?
A. Commit operations can be defined globally by setting APT_TRANSACTION_ROWS variable.
B. Commit operations can only be defined by the number of rows since the start of a transaction.
C. Commit operations can only be defined by the number of seconds since the start of a transaction.
D. Transaction commits can be controlled by defining the number of rows per transaction or by a specific time period defined by the number of seconds elapsed between commits.
Answer: D

http://www.Hiexam.com The safer.easier way to get IBM certifications I Certification.