The IBM C2090-424 Exam is challenging and thorough preparation is essential for success. This exam study guide is designed to help you prepare for the InfoSphere DataStage certification exam. It contains a detailed list of the topics covered on the Professional exam, as well as a detailed list of preparation resources. These study guides for the IBM InfoSphere DataStage v11.3 will help guide you through the study process for your certification.
C2090-424 IBM InfoSphere DataStage v11.3 Exam Summary
● Exam Name: IBM 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
● Recommended Practice: IBM C2090-424 Certification Practice Exam
Exam Syllabus: C2090-424 IBM Certified Solution Developer - InfoSphere DataStage v11.3
1. 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.
2. Metadata (5%)
- Demonstrate knowledge of framework schema.
- Identify the method of importing, sharing, and managing metadata.
- Demonstrate knowledge of runtime column propagation (RCP).
3. 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.
4. Parallel Architecture (9%)
- Demonstrate proper use of data partitioning and collecting.
- Demonstrate knowledge of parallel execution.
5. 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.
6. 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.
7. 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.
8. 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.
9. 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.
10. 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.
11. 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.
IBM C2090-424 Certification Sample Questions and Answers
To make you familiar with IBM InfoSphere DataStage v11.3 (C2090-424) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for InfoSphere DataStage C2090-424 Certification to test your understanding of IBM C2090-424 process with real IBM certification exam environment.
C2090-424 IBM InfoSphere DataStage v11.3 Sample Questions:-
01. To run multiple copies of the same job within Director, which of the following must be supplied?
a) Job name
b) Invocation ID
c) Parameter values
d) Username and password
02. How do you create a shared table definition from the DataStage client?
a) Use the save button on the columns tab of the stage editor
b) Use the shared table creation wizard from the repository window
c) Do nothing. They are created automatically when table definitions are imported
d) It cannot be done within the DataStage client. Use the InfoSphere Metadata Asset Manager (IMAM) utility instead.
03. In order to use Cognos TM1 Connector, which statement is TRUE?
a) Installing the Cognos TM1 API component alone is sufficient.
b) Import the IBM Cognos TM1 certificate and create a property file that stores truststore password
c) Install the Cognos TM1 API component and create a property file that stores truststore password
d) Install the Cognos TM1 API component and import the IBM Cognos TM1 certificate and create a property file that stores truststore password
04. Which statement about restartable sequence jobs is TRUE?
a) If a restartable sequence aborts, it can be restarted from Director.
b) Choosing "Reset job" from Director will start the job where it left off.
c) Checkpoints are always added to every eligible Job Activity stage in the sequence.
d) There is no way to force a Job Activity stage to return if the sequence got beyond it.
05. For very large records, you may need to set the following environment variable with an appropriate value in order to allow the job to run successfully:
a) $APT_MONITOR_SIZE
b) $APT_RECORD_COUNTS
c) $APT_DISABLE_COMBINATION
d) $APT_DEFAULT_TRANSPORT_BLOCK_SIZE
06. You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a Remove Duplicates stage. How can this be accomplished?
a) Hash partition onTotalAmount. Sort on CustID, ProductType and TotalAmount
b) Hash partition on ProductType. Sort on CustID, ProductType and TotalAmount
c) Hash partition on CustID and ProductType. Sort on CustID, ProductType and TotalAmount
d) Hash partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount
07. What COBOL data type is defined by Decimal data within the Complex Flat File stage?
a) COMP
b) COMP-1
c) COMP-2
d) COMP-3
08. Record Count property is set to zero in Connector stage. How many rows are written out?
a) All Rows
b) One Row
c) Zero Rows
d) 2000 Rows
09. A Parameter Set is a named object that can contain which of the following?
a) Multiple parameters and only one value file
b) Only one parameter and only one value file
c) Multiple parameters and multiple value files
d) Only one parameter and multiple value files
10. Which is NOT a valid native operator for OSH?
a) Sort
b) Copy
c) Import
d) Generator
Answers:-
Answer 1:- c
Answer 2:- b
Answer 3:- d
Answer 4:- a
Answer 5:- d
Answer 6:- c
Answer 7:- c
Answer 8:- a
Answer 9:- d
Answer 10:- a