C2090-552 Exam Dumps - IBM InfoSphere Optim for Distributed Systems - V7.3.1

Primary keys are required.

Foreign keys are required.

Corresponding columns must be identical and compatible.

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

DB2 UDB for z/OS running on mainframe platform

SQL Server running on UNIX platform

DB2 LUW running on Windows, UNIX or Linux platforms

Microsoft Access database running on Windows platforms

Microsoft Access database running on Windows platforms

SQL Server running on UNIX platform

DB2 UDB for z/OS running on mainframe platform

Oracle running on Windows, UNIX or Linux platforms

Oracle Heterogeneous Services must be configured to access Microsoft SQL Server.

The archived data must be defined to Optim Connect.

SQL Server and Optim must be installed on the same system.

The Optim Server process must be running on the same machine as the Microsoft SQL Server.

"Lock" will request a table lock from the DBMS so that no other changes can be made.

"Lock" will lock the column in place so that it is always visible during horizontal scrolling.

"Lock" will lock the editing session so that no additional changes can be made to that column.

"Lock" will lock the named Edit Request and finalize it in the Optim Directory.

A generic relationship is used by Optim when two tables don't have a declared relationship but the columns of the primary key match in name and data type.

A generic relationship is established when Optim Security is enabled and allows the security administrator to remove duplicate relationships between tables and automatically point Access Definitions to the unique relationship.

A generic relationship is used for one or more pairs of tables that have the same base name, column names, and attributes, but different creator ids.

A generic relationship is a default relationship that Optim creates between any primary keys declared either in the database or Optim where the column names and datatypes match and have an index.

Database, Optim, Generic

Database, Optim, Compound

Optim, Generic, Symbiotic

Generic, Optim, Compound

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.

Extract, Archive, and Archive Index Files

Extract and Archive Files

Archive Files only

Archive Index Files only

Works directly against the database to transform data.

Transforms data in an Archive File to a non-comma separated file.

Transforms data in an Extract File to a non-comma separated file.

Works directly with the database to merge data.

Archive, Restore

Restore, Insert, Load, Convert

Extract, Convert, Insert, Load, Delete

Archive, Delete, Restore

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.

The Character or Numeric data must have a length of 256 bytes and be padded with blanks or binary zeros as needed.

The source column can only contain date or timestamp data.

The source column can contain date or timestamp data; character or numeric data may be used if a date format is applied to the AGE function.

The date format used in the Column Map must be entered in the format used by the database.

Compare Request

Column Map

Access Definition

Personal Options

You can reference a maximum of 64 columns for any table in the relationship.

You can use a Large Object (LOB) or SQL variant column.

You can match a literal or constant to a literal or constant.

You can create a Relationship using an SQL Variant column.

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

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

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

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