C2090-552 IBM InfoSphere Optim for Distributed Systems - V7.3.1 Questions and Answers

Reduced maintenance costs because application and database maintenance and license fees are no longer paid for the old application and its database, but data remains accessible to the user community.

Decommissioned data is needed every day by end-users and Optim caches it in memory so access is faster then the production database.

Reporting from the application against the archived data can be cheaper using tiered storage.

Optim can store decommissioned data in a compressed format so it will take less storage then it did in production.

Applications must continue to use data in a seamless manner.

Invoke the Column Map Editor.

Add additional functionality to the Table Maps that make up a Column Map.

Provide specifications needed to match or exclude columns or when data transformations are needed.

Validate that all data privacy rules established by a specific data governance policy are properly implemented.

Archive, Restore

Restore, Insert, Load, Convert

Extract, Convert, Insert, Load, Delete

Archive, Delete, Restore

There is no active relationship for the STATE_LOOKUP table.

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

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

The relationship between SALES and STATE_LOOKUP is unselected.

ODM/Optim Connect is used to make all extended data sources seem like Oracle views.

ODM/Optim Connect is used to expose Optim Archive files to applications.

Archive file security is ignored if you use ODM/Optim Connect.

Optim Extract files exposed by ODM/Optim Connect can be queried with normal ANSI SQL statements.

ANDEEARS

SANEEGER

ANDEEGER

SANEEAER

Optim Connect Server software

Report writer software

Optim Connect Studio software

Oracle HSODBC

Selection Criteria, Grouping Specifications

Table Maps, Column Maps

Column Lists, Report Specifications

Privacy Functions, Sort Criteria

The Archive Directory is specified in the Object Tab.

The Archive Directory is specified in the Access Definition.

If a default Archive Directory is not specified, the default Data Directory specified in Personal Options is used.

If a default Archive Directory is not specified, the default Data Directory specified in System Options is used.

It must be started as a service and initiated by root.

It must be started manually as a process by any user.

It must be started by a user with the ability to log on as a batch job.

It must be started automatically when the machine is started.

The disk storage requirements are always less than the requirements for the associated Archive Files.

The disk storage requirements are always specified in the Optim Directory.

The disk storage requirements are often the same or more than the associated Archive Files.

The disk storage requirements are the same as the associated Archive Files.

Access Definitions, Archive Files, Extract Files

Archive Requests, Insert Requests, Delete Requests, Compare Requests, Convert Requests, and Edit Requests

Extract Files, Compare Files, Archive Files, Control Files, and Archive Index Files

all Optim files

Compare Request

Column Map

Access Definition

Personal Options

Sun Solaris with Oracle or Informix databases

Windows XP Professional with Oracle or Microsoft Access databases

AIX with Oracle or Microsoft SQL Server databases

Ubuntu Linux with DB2 database

AIX with DB2 or Informix databases

Database Security

Object Security

Functional Security

Network Security

Extract File Security

The Optim Directory can reside on DB2 LUW, Oracle or Microsoft Access.

There may be more than one Optim Directory and they may reside on both Windows and UNIX.

The Optim Directory can reside on DB2 z/OS, Teradata or Microsoft SQL Server.

The definitions can be migrated from one Optim Directory to another with an Export and Import process.

The Optim Directory is always stored on a Windows workstation.