Note! Following C2090-552 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

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

Go to page:

Question # 9

Which statement describes a generic relationship?

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.

Full Access

Question # 10

Which of the following relationship types does Optim support?

Database, Optim, Generic

Database, Optim, Compound

Optim, Generic, Symbiotic

Generic, Optim, Compound

Full Access

Question # 11

Regarding the ODM/Optim Connect, which statement is true?

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.

Full Access

Question # 12

Although Optim creates files on fixed media, you can also direct certain file type(s) to secondary media, e.g., tape, content addressed storage, or a hierarchical storage management (HSM) system. Which types of file(s) may be directed to secondary media?

Extract, Archive, and Archive Index Files

Extract and Archive Files

Archive Files only

Archive Index Files only

Full Access

Question # 13

What does the Convert process do?

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.

Full Access

Question # 14

In which Optim processes can a Column Map be used?

Archive, Restore

Restore, Insert, Load, Convert

Extract, Convert, Insert, Load, Delete

Archive, Delete, Restore

Full Access

Question # 15

During the Convert process, for what are Column Maps used?

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.

Full Access

Question # 16

When using the Age function within a Column Map to age date values in a source column, there are certain rules that must be followed regarding the data types that are supported. Which statement is correct?

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.

Full Access

Go to page: