Create Account

IBM C2090-303

IBM InfoSphere DataStage v9.1

Free Questions in OTE format

File Date Q&A Votes Size 2016-10-28 135 0/0 468.43 Kb 2016-03-30 134 0/0 465.51 Kb

Notification about new IBM C2090-303 files

Subscribe to IBM C2090-303 dump here, you will be informed about new OTE files.

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.

© 2006 ExamBrainDumps