IBM InfoSphere Optim for Distributed Systems Fundamentals 認定 C2090-552 試験問題:

1. During a proof of concept, you successfully install and configure Optim to archive data from an Oracle test application database running on a Solaris server. ?A test archive (without deleting data) is initiated from theOptim Server running on a Windows 2003 server and runs successfully the first day. ?The Optim directory is on a non-application database on the Windows 2003 server. ?During the evening, the client site runs a security routine that automatically deletes any unknown or foreign objects (e.g., packages, plans, procedures) from the application databases running on the Solaris server. ?The next day, the same test archive will no longer run from the Optim Server. Which step must you perform to enable the archiveto run?

A) Configure security for the Optim Directory using the Optim Configuration wizard.
B) Drop and rebuild the Optim Directory using the Optim Directory wizard.
C) Re-install the Optim Client and Server on the database on the Solaris server.
D) Update the DB Alias to the Oracle test application database.

2. After an Archive File and associated Archive Index has been created, you discover that you need to add an additional column tothe Archive File Index. Which process would Optim support to accomplish this task?

A) Use the Optim Utility Menu to Access the Archive Index Maintenance Function. Select the appropriate index from the menu and delete it.
Create a new Archive Index with the appropriate columns and save this index.
B) Once created, Archive Indexes cannot be deleted or modified. You must restore the archived data to a database and then run the Archive Request again (creating a new
Archive File) while specifying the correct Archive Index as part of the Archive Request.
C) Since the Archive File cannot be modified, you must create an additional Archive Index with the correct columns and instruct your users to use this index when performing queries against the Archive File.
D) Use the Optim Utility Menu to Access the Archive Index Maintenance Function. Select the appropriate table and modify the Archive Index with the additional columns needed.
Execute this modification and then save it.

3. 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) Archive will not delete rows which have been updated since the time of the Archive
Process.
C) The Delete Request will connect to all archive files 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.

4. A ew?in the Status column of the Relationship tab of the Access Definition panel indicates a relationship is being displayed for the first time. WhichA ?ew?in the Status column of the
Relationship tab of the Access Definition panel indicates a relationship is being displayed for the first time. Which two events will cause the relationship to be displayed as ew??(Choose two.) two events will cause the relationship to be displayed as
?ew??(Choose two.)

A) A table is added to the list
B) A new Optim Primary Key has been defined for the relationship
C) The indexes used by the database relationship have been modified
D) A column has been added to a table in the relationship chain
E) A new relationship between tables on the list is defined

5. A customer wants filenames that indicate archives are of General Ledger (GL) Journal
Entries (JE), created each accounting period (month), as shown below.
/home/<$USER>/archives/<GLJE $DD $MON $YY _s $SEQ3>.AF Which filename would be generatedfrom this macro? (Note: Assume that the file was created on Monday, August
2 9, 2011, by the person with the user ID of PSFT_GL, and the last sequential number assigned was 263.)

A) /home/PSFT_GL/archives/GLJE29AUG11_s264.AF
B) /home/PSFT_GL/archives/Aug_s263.AF
C) /home/USER/archives/GLJE29AUG2011_s264.AF
D) /home/PSFT_GL/archives/GLJE_MON_s264.AF

質問と回答：