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: 71 – (Topic 2)

Which statement describes a generic relationship?

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

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

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

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

Question No: 72 – (Topic 2)

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

  1. quot;Lockquot; will request a table lock from the DBMS so that no other changes can be made.

  2. quot;Lockquot; will lock the column in place so that it is always visible during horizontal scrolling.

  3. quot;Lockquot; will lock the editing session so that no additional changes can be made to that column.

  4. quot;Lockquot; will lock the named Edit Request and finalize it in the Optim Directory.

Answer: B

Question No: 73 – (Topic 2)

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

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

  2. The archived data must be defined to Optim Connect.

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

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

Answer: B

Question No: 74 – (Topic 2)

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

  1. Using the Optim Personal Options, initialize Optim Security and assign a Security Administrator.

  2. Using theOptim Configuration program, initialize Optim Security and assign a Security Administrator.

  3. Edit the default Optim ACD (Access Control Domain) to define roles and grants.

  4. Edit the default Optim FAD (File Access Definition) to define roles andgrants.

Answer: B

Question No: 75 – (Topic 2)

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

  1. Invoke the ColumnMap Editor.

  2. Add additional functionality to the Table Maps that make up a Column Map.

  3. Provide specifications needed to match or exclude columns or when data transformations are needed.

  4. Validate that all data privacy rules established by a specific data governance policy are properly implemented.

Answer: C

Question No: 76 – (Topic 2)

You are planning an installation of IBM Optim. Which two configurations are supported for the Optim Server and Optim Directory? (Choose two.)

  1. Sun Solaris with Oracle or Informix databases

  2. Windows XP Professional with Oracle or Microsoft Access databases

  3. AIX with Oracle or Microsoft SQL Server databases

  4. Ubuntu Linux with DB2 database

  5. AIX with DB2 or Informix databases

Answer: A,E

Question No: 77 – (Topic 2)

Which databases are directly supported on distributed platforms for archiving by Optim?

  1. Sybase, Oracle, Informix, Progress, DB2 LUW, MySQL, Microsoft SQL Server

  2. Informix, Microsoft SQL Server, Sybase, DB2 LUW, Oracle

  3. Microsoft Access, MySQL, Progress, DB2 LUW, Oracle, Informix, Sybase

  4. DB2 LUW, Oracle, Microsoft SQL Server, Microsoft Access

Answer: B

Question No: 78 – (Topic 2)

You are setting up an Optim Connect server on a Solaris machine. Which of the following is NOT a step that must be performed?

  1. Add a machine.

  2. Open the Bindings folder for the machine and add an Optim Connect datasource for the Optim Archive File.

  3. Edit the Daemon Navigator for IRPCD forthe machine to set the Workspace Server Mode to SingleClient.

  4. Enter the TCP/IP address of the Solaris machine in the /etc/hosts.conf file.

Answer: D

Question No: 79 – (Topic 2)

One part of the Optim process report provides detailed performance information about your Archive, Extract and Delete processes, including basic table and selection criteria information as defined in the Access Definition, the number of key values used to retrieve rows, and DBMS Access statistical information. This report is essential for tuning your Optim processes. What is the name of this report and where do you indicate that Optim produce the report?

  1. Process Report; selected for creation on the Archive or Extract Process Request.

  2. Show Steps Report; provided on Access Definition Editor.

  3. Statistical Report; selected for creation on the Archive or Extract Process Request.

  4. File Access Definition Report; selected for use on the Archive Process Request.

Answer: C

Question No: 80 – (Topic 2)

Which statement describes how Optim handles relationships?

  1. If known to Optim, it will follow the relationships as it extracts data.

  2. If known to Optim, it willenforce the referential integrity as it populates the tables.

  3. Optim discovers the relationships by examining the column names, especially in primary keys.

  4. As long as the relationships are defined in a data modeling tool, Optim will automatically usethem.

Answer: A

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.