We're so confident of our products that we provide no hassle product exchange.
IBM A2090-303 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | Assessment: IBM InfoSphere DataStage v9.1 Assessment |
| Exam Number: | A2090-303 |
| Exam Price: | Approx. $200 USD (varies by region) |
| Certificate Validity Period: | 3 years |
| Passing Score: | 70% |
| Available Languages: | English |
| Real Exam Qty: | 60 |
| Related Certifications: | IBM Certified Specialist - InfoSphere Information Server |
| Exam Duration: | 90 minutes |
| Exam Format: | Multiple Choice, Multiple Select |
| Recommended Training: | IBM InfoSphere DataStage v9.1 Training |
| Exam Registration: | Pearson VUE IBM Certification Registration |
| Sample Questions: | IBM A2090-303 Sample Questions |
| Exam Way: | Online proctored via Pearson OnVUE or onsite at authorized Pearson VUE test centers |
| Pre Condition: | No mandatory prerequisites; recommended 6+ months hands-on experience with IBM InfoSphere DataStage v9.1 |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM A2090-303 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Performance & Troubleshooting | 16% | - Error handling and debugging - Logging and monitoring - Performance tuning techniques |
| Topic 2: Database Connectivity | 7% | - Database stage selection - Connection and query configuration - Source and target database properties |
| Topic 3: Data Transformation | 14% | - Transformer stage functionality - Data conversion and mapping - SCD and complex transformations |
| Topic 4: Parallel Architecture | 7% | - Partitioning and collecting methods - Parallel execution concepts - Node configuration and performance |
| Topic 5: Metadata Management | 6% | - Schema and data type handling - Runtime Column Propagation (RCP) - Importing and exporting metadata |
| Topic 6: Persistent Storage | 15% | - Data import/export operations - File formats and properties - Sequential File stage usage |
| Topic 7: Configuration | 6% | - Environment variables and settings - Configuration file components and usage - Project setup and configuration |
| Topic 8: Job Design & Deployment | 18% | - Job sequencing and restartability - Balanced Optimization - Compilation and deployment procedures |
| Topic 9: Job Components & Processing | 11% | - Join, Lookup, and Merge stages - Sort and Filter stages - Shared containers and reusability |
IBM Assessment: IBM InfoSphere DataStage v9.1 Assessment Sample Questions:
Question #1
Which statement describes a SCD Type One update in the Slowly Changing Dimension stage?
- A. Adds a new row to the fact table.
- B. Overwrites an attribute in a dimension table.
- C. Adds a new row to a dimension table.
- D. Overwrites an attribute in the fact table.
Answer: B
Question #2
When using the Sequential File stage as a source, what two property options allow you to add extra columns about the file(s) you are reading onto the output link? (Choose two.)
- A. Percent Null Column
- B. Row number Column
- C. Number of Records Column
- D. Surrogate Key Column
- E. File Name Column
Answer: B,E
Question #3
You are asked by management to document all jobs written to make future maintenance easier. Which statement is true about annotations?
- A. The short job description can be identified within the Description Annotation stage.
- B. The Description Annotation stage can be added several times at different locations to identify business logic.
- C. The Description Annotation stage contains both the short and full descriptions for the job.
- D. The background for the Description Annotation stage can be changed for each unique stage.
Answer: A
Question #4
Which option is required to identify a particular job player processes?Which option is required to identify a particular job? player processes?
- A. Log onto the server and issue the command "ps -ef | grep ds".
- B. Set $APT_DUMP_SCORE to true.
- C. Set $APT_PM_SHOW_PIDS to true.
- D. Use the DataStage Director Job administration screen to display active player processes.
Answer: C
Question #5
Indicate two possible job design topologies that Information Services Director (ISD) parallel jobs can conform to. (Choose two.)
- A. A job with one ISD Input stage and no ISD Output stage.
- B. A job with a single ISD Transformation stage.
- C. A job with no ISD Input stage and with one ISD Output stage.
- D. A job with greater then one ISD input stage and one ISD Output stage.
- E. A job with one ISD Input stage and greater then one ISD Output stage.
Answer: A,C
By Cornelia
