IBM C2090-552 Test Passed : IBM InfoSphere Optim for Distributed Systems Fundamentals

Optim relationships are used by all Optim tools. If multiple relationships exist between a pair of tables, which two statements are true? (Choose two.)

• A. Optim will view two relationships between tables as possible duplicates and ignore one.
• B. Optim will not allow you to create duplicate relationships between tables.
• C. Optim will view two relationships between tables as possible duplicates but will stilluse both if selected.
• D. Optim will keep cycling until all relevant rows have been found.
• E. Optim allows duplicate relationships but will ignore them if they are in fact duplicate.

When accessing archived datathrough SQL Server, which statement is true?

• A. The Optim Server process must be running on the same machine as the Microsoft SQL
  Server.
• B. The archived data must be defined to Optim Connect.
• C. Oracle Heterogeneous Services must be configured to access Microsoft SQL Server.
• D. SQL Server and Optim must be installed on the same system.

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. The indexes used by the database relationship have been modified
• B. A table is added to the list
• C. A new Optim Primary Key has been defined for the relationship
• D. A new relationship between tables on the list is defined
• E. A column has been added to a table in the relationship chain

Which two statements are true about Optim security roles? (Choose two.)

• A. Default Roles may not be modified to allow or deny Functional Privilege Classes and New Action Privileges.
• B. Functional Privilege classes such as Create New Actions and Create New Definitions can be controlled using Roles.
• C. Edit the FAD (File Access Definition) to control which roles has access to all of the files.
• D. Privileges such asArchive Request and Compare Request can be controlled using Roles
• E. By default, the Access Control Domain allows access to all Optim Actions and privileges. Only denial of privileges can be assigned using roles.

Optim objects are saved in the Optim Directory. Which two statements are true about saving Optim objects? (Choose two.)

• A. If a Column Map is noted as local, with no name, it is used only once and then discarded.
• B. Optim objects like Column Maps, Table Maps andAccess Definitions are saved with two- part names.
• C. Only Optim relationships are saved in the Optim Directory.
• D. An Archive Request cannot be saved in the OptimDirectory.
• E. There may be more than one Optim object with the same name as long as they are different types of objects.