We're so confident of our products that we provide no hassle product exchange.
IBM C2090-303 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM InfoSphere DataStage Solution Developer |
| Exam Number: | 000-303 |
| Passing Score: | Approximately 60-70% (varies by exam version) |
| Certificate Validity Period: | 3 years |
| Exam Price: | Approximately USD 200-250 (varies by region and provider) |
| Exam Format: | Multiple choice, Scenario-based questions |
| Related Certifications: | IBM Certified Solution Developer - InfoSphere DataStage (Advanced) |
| Real Exam Qty: | 60-70 (varies by exam version) |
| Available Languages: | English |
| Exam Duration: | 90-120 |
| Recommended Training: | DataStage ETL Courses (IBM Learning) IBM InfoSphere DataStage Training (IBM SkillsBuild) |
| Exam Registration: | IBM Certification Portal Pearson VUE IBM Exams |
| Sample Questions: | IBM C2090-303 Sample Questions |
| Exam Way: | Proctored exam delivered online or at authorized Pearson VUE test centers |
| Pre Condition: | No formal prerequisites, but hands-on experience with IBM InfoSphere DataStage and ETL concepts is strongly recommended. |
| Official Syllabus URL: | https://www.ibm.com/certification |
IBM C2090-303 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Data Integration and Processing | - Data Sources and Targets
|
| Job Control and Administration | - Scheduling and Monitoring
|
| DataStage Fundamentals | - Architecture Overview
|
| Job Design and Development | - Parallel and Server Jobs
|
| Performance Tuning | - Optimization Techniques
|
IBM InfoSphere DataStage v9.1 Sample Questions:
Question 1
When you run a parallel job, any error messages and warnings are written to the job log and can be viewed from the Director client. What message handler level is available?
A. stage level
B. parameter level
C. record level
D. project level
Question 2
What two project environment variables can be considered in your parallel jobs to support your optimization strategy of partitioning and sorting? (Choose two.)
A. $APT_RESTRICT_SORT_USAGE
B. $APT_PARTITION_FLUSH_COUNT
C. $APT_TSORT_STRESS_BLOCKSIZE
D. $APT_NO_PART_INSERTION
E. $APT_OPT_SORT_INSERTION
Question 3
Which statement is correct about the Data Rules stage?
A. As a best practice, you should create and publish new rules from the Data Rules stage.
B. The Data Rules stage works with rule definitions only; not executable rules.
C. If you have Rule Creator role in InfoSphere Information Analyzer, you can create and publish rule definitions and rule set definitions directly from the stage itself.
D. When a job that uses the Data Rules stage runs, the output of the stage is passed to the downstream stages and results are stored in the Analysis Results database (IADB).
Question 4
In your parallel job design you have selected a parallel shared container to be included. Which area of your job design is required to be configured to use the parallel shared container?
A. Configure the job name reference the parallel shared container originates from.
B. Configure the number of input and/or output links to support the parallel shared container.
C. List the jobs that will be allowed to use the container.
D. Configure your job properties General tab "Allow Container" option to be True.
Question 5
You have finished changes to many jobs and shared containers. You must export all of your changes and integrate them into a test project with other objects. What is a way to select the objects you changed for the export?
A. Using the advanced find dialog, specify in the last modified panel, the date range of the jobs, and appropriate user name.
B. Open Quick Find and select "Types to Find".
C. Sort the jobs by timestamp.
D. Use Multiple Job Compile to locate objects that need to be compiled.
Solutions:
| Question 1 Answer: D | Question 2 Answer: C,D | Question 3 Answer: B | Question 4 Answer: B | Question 5 Answer: A |
By Dinah
