Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-552
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-552.html

IBM InfoSphere Optim for Distributed Systems – V7.3.1

Question No: 61 – (Topic 1)

Which of the following is true about the Archive Directory?

  1. The Archive Directory is specified in the Object Tab.

  2. The Archive Directory is specified in the Access Definition.

  3. If a default Archive Directory is not specified, the default Data Directory specified in

    Personal Options is used.

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

Answer: C

Question No: 62 – (Topic 1)

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.)

  1. A new Optim Primary Key has been defined for the relationship

  2. A new relationship between tables on the list is defined

  3. The indexes used by the database relationship have been modified

  4. A table is added to the list

  5. A column has been added to a table in the relationship chain

Answer: B,D

Question No: 63 – (Topic 1)

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

  1. Optim Connect Server software

  2. Report writer software

  3. Optim Connect Studio software

  4. Oracle HSODBC

Answer: A

Question No: 64 – (Topic 1)

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?

  1. SUBSTR, RAND, IDENTITY, SERIAL, PROP, CONCAT, SEQ

  2. RAND, SHUFFLE, PROP, AGE, CONCAT, SUBSTR, TRANS COL

  3. LOOKUP, PROP, IDENTITY, CURRENCY, SEQ, RAND

  4. SHUFFLE, SUBSTR, SERIAL, PROP, SEQ, LOOKUP

Answer: A

Topic 2, Volume B

Question No: 65 – (Topic 2)

What is the purpose of the Archive Registration Utility?

  1. Create new Archive Entries for Archive Files imported from a different location or for which the entry has been removed.

  2. Create new Archive Files for ArchiveFiles imported from a different location or for which the file has been removed.

  3. Create new Archive Directories for Archive Files exported to a different location or for which the entry has been removed.

  4. Create new Archive Entries for Archive Filesexported to a different location or for which the file has been moved.

Answer: A

Question No: 66 – (Topic 2)

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

  1. Any selection criteria used for the parent table determines the rows retrieved.

  2. Any selection criteria for the parent table is ignored.

  3. Any selection criteria for the child table is ignored unless used in an quot;ANDquot; selection.

  4. Any selection criteria on the child table is automatically inherited by the parent table.

Answer: B

Question No: 67 – (Topic 2)

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?

  1. 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.

  2. The newer version of Optim is automatically compatible with the older version currently installed at the site; do nothing.

  3. From the Configuration Tasks menu, run Apply Maintenance for Optim Directory Access only.

  4. 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:

When configuring an Optim Directory, which of the following DBMS types are supported?

  1. DB2, Oracle, Sybase ASE, SQL Server, and IDMS

  2. DB2, Oracle, Sybase ASE, SQL Server, and Informix

  3. DB2, Oracle, SQL Server, IMS and IDMS

  4. Only DB2 andOracle Answer: B

Question No: 68 – (Topic 2)

Where do you enable tracing for Optim Connect?

  1. IRPCD.ini

  2. optdbg.xml

  3. Edit binding using nav_util

  4. command switches

Answer: C

Question No: 69 – (Topic 2)

Which statement is true about Column Map exits?

  1. Column Map exits can be written in ANSI compliant SQL language.

  2. Column Map exits can only be written in the C programming language.

  3. Column Map exits can only be written in the Optim Basic language.

  4. Column Map exits can be written in many languages, but calls to subroutines must conform to C programming conventions.

Answer: D

Question No: 70 – (Topic 2)

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

  1. It does not matter which table is used as the Start Table in the process.

  2. Any table may be designated the Start Table in the process butthe relationship usage parameters will have to be adjusted accordingly.

  3. All relationships, both DBMS and Optim, are listed in the Access Definition, and will always be traversed in both directions.

  4. Column Maps are used as part of the Access Definition.

Answer: B

100% Ensurepass Free Download!
Download Free Demo:C2090-552 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-552 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.