Test information:
Number of questions: 65
Time allowed in minutes: 90
Required passing score: 75%
Languages: English, Japanese

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%)
Optim Architecture
Operating Systems/Hardware support
Database Support
Establishing Environments
Optim Directories (location, numbers, owners)
Confirming installation pre-reqs
Physical installations
Security
Initializing
Enabling
Configuring
Archive / Extract Maintenance
File locations/sub-systems
File naming / sizing

Section 2 – Optim Core Functionality (35%)
Data Growth
Archive
Delete
Restore
Decommissioning
Test Data Management
Extract / Insert
Edit
Compare
Data Privacy Functions (when to use which ones)
Convert
Privacy Functions
Access Definitions
Relationships

Section 3 – Advanced Topics (34%)
Enterprise Integration
Security
Storage
Automation (i.e. Command Line)
Import/Export OPTIM DDL
Archive Files (i.e., location, collections, moving, registering, creating, managing index files)
Optim Connect
Archive Collections
Archive Indexes
Archive File Maintenance
Complex Data Model Traversals
Extended Data Sources
InfoSphere Federation Server
Optim Connect
Non-Enforced Referential Integrity
Column Maps and Exits

Section 4 – Performance and Troubleshooting (6%)
Log Files, Trace Files and Statistical Reports
Relationships (i.e., delete strategy, OPTIM relationships, Forced Key/Scan Lookups, Scans, Threads)

Relationship Index Analysis

IBM Certified Specialist – InfoSphere Optim for Distributed Systems v9.1

Job Role Description / Target Audience
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 Solutions v9.1.

This includes:
* product installation and configuration
* Optim Core Functionality
* LUA
* Optim Search
* Masking on Demand
* Service on Demand
* New Database features and functionality
* performance and tuning

The person performing these functions is generally self-sufficient and is able to perform most of the tasks involved in the role with limited assistance from peers, product documentation and vendor support services.

Recommended Prerequisite Skills

Hands-on experience with installing, configuring and using InfoSphere Optim on Distributed Systems

IBM Certified Specialist – InfoSphere Optim for Distributed Systems Fundamentals

Job Role Description / Target Audience
This intermediate level certification is intended for application developers, database administrators, and technical personnel who perform the installation, configuration and day-to-day tasks associated with ensuring the smooth and efficient operation of InfoSphere Optim environment.

This includes:
* product installation and configuration
* configuration of security
* archive and extract maintenance
* archiving and Optim Connect
* decommissioning
* creation and maintenance of test data
* privatizing data
* accessing extended data sources using Optim Connect and InfoSphere Federation Server
* implementing a test data management environment
* performance and tuning

The person performing these functions is generally self-sufficient and is able to perform most of the tasks involved in the role with limited assistance from peers, product documentation and vendor support services.

Recommended Prerequisite Skills
Familiarity with Optim Manuals
Hands-on experience with installing, configuring, and using Optim on Distributed Systems

---

QUESTION 1
You can use the silent installer in a UNIX environment to install the Optim Server. The silent
installer is NOT available for which two of the following platforms? (Choose two.)

A. HP-UX 11i v2
B. Red Hat Linux 3
C. IBM AIX 5
D. Solaris 8
E. SUSE 10

Answer: B,D

Explanation:

---

QUESTION 2
When installing Optim, what is the minimum disk space needed for the database?

A. 50gb
B. 50mb
C. As required
D. 500mb

Answer: C

Explanation:

---

QUESTION 3
You are planning an installation of IBM Optim. Which two configurations are supported for the
Optim Server and Optim Directory? (Choose two.)

A. DB2 database running on Ubuntu Linux
B. DB2 or Oracle databases running on AIX
C. Oracle or Microsoft SQL Server databases running on AIX
D. DB2 or Informix databases running on Sun Solaris
E. DB2 or Microsoft Access databases running on Windows XP Professional

Answer: B,D

Explanation:

---

QUESTION 4
Which two statements are true about Optim security roles? (Choose two.)

A. Functional Privilege classes such as Create New Actions and Create New Definitions can be
controlled using Roles.
B. Privileges such as Archive Request and Compare Request can be controlled using Roles
C. By default, the Access Control Domain allows access to all Optim Actions and privileges. Only
denial of privileges can be assigned using roles.
D. Default Roles may not be modified to allow or deny Functional Privilege Classes and New
Action Privileges.
E. Edit the FAD (File Access Definition) to control which roles has access to all of the files.

Answer: A,B

Explanation:

Click here to view complete Q&A of C2090-552 exam
Certkingdom Review

Best IBM C2090-552 Certification, IBM C2090-552 Training at certkingdom.com