We're so confident of our products that we provide no hassle product exchange.
IBM C2090-421 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | IBM InfoSphere DataStage v8.5 Implementation and Development |
| Exam Number: | C2090-421 |
| Exam Format: | Multiple choice, Scenario-based questions |
| Available Languages: | English |
| Related Certifications: | IBM Certified Specialist - InfoSphere DataStage |
| Recommended Training: | IBM Training - DataStage Courses |
| Exam Registration: | Pearson VUE IBM Exams IBM Certification Portal |
| Sample Questions: | IBM C2090-421 Sample Questions |
| Exam Way: | Delivered via Pearson VUE test centers or online proctored exam (availability may vary by region). |
| Pre Condition: | Recommended hands-on experience with IBM InfoSphere DataStage v8.5 and ETL concepts. |
| Official Syllabus URL: | https://www.ibm.com/certify |
IBM C2090-421 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| InfoSphere DataStage Architecture | - Components (Designer, Director, Administrator) - Server and Parallel Job Architecture |
| Administration and Troubleshooting | - Error handling and recovery - Job monitoring and logging |
| Performance Optimization | - Parallel processing optimization - Job tuning and bottleneck analysis |
| Data Integration | - Data transformation techniques - Connectivity to data sources and targets |
| Job Development | - Parallel job design principles - Stages and transformers usage - Job sequences and control logic |
IBM InfoSphere DataStage v8.5 Sample Questions:
1. 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) Compare stage
B) Switch stage
C) Transformer stage
D) Filter stage
2. Which two statements about annotations are correct? (Select two)
A) An annotation can be drawn around one of more stages.
B) The Full job description field is only visible within the Designer Client.
C) The Short job description field displays on log summary lines within Director client.
D) The Short job description field will appears in job log when $APT_PM_SHOW_PIDS is set.
3. Which three environment variables are used for reporting on DataStage jobs? (Select three)
A) $OSH_PRINT_SCHEMAS
B) $APT_DUMP_SCORE
C) $APT_PM_STARTUP_CONCURRENCY
D) $APT_DISABLE_ROOT_FORKJOIN
E) $APT_PM_PLAYER_MEMORY
4. A job design consists of an input SequentialFile stage, followed by a Peek stage, a Transformer stage, a Sort stage and finally an output Dataset stage. The job executes on an SMP system with a configuration file defined with 4 nodes.
The environment variable $APT_DISABLE_COMBINATION is set to "True". How many processes will this job create?
A) 12
B) 17
C) 21
D) 19
5. Which statement is true about buffering?
A) The buffer operator uses both memory and disk storage.
B) The "buffer" scratch disk pool needs to be defined to allow the framework to perform data buffering.
C) The framework uses /tmp by default for buffering on Unix systems.
D) In a clustered environment, using a disk space on an NFS mount for buffering improves performance.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: A,D | Question # 3 Answer: A,B,E | Question # 4 Answer: B | Question # 5 Answer: A |
By Neil
