IBM C2090-421 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Data Integration | - Connectivity to data sources and targets - Data transformation techniques |
| Topic 2: Performance Optimization | - Job tuning and bottleneck analysis - Parallel processing optimization |
| Topic 3: InfoSphere DataStage Architecture | - Server and Parallel Job Architecture - Components (Designer, Director, Administrator) |
| Topic 4: Administration and Troubleshooting | - Error handling and recovery - Job monitoring and logging |
| Topic 5: Job Development | - Job sequences and control logic - Parallel job design principles - Stages and transformers usage |
IBM InfoSphere DataStage v8.5 Sample Questions:
Question #1
What are two ways to specify a stylesheet in an XML input stage? (Choose two.)
A. On the output link advanced properties tab, load the content or path of a stylesheet that is stored on the engine tier host.
B. On the output link columns properties tab, identify an input column that contains the stylesheet URL.
C. On the output link columns properties tab, type the stylesheet in the XLST box.
D. On the output link advanced properties tab, type the stylesheet in the Stylesheet box.
Question #2
Which two statements about annotations are correct? (Select two)
A. An annotation can be drawn around one of more stages.
B. The Short job description field will appears in job log when $APT_PM_SHOW_PIDS is set.
C. The Full job description field is only visible within the Designer Client.
D. The Short job description field displays on log summary lines within Director client.
Question #3
Which two statements are true about the usage of scratch disk? (Choose two.)
A. If "buffer" scratch disk pool is defined, the framework uses this disk pool and the default disk pool.
B. The parallel framework uses the disk space specified in the scratch disk setting to buffer virtual data set records.
C. You can define multiple scratch disk spaces to distribute disk I/O.
D. The Sort stage always uses the scratch disk.
Question #4
Your job design calls for using a target ODBC Connector stage. The target database is found on a remote server. The target table you are writing into contains a single column primary key. What are the three "Write mode" properties that allow the possibility of multiple SQL actions? (Choose three.)
A. Join then update
B. Insert then update
C. Update then insert
D. Truncate then add
E. Delete then insert
Question #5
A customer requires reading a fixed-length sequential file in parallel where input rows can be identified. What two tasks must be done to meet these requirements? (Choose two.)
A. Set partitioning method to Same.
B. Set $APT_READ_MULTI_NODES to TRUE.
C. Ensure data has unique identifiers for data rows.
D. Specify Multiple readers per node.
Solutions:
| Question #1 Correct Answer: A,D | Question #2 Correct Answer: A,B | Question #3 Correct Answer: B,C | Question #4 Correct Answer: B,C,E | Question #5 Correct Answer: C,D |
992 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.
