Validity and reliability anchor the IBM InfoSphere Optim for Distributed Systems Fundamentals bank at ExamTorrent — C2090-552 content refined against the live exam outline, answers verified by IT specialists, and daily checks that keep everything current.
IBM C2090-552 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Performance and Troubleshooting | 6% | - Log and Trace Files - Index Analysis - Relationship Analysis - Statistical Reports |
| Optim Core Functionality | 35% | - Relationships - Access Definitions - Test Data Management
- Data Growth and Archiving - Data Privacy Functions |
| Advanced Topics | 34% | - Non-Enforced Referential Integrity - Optim Connect - Archive File Management
- Enterprise Integration - Automation and Command Line - Column Maps and Exits - Extended Data Sources - Security and Storage - Complex Data Model Traversal |
| Installation and Configuration | 25% | - Operating Systems and Hardware Support - Optim Architecture - Database Support - Archive and Extract Maintenance
|
C2090-552 Exam Facts and Self-Paced Study at ExamTorrent
- Installation and Configuration (25%)
- Performance and Troubleshooting (6%)
- Optim Core Functionality (35%)
IBM InfoSphere Optim for Distributed Systems Fundamentals Sample Questions:
When you specify the default minimum retention period for protecting Archive Files on a managed storage system from deletion, when will the files be deleted?
- A. When the expiration date on the Archive File has been reached, Optim issues a request to the managed storage system to delete the file.
- B. After the minimum retention period expires, the file can be deleted from Optim.
- C. After the minimum retention period expires,the file can be marked deleted by the managed storage system.
- D. After the retention period is reached, the file will be automatically deleted by Optim.
Correct Answer: C 🗳️
You are installing IBM Optim into an Oracle environment. Which statement is correct about user permissions?
- A. The installation user is the only user that can run Optim.
- B. The installation user's permissions must be deleted once the installation is complete and all DB Aliases are created.
- C. The installation user must have the SELECT ANY DICTIONARY role.
- D. Theinstallation user requires the DBA role.
Correct Answer: C 🗳️
Which two actions ensure the development of a quality, repeatable Test Data Management
(TDM) process? (Choose two.)
- A. running load/insert requests to populate target test databases
- B. comparing the output of convert requests with the output of archive requests
- C. setting up indices to ensure that restore functions perform adequately
- D. building test DBMS environments and subsystems
- E. building andrunning Optim extract and convert requests
Correct Answer: A,E 🗳️
For what does Optim allow you to automatically generate file names?
- A. Archive Requests, Insert Requests, Delete Requests, Compare Requests,Convert
Requests, and Edit Requests - B. Access Definitions, Archive Files, Extract Files
- C. all Optim files
- D. Extract Files, Compare Files, Archive Files, Control Files, and Archive Index Files
Correct Answer: D 🗳️
Which statement is true about Optim relationships?
- A. You can use a Large Object (LOB) or SQL variant column.
- B. You can reference a maximum of 64 columns for any table in the relationship.
- C. You can match a literal or constant to a literal or constant.
- D. You can create a Relationship using an SQL Variant column.
Correct Answer: B 🗳️






1257 Customer Reviews

