C2090-424: IBM InfoSphere DataStage v11.3

Full Name: IBM InfoSphere DataStage v11.3

Exam Code: C2090-424

Try Sample Exam »

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
Sample Questions	IBM InfoSphere DataStage Sample Questions
Practice Exam	IBM C2090-424 Certification Practice Exam

IBM C2090-424 Exam Syllabus Topics:

Topic (Weights)	Details
Configuration (6%)	- 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.
Metadata (5%)	- Demonstrate knowledge of framework schema. - Identify the method of importing, sharing, and managing metadata. - Demonstrate knowledge of runtime column propagation (RCP).
Persistent Storage (15%)	- 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.
Parallel Architecture (09%)	- Demonstrate proper use of data partitioning and collecting. - Demonstrate knowledge of parallel execution.
Databases (6%)	- 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.
Data Transformation (12%)	- 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.
Job Components (8%)	- 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.
Job Design (14%)	- 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.
Monitor and Troubleshoot (9%)	- 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.
Job Management and Deployment (8%)	- 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.
Job Control and Runtime Management (8%)	- 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.