We're so confident of our products that we provide no hassle product exchange.
IBM Websphere Datastage V.8.0 Sample Questions:
1. Which three lookup types may be performed in the Lookup stage? (Choose three.)
A) Range on the reject link
B) Range on stream link
C) Negative match
D) Range on the reference link
E) Equality match
2. You have a parallel job that does not scale beyond two nodes. After investigation you find that the data has been partitioned on a DoNotCall flag, which has only "Y" or "N" values, and you have an Aggregator stage that is accumulating totals based on this flag using a sort method. Which two techniques could you use to allow the job to scale? (Choose two.)
A) Change the aggregation method to hash to eliminate the blocking sort operation.
B) Change the preserve partitioning option on the stage ahead of the aggregator to clear partitioning.
C) Add an additional column for partitioning to result in additional data partitions.
D) Change the partitioning method to Round Robin; add a second Aggregator stage, running sequentially, that re-aggregates based on the DoNotCall flag.
3. Which three statements are true about Transfomer stages? (Choose three.)
A) Derivations are written in C++.
B) Stage variables are executed before output link derivations.
C) Constraints can keep a record from being written to an output link.
D) @PARTNUM returns the number of job partitions currently active.
E) Constraints are executed before output link derivations.
4. Click the Exhibit button.
In the exhibit, what describes how you would make a stage run only on "Server2" in parallel?
A) Set node pool constraint to s1.
B) Set server constraint to Server2.
C) Set node pool constraint to s2.
D) Set constraint to n3 and n4.
5. Which three statements describe a DataStage installation in a clustered environment? (Choose three.)
A) DataStage must be installed on the same kind of operating system as the metadata repository.
B) Compiled job and all shared components must be available across all servers.
C) All machines within the cluster must have connectivity to the metadata repository.
D) For clustered implementations, appropriate node pools are useful to reduce data shipping.
E) The conductor node will create the job score and consolidate messages to the DataStage log.
Solutions:
| Question # 1 Answer: B,D,E | Question # 2 Answer: A,D | Question # 3 Answer: B,C,E | Question # 4 Answer: C | Question # 5 Answer: B,D,E |
By Martin
