New Year Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: cramtick70

Note! Following C2090-552 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

C2090-552 IBM InfoSphere Optim for Distributed Systems - V7.3.1 Questions and Answers

Questions 4

You have installed the Optim Server on an AIX system. The system is configured with various internal and external storage options attached to the server. Where should the Optim Temporary Work folder be placed?

Options:

A.

the attached archive appliance

B.

the attached NAS device

C.

the system's internal disk drives

D.

the attached SAN device

Buy Now
Questions 5

Where can the Optim Directory be stored?

Options:

A.

Microsoft Access database running on Windows platforms

B.

SQL Server running on UNIX platform

C.

DB2 UDB for z/OS running on mainframe platform

D.

Oracle running on Windows, UNIX or Linux platforms

Buy Now
Questions 6

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

Options:

A.

Autorun.bat

B.

The graphical user interface

C.

The command line

D.

Install.exe

E.

The Windows GUI

Buy Now
Questions 7

Which Optim method is used to: mask Name and Address fields, produce consistent results, use fictitious yet valid data, and is easy to maintain?

Options:

A.

rand_lookup

B.

shuffle

C.

hash_lookup

D.

cbhash

Buy Now
Questions 8

Which performance enhancement do multiple database connections provide when used during an extract or archive?

Options:

A.

Multiple database connections allow you to extract/archive rows from multiple tables simultaneously including the Start table.

B.

Multiple database connections allow you to extract/archive rows from a single table concurrently.

C.

Multiple database connections allow you to extract/archive rows only from Reference Tables simultaneously.

D.

Multiple database connections cannot be used during extract or archive, only during delete.

Buy Now
Questions 9

What identifies the tables, relationship traversals, and selection criteria for the data to be archived?

Options:

A.

Access Definition

B.

Archive File

C.

Browse Utility

D.

Storage Profile

Buy Now
Questions 10

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

Options:

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.

Buy Now
Questions 11

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

Options:

A.

Optim Connect Server software

B.

Report writer software

C.

Optim Connect Studio software

D.

Oracle HSODBC

Buy Now
Questions 12

A customer wants to Decommission their mainframe. Which scenario will Optim address?

Options:

A.

They want to continue to use the CICS z/OS application to access the data.

B.

Initially, their data was entered into their z/OS DB2 database. They have now decided to use Oracle on an AIX machine. They want to convert the DB2 packages to Oracle stored procedures.

C.

They have data stored in both VSAM and DB2 on the z/OS platform and want to give up both their DB2 z/OS license and their hosted z/OS environment.

D.

They want to store a copy of the application with the archives, in case they have to restore the data.

Buy Now
Questions 13

After the Relationship Index Analyzer has completed, which two actions can be performed from the pop-up dialog window? (Choose two.)

Options:

A.

Create All Indexes

B.

Notify DBA Via E-mail

C.

Create Index

D.

Create Database Relationship

E.

Open Access Definition

Buy Now
Questions 14

Why would you use the Optim File Maintenance Facility?

Options:

A.

To remove rows from registered Archive Files and compress Archive and Extract Files.

B.

To update Archive File Indexes and Register Archive Files that have been moved from their original location.

C.

To remove rows from registered Archive and Extract Files and compress Archive and Extract Files.

D.

To remove rows from registered Archive Files, Extract Files, and database load files, and compress Archive, Extract, and database load Files.

Buy Now
Questions 15

What is the purpose of the Archive Registration Utility?

Options:

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 Archive Files 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 Files exported to a different location or for which the file has been moved.

Buy Now
Questions 16

Which two of the following are true about a Restore Request? (Choose two.)

Options:

A.

You can Create, Modify, or Delete a Restore Request

B.

You cannot Modify a Restore Request

C.

Restore Request cannot be saved

D.

A Restore Request can be saved

E.

A Restore Request is required to put data back to the database

Buy Now
Questions 17

A table contains two columns, CUSTNAME and STATE. You have created the following character expression to mask CUSTNAME: SUBSTR(CUSTNAME,1,3) CONCAT 'EE' + SUBSTR(STATE,1) || SUBSTR(CUSTNAME,5,2) Given the values shown below for CUSTNAME and STATE: CUSTNAME=SANDERS STATE=GA What reflects the value of CUSTNAME after the character expression has been applied?

Options:

A.

ANDEEARS

B.

SANEEGER

C.

ANDEEGER

D.

SANEEAER

Buy Now
Questions 18

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

Options:

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

Buy Now
Questions 19

In a batch file, you can direct the processing that follows the PR0CMND processing, by using the process return code, with one of the statements shown below: (1) For Windows: IF ERRORLEVEL n GOTO x (2) For UNIX or Linux: IF EXITCODE n GOTO x Which Optim command line processing function causes Optim to return the process code based on the success or failure of the process that can subsequently be used to direct the processing of other steps?

Options:

A.

OUTPUT

B.

RETURNCODE

C.

EXITCODE

D.

ERRORLEVEL

Buy Now

Certified Specialist | C2090-552 Questions Answers | C2090-552 Test Prep | IBM InfoSphere Optim for Distributed Systems - V7.3.1 Questions PDF | C2090-552 Online Exam | C2090-552 Practice Test | C2090-552 PDF | C2090-552 Test Questions | C2090-552 Study Material | C2090-552 Exam Preparation | C2090-552 Valid Dumps | C2090-552 Real Questions | Certified Specialist C2090-552 Exam Questions

Exam Code: C2090-552
Exam Name: IBM InfoSphere Optim for Distributed Systems - V7.3.1
Last Update: Dec 26, 2024
Questions: 128