Test 000-551: IBM Optim Implementation for Distributed Systems (2009)

Section 1 - Installation and Configuration (20%)

1. Optim Architecture
   1. Operating Systems / Hardware support
   2. Database Support
2. Establishing Environments
   1. Optim Directories (location, numbers, owners)
   2. Confirming installation pre-regs
   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 - Implementation Methodology (27%)

1. Initiation and Planning
   1. Scope, Objectives, Approach
   2. Project Kick-off
   3. Team & Project Planning
   4. High Level Architecture Validation
2. Requirements Analysis
   1. Objectives Translation & Success Criteria
   2. Use Case Analysis
   3. Business Object Analysis & Selection Criteria
   4. Reporting / Access
   5. Storage / Retention
   6. Security & Access Control
3. Design and Build
   1. Solution Design
      1. Optim Configurations
      2. Viewing / Access / Reporting
      3. Processing & Storage
      4. Security / Access Control Configurations
   2. Unit Testing & Validation
   3. Documentation
4. Test and Validate
   1. Functional & Process Testing / Systems Integration Testing
   2. Performance Testing
5. Project Deployment
   1. Production Deployment Planning
   2. Back-up and Recovery
   3. Deployment Dry Run

Section 3 - Optim Core Functionality (35%)

1. Data Growth
   1. Basics
   2. ODM
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 4 - Advanced Topics (14%)

1. Enterprise Integration
   1. Security
   2. Storage
   3. Automation
2. Import/Export OPTIM DDL
3. InfoSphere Data Architect (IDA)
4. Database Relationship Analyzer (DRA)
5. Archive Files (i.e., location, collections, moving, registering, creating, managing index files
6. Complex Data Model Traversals
7. Extended Data Sources
   1. Federation Server
   2. Attunity
8. Non-Enforced Referential Integrity
9. Column Map Exits

Section 5 - Performance and Troubleshooting (4%)

1. Log Files, Trace Files and Statistical Reports
2. Relationships (i.e., delete strategy, OPTIM relationships, Forced Key/Scam Lookups, Scans, Threads)
3. Relationship Index Analysis