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

Which statement is true regarding a data transformation process that uses a Column Map during an Insert/Load process?

  1. Column Maps cannot be used during Insert/Load, only during Convert.

  2. No changes are made to the extract file, only to the rows as they are written to the database.

  3. The original extract file remains unchanged, and a modified copy of the extract file is made with the Column Map specifications applied.

  4. The original extract file is modified with the ColumnMap specifications.

Answer: B

Question No: 92 – (Topic 2)

When using a generic relationship, which of the following must be different between pairs of tables?

  1. base names

  2. column names

  3. creator ids

  4. attributes

Answer: C

Question No: 93 – (Topic 2)

When performing a Delete Request against an Oracle Database, you notice that Oracle is not using the Oracle Array Delete capability even though this feature has been enabled.

Which two of the following might be causing this feature to not be used? (Choose two.)

  1. Compare Row Contents is not selected in the Delete Request Editor.

  2. Compare Row Contents is selected in the Delete Request Editor

  3. The table in the database has a unique primary key, but the table in the file has a non- unique primary key.

  4. Thetable in the database has a non-unique primary key, but the table in the file has a unique primary key.

  5. The table to be deleted has file attachments.

Answer: B,E

Question No: 94 – (Topic 2)

A data-driven relationship exists when a row in the parent table is related to rows in one of several child tables on the basis of the value in a particularcolumn. Which two of the following can you use to define a data-driven relationship? (Choose two.)

  1. String literals or hexadecimal literals

  2. SUBSTR, RAND, or SEQ Functions

  3. Data privacy functions

  4. NULL, CURRENT_DATE, CURRENT_TIME

  5. Numeric Constants and Boolean Constants

Answer: A,E

Question No: 95 – (Topic 2)

During a proof of concept, you successfully install and configure Optim to archive data from an Oracle test application database running on a Solaris server. ?A test archive (without deleting data) is initiated from theOptim Server running on a Windows 2003 server and runs successfully the first day. ?The Optim directory is on a non-application database on the Windows 2003 server. ?During the evening, the client site runs a security routine that automatically deletes any unknown or foreign objects (e.g., packages, plans, procedures) from the application databases running on the Solaris server. ?The next day, the same test

archive will no longer run from the Optim Server. Which step must you perform to enable the archiveto run?

  1. Configure security for the Optim Directory using the Optim Configuration wizard.

  2. Update the DB Alias to the Oracle test application database.

  3. Drop and rebuild the Optim Directory using the Optim Directory wizard.

  4. Re-install the Optim Client and Server on the database on the Solaris server.

Answer: B

Question No: 96 – (Topic 2)

Which components are required byOptim to access iSeries data?

  1. Oracle with HSODBC, a DB Alias, and a wrapper

  2. InfoSphere Federation Server, a nickname, and a wrapper

  3. InfoSphere Federation Server, a DBLINK, and a nickname

  4. Oracle with Federation, a nickname, and a wrapper

Answer: B

Question No: 97 – (Topic 2)

Where can the Optim Directory be stored?

  1. Microsoft Access database running on Windows platforms

  2. SQL Server running on UNIX platform

  3. DB2 UDB for z/OS running onmainframe platform

  4. Oracle running on Windows, UNIX or Linux platforms

Answer: D

Question No: 98 – (Topic 2)

When installing the Optim Server in a Linux or Unix environment, which two of the following can be used? (Choose two.)

  1. Autorun.bat

  2. The graphical user interface

  3. The command line

  4. Install.exe

  5. The Windows GUI

Answer: B,C

Question No: 99 – (Topic 2)

A client wants to Decommission an Oracle 9i application and an IMS application. They need to store the data in a central location. They will be accessing the data from various applications including COGNOS, Business Objects, and a home grown JDBC application. What is necessary to ensure success?

  1. an AIX Server, Windows Desktop, and Optim DRA

  2. a Sun Solaris Server and Multiple Windows Desktops with Rhumba

  3. Optim Data Growth with ODM/Optim Connect

  4. Optim TDM, DP, and Archive with ODM/Optim Connect

Answer: C

Question No: 100 – (Topic 2)

Which of the following are valid for On Error Options for Error Handling in a Restore Request?

  1. Stop, Process Row, Skip Row

  2. Stop, Continue, Edit Row

  3. Process Row, Skip Row, Next Row

  4. Process Row, Next Row, InsertRow

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.