C2090-461 IBM InfoSphere Optim for Distributed Systems v9.1

Test information:
Number of questions: 34
Time allowed in minutes: 60
Required passing score: 61%
Languages: English

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.

Section 1 – Installation and Configuration (29%)
Optim Architecture
Operating Systems / Hardware Support
Database Support
New or additional components (Optim Manager, Optim Designer, self-service and Optim Search, UDFs)
Masking on Demand
Establishing Environments
Optim Directories (location, numbers, owners)
Confirming installation pre-reqs
Physical installations (locations, what to separate, manager, where things exist)
Archive / Extract Maintenance
File location / sub-systems (BigData enhancements)
File naming / sizing

Section 2 – Optim Core Functionality (35%)
Archiving
File and Directory Maintenance
Search
Test Data Management
Using the Designer interface
Creating access definitions, table maps, column maps, services
Creating Optim relationships, aliases, data sources (discovery)
Using Optim Manager
Data Privacy Providers (when to use which ones)

Section 3 – Advanced Topics (29%)
LUA
Optim Search
Masking on Demand
Service on Demand
New Database Features/functionality (Netezza, loaders, teradata)

Section 4 – Performance and Troubleshooting (6%)
Log and Trace Files

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.

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

QUESTION 1
Considering best practices and Optim Access Definitions, which statement is FALSE?

A. Optim Classic interface would be used to define the Optionl and Option2 for my archive Access
Definition.
B. All tables included in an Access Definition that was created in Optim Designer must be in the
same DBAIias.
C. One can copy an Access Definition from one folder to another in Optim Designer and the
Wizard will require you to rename it.
D. A reference table can easily be changed to a related table in Optim Designer, however, one
should then verify the entire process by viewing Show Steps.

Answer: D

Explanation:

QUESTION 2
In order to consistently mask a credit card number, which option should be used?

A. TRANS CCN
B. TRANS CCN (‘=n CREDITCARD’)
C. SUBSTR(CREDITCARD. 1. 12) || SEQ(1111.1)
D. There is no reason to mask the credit card number as long as you mask the name.

Answer: A

Explanation:

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