IBM InfoSphere Optim for Distributed Systems - V7.3.1 v6.0 (C2090-552)

Page:    1 / 9   
Total 128 questions

Which of the following is true about the Archive Directory?

  • A. The Archive Directory is specified in the Object Tab.
  • B. The Archive Directory is specified in the Access Definition.
  • C. If a default Archive Directory is not specified, the default Data Directory specified in Personal Options is used.
  • D. If a default Archive Directory is not specified, the default Data Directory specified in System Options is used.


Answer : C

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


Answer : B,D

In addition to a license, which of the following is necessary to run ODM in a production environment?

  • A. Optim Connect Server software
  • B. Report writer software
  • C. Optim Connect Studio software
  • D. Oracle HSODBC


Answer : A

You are licensed for the Optim Test Data Management solution without the Data Privacy
Option. What is the correct list of functions that you can use within a Column Map?
A. SUBSTR, RAND, IDENTITY, SERIAL, PROP, CONCAT, SEQ
B. RAND, SHUFFLE, PROP, AGE, CONCAT, SUBSTR, TRANS COL
C. LOOKUP, PROP, IDENTITY, CURRENCY, SEQ, RAND
D. SHUFFLE, SUBSTR, SERIAL, PROP, SEQ, LOOKUP



Answer : A Topic 2, Volume B

What is the purpose of the Archive Registration Utility?

  • A. Create new Archive Entries for Archive Files imported from a different location or for which the entry has been removed.
  • B. Create new Archive Files for ArchiveFiles imported from a different location or for which the file has been removed.
  • C. Create new Archive Directories for Archive Files exported to a different location or for which the entry has been removed.
  • D. Create new Archive Entries for Archive Filesexported to a different location or for which the file has been moved.


Answer : A

When creating an Access Definition, why it is important to remember when a relationship is traversed fromchild to parent?

  • A. Any selection criteria used for the parent table determines the rows retrieved.
  • B. Any selection criteria for the parent table is ignored.
  • C. Any selection criteria for the child table is ignored unless used in an "AND" selection.
  • D. Any selection criteria on the child table is automatically inherited by the parent table.


Answer : B

You are installing Optim at a site where they are currently using an older version of Optim.
After replacing the product libraries during the installation, which statement describes what must be performed to make the new version usable?

  • A. From the Configuration Tasksmenu, run both the Apply Maintenance for Optim Directory Access and Apply Maintenance for DB Alias Access tasks to install the new packages/plans.
  • B. The newer version of Optim is automatically compatible with the older version currently installed at the site; do nothing.
  • C. From the Configuration Tasks menu, run Apply Maintenance for Optim Directory Access only.
  • D. The Product Options file for the new version must be copied over to replace the Product Options file for the old version.


Answer : A

Explanation:

QUESTIONNO: 32 -
When configuring an Optim Directory, which of the following DBMS types are supported?
A. DB2, Oracle, Sybase ASE, SQL Server, and IDMS
B. DB2, Oracle, Sybase ASE, SQL Server, and Informix
C. DB2, Oracle, SQL Server, IMS and IDMS

D. Only DB2 andOracle -

Answer: B -

Where do you enable tracing for Optim Connect?

  • A. IRPCD.ini
  • B. optdbg.xml
  • C. Edit binding using nav_util
  • D. command switches


Answer : C

Which statement is true about Column Map exits?

  • A. Column Map exits can be written in ANSI compliant SQL language.
  • B. Column Map exits can only be written in the C programming language.
  • C. Column Map exits can only be written in the Optim Basic language.
  • D. Column Map exits can be written in many languages, but calls to subroutines must conform to C programming conventions.


Answer : D

When creating a subset for testing purposes, which statement is true?

  • A. It does not matter which table is used as the Start Table in the process.
  • B. Any table may be designated the Start Table in the process butthe relationship usage parameters will have to be adjusted accordingly.
  • C. All relationships, both DBMS and Optim, are listed in the Access Definition, and will always be traversed in both directions.
  • D. Column Maps are used as part of the Access Definition.


Answer : B

Which statement describes a generic relationship?

  • A. 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.
  • B. A generic relationship is established when Optim Security is enabled and allows the security administrator to remove duplicate relationships between tablesand automatically point Access Definitions to the unique relationship.
  • C. 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.
  • D. 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.


Answer : C

When editing a table, one can right-click on any column and select "Lock". What does the
Lock function do?

  • A. "Lock" will request a table lock from the DBMS so that no other changes can be made.
  • B. "Lock" will lock the column in place so that it is always visible during horizontal scrolling.
  • C. "Lock" will lock the editing session so that no additional changes can be made to that column.
  • D. "Lock" will lock the named Edit Request and finalize it in the Optim Directory.


Answer : B

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

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


Answer : B

What is the first step, in order to enable Optim security for functional, object, and archive file security?

  • A. Using the Optim Personal Options, initialize Optim Security and assign a Security Administrator.
  • B. Using theOptim Configuration program, initialize Optim Security and assign a Security Administrator.
  • C. Edit the default Optim ACD (Access Control Domain) to define roles and grants.
  • D. Edit the default Optim FAD (File Access Definition) to define roles andgrants.


Answer : B

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

  • A. Invoke the ColumnMap Editor.
  • B. Add additional functionality to the Table Maps that make up a Column Map.
  • C. Provide specifications needed to match or exclude columns or when data transformations are needed.
  • D. Validate that all data privacy rules established by a specific data governance policy are properly implemented.


Answer : C

Page:    1 / 9   
Total 128 questions