IBM


IBM Professional Certification Program

Accelerate insight. Improve skills. Get certified now.

Test C2090-552: IBM InfoSphere Optim for Distributed Systems Fundamentals


cert assess save

This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to plan, install, configure, troubleshoot, administer and maintain an IBM InfoSphere Optim Data Growth, Optim Decommissioning, Test Data Management, or Test Data Management with Data Privacy option on a Distributed System. 

Section 1 - Installation and Configuration (25%)


  1. Optim Architecture

    1. Operating Systems/Hardware support

    2. Database Support

  2. Establishing Environments

    1. Optim Directories (location, numbers, owners)

    2. Confirming installation pre-reqs

    3. Physical installations

  3. Security

    1. Initializing

    2. Enabling

    3. Configuring

  4. Archive / Extract Maintenance

    1. File locations/sub-systems

    2. File naming / sizing


Section 2 - Optim Core Functionality (35%)


  1. Data Growth

    1. Archive

    2. Delete

    3. Restore

  2. Decommissioning

  3. Test Data Management

    1. Extract / Insert

    2. Edit

    3. Compare

  4. Data Privacy Functions (when to use which ones)

    1. Convert

    2. Privacy Functions

  5. Access Definitions

  6. Relationships


Section 3 - Advanced Topics (34%)


  1. Enterprise Integration

    1. Security

    2. Storage

    3. Automation (i.e. Command Line)

  2. Import/Export OPTIM DDL

  3. Archive Files (i.e., location, collections, moving, registering, creating, managing index files)

    1. Optim Connect

    2. Archive Collections

    3. Archive Indexes

    4. Archive File Maintenance

  4. Complex Data Model Traversals

  5. Extended Data Sources

    1. InfoSphere Federation Server

    2. Optim Connect

  6. Non-Enforced Referential Integrity

  7. Column Maps and Exits


Section 4 - Performance and Troubleshooting (6%)


  1. Log Files, Trace Files and Statistical Reports

  2. Relationships (i.e., delete strategy, OPTIM relationships, Forced Key/Scan Lookups, Scans, Threads)

  3. Relationship Index Analysis



Promotions


Connect with Us