IBM C2090-461 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-461
Exam Name/Title: IBM InfoSphere Optim for Distributed Systems v9.1
Certification Provider: IBM
Corresponding Certification: IBM Certified Specialist

Exam Questions: 34
Updated On: May 26, 2026

Question #9

What does "Allow DML Operations byRowID" do?

A. Controls whether Optim extracts the Oracle internal row ID during an extract or archive
process.

B. Controls whether the Row ID is substituted for the Primary key during a Delete Process.

C. Controls whether Optim extracts the Oracle internal row ID when using an Oracle Load File during an extract or archive process.

D. Controls the delete of data from the database byRowID.

Discussion 0

Correct Answer: D Vote an answer

Question #10

Optim Designer should be used for all of which processes?

A. Viewing zOS job output, masking policies and relationship definitions.

B. Testing Optim Archive Access Definitions. Services and ODM Collections

C. Creating and testing TDM Access Definitions. Column Maps and Convert Services.

D. Defining DBAIiases. Optim Data Sources and ODM Collections.

Discussion 0

Correct Answer: C Vote an answer

Question #11

Which option would generate a valid address in the appropriate country for the original value?

A. Lua script with multiple HASH_LOOKUP functions built to choose the table based on the country code.

B. LOOKUP provider using a condition based on the country code.

C. HASH_LOOKUP { cust_id. trim=( &.u), dest=(address1. address2, city, state. postal_code). db2.odp.optim_ca_addresses (seq. values=(address1. address2. city, state, zipcode)))

D. LOOKUP provider using the Optim provided table of all addresses in various countries.

Discussion 0

Correct Answer: A Vote an answer

Question #12

What DBMS are supported for the Optim Directory database when using Optim 9.1 for Designer?

A. Oracle. Informix. DB2 LUW

B. Oracle. Informix. DB2 LUW. SQL SERVER, DB2z/OS

C. Oracle, DB2 LUW, SQL SERVER

D. Oracle. DB2 LUW, SQL SERVER. SYBASE ASE

Discussion 0

Correct Answer: D Vote an answer

Download Free IBM C2090-461 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM C2090-461 exam.