IBM C2090-552 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-552
Exam Name/Title: IBM InfoSphere Optim for Distributed Systems Fundamentals
Certification Provider: IBM
Corresponding Certification: IBM Specialist

Exam Questions: 129
Updated On: May 30, 2026

Question #11

Which two actions ensure the development of a quality, repeatable Test Data Management
(TDM) process? (Choose two.)

A. comparing the output of convert requests with the output of archive requests

B. building andrunning Optim extract and convert requests

C. setting up indices to ensure that restore functions perform adequately

D. building test DBMS environments and subsystems

E. running load/insert requests to populate target test databases

Discussion 0

Correct Answer: B,E Vote an answer

Question #12

Consider the following Archive file name that is defined using macros:
/home/<$USER>/archives/<MON $SEQ6>.AF Which filenames would be generated from this macro? (Note: Assume that the file was created on Monday, February 2, 2009, by the person with the user ID of dev3x and the last sequential number assignedwas 263.)

A. /home/dev3x/archives/MON 264.af

B. /home/dev3x/archives/Feb264.af

C. /dev3x/Feb000263.AF

D. /home/dev3x/archives/MON000264.AF

Discussion 0

Correct Answer: D Vote an answer

Question #13

Click the Exhibit button.

Given this information from the Relationships tab of an Access Definition, and the information from this ShowSteps report in the exhibit, why is the STATE_LOOKUP table listed as UNTRAVERSED?

A. Options (1) needs to be de-activated between SALES and STATE_LOOKUP.

B. Options (2) needs to be activated between SALES and STATE_LOOKUP.

C. There is no active relationship for the STATE_LOOKUP table.

D. The relationship between SALES and STATE_LOOKUP is unselected.

Discussion 0

Correct Answer: B Vote an answer

Question #14

Which statement is true about Optim relationships?

A. At least one side in a relationship must be specified by a column name.

B. Foreign keys are required.

C. Corresponding columns must be identical and compatible.

D. Primary keys are required.

Discussion 0

Correct Answer: A Vote an answer

Question #15

In a Delete Request, Compare Row Contents has been checked on the General tab of the
Delete RequestEditor. What is the impact of this option?

A. Archive will only delete the rows which have been updated since the time of the Archive
Process.

B. The Delete Request will connect to all archive files which have been updated since the time of the Archive Process.

C. Archive will not delete rows which have been updated since the time of the Archive
Process.

D. Archive will delete rows which have been updated since the time of the Archive Process.

Discussion 0

Correct Answer: C Vote an answer

Question #16

Where can the Optim Directory be stored?

A. SQL Server running on UNIX platform

B. Microsoft Access database running on Windows platforms

C. DB2 UDB for z/OS running onmainframe platform

D. DB2 LUW running on Windows, UNIX or Linux platforms

Discussion 0

Correct Answer: D Vote an answer

Question #17

You are having an issue with your Optim Server (running on Linux) and IBM Support has asked you to enable tracing. Where would you go to enable tracing on the Optim Server?

A. By using the idden?capabilities within the Windows GUI as explained by IBM SupportBy using the ?idden?capabilities within the Windows GUI as explained by IBM Support

B. By enabling tracing using the Optim Command Line Utility with the keyword
TRACING=1

C. By checking the nable Tracing?checkbox in the Optim Configuration applet in Control
PanelBy checking the ?nable Tracing?check box in the Optim Configuration applet in
Control Panel

D. By editing the pstserv.cfg or pstlocal.cfg file to enable tracing

Discussion 0

Correct Answer: D Vote an answer

Question #18

Click the Exhibit button.

Given the information from the Relationships tab of an Access Definition, and the associated Show Steps report as shown in the exhibit, what is the reason that the ITEM
552.S table is listed as UNTRAVERSED?

A. The DETAILS table is designated as a Reference Table so all relationships are ignored for this table.

B. Options (1) must be disabled for the relationship between DETAILS and ITEM 552.S.

C. Options (2) must be enabledfor the relationship between DETAILS and ITEM 552.S.

D. No relationship exists between ITEM 552.S and any other table.

Discussion 0

Correct Answer: A Vote an answer

Question #19

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.

Discussion 0

Correct Answer: C Vote an answer

Question #20

When performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ey Lookup?in the AccessWhen performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ?ey
Lookup?in the Access Method of the Table Access Strategy panel for the Delete Request.
Why might Optim be doing a scan even though you have specified to us e a key to access the table?

A. You do not have authority in the database to specify a key to use.

B. Compare Row Contents option was not selectedprior to running the Delete Request.

C. The table has a very large amount of data and the database engine has chosen a different access strategy than what you have specified.

D. The wrong index was chosen for the Optim Primary Key for the table.

Discussion 0

Correct Answer: D Vote an answer

Download Free IBM C2090-552 Demo

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