PDF Version DemoIBM InfoSphere DataStage v9.1 Sample Questions:
1. A DataStage job uses an Inner Join to combine data from two source parallel datasets that were written to disk in sort order based on the join key columns. Which two methods could be used to dramatically improve performance of this job? (Choose two.)
A) Explicitly specify hash partitioning and sorting on each input to the Join stage.
B) Add a parallel sort stage before each Join input, specifying the "Don't Sort, Previously Grouped" sort key mode for each key.
C) Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY.
D) Disable job monitoring.
E) Unset the Preserve Partitioning flag on the output of each parallel dataset.
2. A customer must compare a date column with a job parameter date to determine which output links the row belongs on. What stage should be used for this requirement?
A) Filter stage
B) Transformer stage
C) Compare stage
D) Switch stage
3. Which two statements about the Additional Connections Options property in the Teradata Connector stage to specify details about the number of connections to Teradata are true? (Choose two.)
A) Total requested sessions equals sessions per player multiplied by number of nodes multiplied by players per node. The default value is 4.
B) Requestedsessions is a number between 1 and the number of vprocs in the operating system.
C) The default for requestedsessions is the maximum number of available sessions.
D) Sessionsperplayer determines the number of connections each player in the job has to Teradata.
E) The default for requestedsessions is the minimum number of available sessions.
4. Configuring the weighting column of an Aggregator stage affects which two options. (Choose two.)
A) Uncorrected Sum of Squares
B) Maximum Value
C) Coefficient of Variation
D) Average of Weights
E) Sum
5. Suppose a user ID has been created with DataStage and QualityStage component authorization. Which client application would be used to give that user ID DataStage Developer permission?
A) DataStage Administrator client
B) Information Server Web Console Administrator client
C) DataStage Designer client
D) DataStage Director client
Solutions:
| Question # 1 Answer: B,C | Question # 2 Answer: B | Question # 3 Answer: C,D | Question # 4 Answer: A,E | Question # 5 Answer: A |
We are confident about the products and aim to help you pass with ease. In case of failure, we will provide a no hassle full money back guarantee for the purchasing fee.
1425 Customer Reviews
Quality and ValueITbraindumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITbraindumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITbraindumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.