IBM Assessment: IBM InfoSphere DataStage v9.1 Assessment Sample Questions:
1. The effective use of naming conventions means that objects need to be spaced appropriately on the DataStage Designer canvas. For stages with multiple links,expanding the icon border can significantly improve readability. This approach takes extra effort at first, so a pattern of work needs to be identified and adopted to help development. Which feature of Designer can improve development speed?
A) Show Performance Statistics Feature
B) Repository Layout
C) Snap to Grid Feature
D) Palette Layout
2. In the exhibit, a Funnel stage has two input links. Input 1 (Seq_File) comes from a Sequential File stage with "Readers per Node" set to "2". Input 2 (Dataset) comes from a dataset created with 3 partitions. In the Funnel stage, the funnel type is set to "Sequence".
The parallel configuration file contains 4 nodes. How many instances of the Funnel stage run in parallel?
A) 4
B) 2
C) 6
D) 1
3. When using the loop functionality in a transformer, which statement is true regarding Transformer processing.
A) Stage variables can be referenced in loop conditions.
B) Output links can be excluded from being associated with a True loop condition.
C) Stage variables can be executed after loop variable expressions.
D) Loop variable expressions are executed before input link column expressions.
4. You are working on a project that contains a large number of jobs contained in many folders. You would like to review the jobs created by a former developer of the project. How can you find these jobs?
A) Select the top project folder and choose Find Dependencies (deep).
B) Right-click on jobs folder in the Repository window and select Filter jobs.
C) Sort the jobs by date in the Repository window.
D) Use Advanced Find feature in the Designer interface.
5. 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?
A) Use Entire partitioning on the input links to the Aggregator and Join stages.
B) Hash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning on the Aggregator and Join stages.
C) Hash partition and sort on ZIP code column prior to the Copy stage and use entire partitioning on the Aggregator and Join stages.
D) Hash partition and sort on ZIP code column on the input links to the Aggregator and Join stages.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: A | Question # 3 Answer: A | Question # 4 Answer: D | Question # 5 Answer: B |
1155 Customer Reviews
Quality and ValueITCertKing 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 ITCertKing 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 BuyITCertKing 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.
