Use this quick start guide to collect all the information about IBM InfoSphere DataStage (C2090-424) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the C2090-424 IBM InfoSphere DataStage v11.3 exam. The Sample Questions will help you identify the type and difficulty level of the questions and the Practice Exams will make you familiar with the format and environment of an exam. You should refer this guide carefully before attempting your actual IBM InfoSphere DataStage certification exam.
The IBM InfoSphere DataStage certification is mainly targeted to those candidates who want to build their career in IBM Data and AI - Platform Analytics domain. The IBM Certified Solution Developer - InfoSphere DataStage v11.3 exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of IBM InfoSphere DataStage.
IBM InfoSphere DataStage Exam Summary:
| Exam Name | IBM Certified Solution Developer - InfoSphere DataStage v11.3 |
| Exam Code | C2090-424 |
| Exam Price | $200 (USD) |
| Duration | 90 mins |
| Number of Questions | 64 |
| Passing Score | 64% |
| Books / Training | IBM InfoSphere DataStage v11.5 - Advanced Data Processing |
| Schedule Exam | Pearson VUE |
| Sample Questions | IBM InfoSphere DataStage Sample Questions |
| Practice Exam | IBM C2090-424 Certification Practice Exam |
IBM C2090-424 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Configuration |
- Describe how to properly configure DataStage. - Identify tasks required to create and configure a project to be used for jobs. - Given a configuration file, identify its components and its overall intended purpose. - Demonstrate proper use of node pools. |
6% |
| Metadata |
- Demonstrate knowledge of framework schema. - Identify the method of importing, sharing, and managing metadata. - Demonstrate knowledge of runtime column propagation (RCP). |
5% |
| Persistent Storage |
- Explain the process of importing/exporting data to/from framework. - Demonstrate proper use of a Sequential File stage. - Demonstrate proper usage of Complex Flat File stage. -Demonstrate proper usage of FileSets and DataSets. - Demonstrate use of FTP stage for remote data. - Demonstrate use of restructure stages. - Identify importing/exporting of XML data. - Knowledge of balanced optimization for Hadoop and integration of oozie workflows. - Demonstrate proper use of File Connector stage. - Demonstrate use of DataStage to handle various types of data including unstructured, hierarchical, Cloud, and Hadoop. |
15% |
| Parallel Architecture |
- Demonstrate proper use of data partitioning and collecting. - Demonstrate knowledge of parallel execution. |
9% |
| Databases |
- Demonstrate proper selection of database stages and database specific stage properties. - Identify source database options. - Demonstrate knowledge of target database options. - Demonstrate knowledge of the different SQL input/creation options and when to use each. |
6% |
| Data Transformation |
- Demonstrate knowledge of default type conversions, output mappings, and associated warnings. - Demonstrate proper selections of Transformer stage vs. other stages. - Describe Transformer stage capabilities. - Demonstrate the use of Transformer stage variables. - Identify process to add functionality not provided by existing DataStage stages. - Demonstrate proper use of SCD stage. - Demonstrate job design knowledge of using runtime column propagation (RCP). - Demonstrate knowledge of Transformer stage input and output loop processing. |
12% |
| Job Components |
- Demonstrate knowledge of Join, Lookup and Merge stages. - Demonstrate knowledge of Sort stage. - Demonstrate understanding of Aggregator stage. - Describe proper usage of change capture/change apply. - Demonstrate knowledge of real-time components. |
8% |
| Job Design |
- Demonstrate knowledge of shared containers. - Describe how to minimize Sorts and repartitions. - Demonstrate knowledge of creating restart points and methodologies. - Explain the process necessary to run multiple copies of the source. - Knowledge of creating DataStage jobs that can be used as a service. - Knowledge of balanced optimization. - Describe the purpose and uses of parameter sets and how they compare with other approaches for parameterizing jobs. - Demonstrate the ability to create and use Data Rules using the Data Rules stage to measure the quality of data. - Demonstrate various methods of using DataStage to handle encrypted data. |
14% |
| Monitor and Troubleshoot |
- Demonstrate knowledge of parallel job score. - Identify and define environment variables that control DataStage with regard to added functionality and reporting. - Given a process list, identify conductor, section leader, and player process. - Identify areas that may improve performance. - Demonstrate knowledge of runtime metadata analysis and performance monitoring. - Ability to monitor DataStage jobs using the Job Log and Operations Console. |
9% |
| Job Management and Deployment |
- Demonstrate knowledge of DataStage Designer Repository utilities such as advanced find, impact analysis, and job compare. - Articulate the change control process. - Knowledge of Source Code Control Integration. - Demonstrate the ability to define packages, import, and export using the ISTool utility. - Demonstrate the ability to perform admin tasks with tools such as Directory Admin. |
8% |
| Job Control and Runtime Management |
- Demonstrate knowledge of message handlers. - Demonstrate the ability to use the dsjob command line utility. - Demonstrate ability to use job sequencers. - Create and manage encrypted passwords and credentials files. |
8% |
To ensure success in IBM InfoSphere DataStage certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for IBM InfoSphere DataStage v11.3 (C2090-424) exam.