IBM 000-421 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM Certified Solution Developer - InfoSphere DataStage v8.5 |
| Exam Number: | C2090-421 |
| Exam Duration: | 90 minutes |
| Certificate Validity Period: | No expiration (subject to IBM certification policy updates) |
| Real Exam Qty: | 64 |
| Available Languages: | English |
| Related Certifications: | IBM InfoSphere Information Server certifications IBM Certified DataStage certifications |
| Exam Format: | Multiple response, Multiple choice |
| Passing Score: | 63% |
| Exam Price: | USD 200 (varies by region) |
| Sample Questions: | IBM 000-421 Sample Questions |
| Exam Way: | Online or onsite proctored exam via Pearson VUE |
| Pre Condition: | Recommended hands-on experience with IBM InfoSphere DataStage v8.5 and data integration concepts |
| Official Syllabus URL: | https://www.ibm.com/certify |
IBM 000-421 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Performance Tuning and Optimization | - Parallel processing optimization
|
| Topic 2: Administration and Troubleshooting | - Monitoring and debugging jobs
|
| Topic 3: Job Design and Development | - Server jobs and parallel jobs design
|
| Topic 4: DataStage Architecture and Components | - InfoSphere DataStage architecture overview
|
| Topic 5: Data Integration and Connectivity | - Data sources and connectors
|
IBM InfoSphere DataStage v8.5 Sample Questions:
You are required to use a Make Vector stage in your job. What three requirements must be met in order to use this stage? (Choose three.)
- A. Input columns that do not have a name of form <column_name>0 to <column_name>n, where <column_name> is the column name and 0 and n are the first and last of its consecutive numbers will not be included in the vector and will be dropped.
- B. All columns are combined into a vector of the same length as the number of columns.
- C. Columns must be in consecutive order.
- D. Input columns must form a numeric sequence.
- E. Input columns must all be of the same data type.
Correct Answer: B,D,E 🗳️
You have a job that reads in Sequential File followed by a Transformer stage. When you run this job, which partitioning method will be used by default?
- A. Same
- B. Hash
- C. Round Robin
- D. Random
Correct Answer: C 🗳️
Which two property areas must be configured when using the ODBC connector stage as a target in your job design? (Choose two.)
- A. Specify properties for the input link.
- B. Define columns for the output link.
- C. Define the connection properties to an ODBC data source.
- D. Specify the remote server property.
Correct Answer: A,C 🗳️
A job design consists of an input sequential file, a Modify stage, followed by a Filter stage and an output SequentialFile stage. The job is run on an SMP machine with a configuration file defined with three nodes. No environment variables were set for the job. How many osh processes will this job create?
- A. 8
- B. 16
- C. 9
- D. 11
Correct Answer: C 🗳️
You have been asked to assess the impact of replacing the DB2 Enterprise Stage with the DB2 Connector. You must identify all of the jobs and shared containers that use the DB2 Enterprise Stage.
What two Advanced Find criteria would you set to identify the jobs and containers? (Choose two.)
- A. Include Read only objects
- B. Type
- C. Where used
- D. Dependent upon
Correct Answer: B,C 🗳️
Viewing page 1 out of 39 pages.
Viewing questions 1-5 out of 194 questions.

We're so confident of our products that we provide no hassle product exchange.


By Elliot


