The IBM C2090-552 Exam is challenging and thorough preparation is essential for success. This exam study guide is designed to help you prepare for the InfoSphere Optim for Distributed Systems Fundamentals certification exam. It contains a detailed list of the topics covered on the Professional exam, as well as a detailed list of preparation resources. These study guides for the IBM InfoSphere Optim for Distributed Systems Fundamentals will help guide you through the study process for your certification.
C2090-552 IBM InfoSphere Optim for Distributed Systems Fundamentals Exam Summary
● Exam Name: IBM InfoSphere Optim for Distributed Systems Fundamentals
● Exam Code: C2090-552
● Exam Price: $200 (USD)
● Duration: 90 mins
● Number of Questions: 65
● Passing Score: 75%
● Books / Training: Optim Solution Library
● Schedule Exam: Pearson VUE
● Sample Questions: IBM InfoSphere Optim for Distributed Systems Fundamentals Sample Questions
● Recommended Practice: IBM C2090-552 Certification Practice Exam
Exam Syllabus: C2090-552 IBM Certified Specialist - InfoSphere Optim for Distributed Systems Fundamentals
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
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
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
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 C2090-552 Certification Sample Questions and Answers
To make you familiar with IBM InfoSphere Optim for Distributed Systems Fundamentals (C2090-552) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for InfoSphere Optim for Distributed Systems Fundamentals C2090-552 Certification to test your understanding of IBM C2090-552 process with real IBM certification exam environment.
C2090-552 IBM InfoSphere Optim for Distributed Systems Fundamentals Sample Questions:-
01. A customer wants to Decommission their mainframe. Which scenario will Optim address?
a) They want to continue to use the CICS z/OS application to access the data.
b) Initially, their data was entered into their z/OS DB2 database. They have now decided to use Oracle on an AIX machine. They want to convert the DB2 packages to Oracle stored procedures.
c) They have data stored in both VSAM and DB2 on the z/OS platform and want to give up both their DB2 z/OS license and their hosted z/OS environment.
d) They want to store a copy of the application with the archives, in case they have to restore the data.
02. Which statement about disk storage requirements for Archive Index Files is correct?
a) The disk storage requirements are always less than the requirements for the associated Archive Files.
b) The diskstorage requirements are always specified in the Optim Directory.
c) The disk storage requirements are often the same or more than the associated Archive Files.
d) The disk storage requirements are the same as the associated Archive Files.
03. When you create a new Column Map, which of the following is NOT a valid source?
a) A table in an Extract File
b) A constant value
c) A tablein an Archive File
d) A table in a database
04. When setting up Optim Connect Studio, which of the following is true?
a) Only one binding can be defined for each machine.
b) Optim Connect Studio does not support renaming a binding.
c) Parallel processing and Query Processor parameters are defined on the Server tab.
d) Registration of the product is done using Optim Configuration.
05. Which of the following are included in an Access Definition?
a) SelectionCriteria, Grouping Specifications
b) Table Maps, Column Maps
c) Column Lists, Report Specifications
d) Privacy Functions, Sort Criteria
06. Which statement is correct with respect to setting expectations around archiveaccess and reporting?
a) Access to archive data performs just like a database.
b) ODM/Optim Connect must be used to access the archives.
c) Archive data access should rarely berequired.
d) Access using ODM/Optim Connect provides nearline access to archived data.
07. You are installing IBM Optim into an Oracle environment. Which statement is correct about user permissions?
a) Theinstallation user requires the DBA role.
b) The installation user is the only user that can run Optim.
c) The installation user's permissions must be deleted once the installation is complete and all DB Aliases are created.
d) The installation user must have the SELECT ANY DICTIONARY role.
08. What identifies the tables, relationship traversals, and selection criteria for the data to be archived?
a) Access Definition
b) Archive File
c) Browse Utility
d) Storage Profile
09. Why would you use the Optim File Maintenance Facility?
a) To remove rows from registered Archive Files and compress Archive and Extract Files.
b) To update Archive File Indexes and Register Archive Files that have been moved from their original location.
c) To remove rows from registered Archive and Extract Files and compress Archive and Extract Files.
d) To remove rows from registered Archive Files, Extract Files, and database load files, and compress Archive, Extract, and database load Files.
10. How do you start the Optim Server when it is installed on Windows?
a) It must be started as a service and initiated by root.
b) It must be started manually as a process by any user.
c) It must be started by a user with the ability to log on as a batch job.
d) It must be started automatically when the machine is started.
Answers:-
Answer 1:- c
Answer 2:- c
Answer 3:- b
Answer 4:- b
Answer 5:- a
Answer 6:- d
Answer 7:- d
Answer 8:- a
Answer 9:- a
Answer 10:- c
Comments