IBM C2090-303

Free Questions in OTE format

About IBM C2090-303 dump

This test will certify that the successful candidate has important knowledge and skills necessary to professionally design and develop an efficient and scalable DataStage solution to a complex enterprise level business problem; configure a scalable parallel environment including clustered and distributed configurations; collect, report on, and resolve issues identified through key application performance indicators; be proficient in extending the capabilities of the parallel framework using the provided APIs (build-ops and wrappers).

Section 1 - Configuration (6%)

• Describe how to properly configure DataStage v9.1
  
• Identify tasks required to create and configure a project to be used for v9.1 jobs.
  
• Given a configuration file, identify its components and its overall intended purpose.
  

Section 2 - Metadata (6%)

• Demonstrate knowledge of framework schema.
  
• Identify the method of importing, sharing, and managing metadata.
  
• Demonstrate knowledge of runtime column propagation.
  

Section 3 - Persistent Storage (15%)

• Explain the process of importing/exporting data to/from framework.
  
• Describe proper use of a sequential file.
  
• Describe proper usage of Complex Flat File stage.
  
• Describe proper usage of FileSets and DataSets.
  
• Describe use of FTP stage for remote data .
  
• Describe use of restructure stages.
  
• Identify importing/exporting of XML data.
  
• Knowledge of balanced optimization for Hadoop and integration of oozie workflows.
  

Section 4 - Parallel Architecture (7%)

• Demonstrate proper use of data partitioning and collecting.
  
• Demonstrate knowledge of parallel execution.
  

Section 5 - Databases (7%)

• Demonstrate proper selection of database stages and database specific stage properties.
  
• Identify source database options.
  
• Demonstrate knowledge of target database options.
  

Section 6 - Data Transformation (14%)

• 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 RCP.
  
• Demonstrate knowledge of Transformer Stage input and output loop processing.
  

Section 7 - Job Components (11%)

• 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.
  
• Knowledge of Data Rules.
  

Section 8 - Job Design (12%)

• 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.
  

Section 9 - Monitor and Troubleshoot (9%)

• Demonstrate knowledge of parallel job score.
  
• Identify and define environment variables that control DataStage v9.1 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.
  

Section 10 - Job Management and Deployment (7%)

• Demonstrate knowledge of advanced find.
  
• Demonstrate knowledge and the purpose of impact analysis.
  
• Demonstrate knowledge and purpose of job compare.
  
• Articulate the change control process.
  
• Knowledge of Source Code Control Integration.
  

Section 11 - Job Control and Runtime Management (6%)

• Demonstrate knowledge of message handlers.
  
• Identify the use of dsjob command line utility.
  
• Demonstrate ability to use job sequencers.