Summer Sale Coupon - 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sbfdisc

Note! C2090-552 has been withdrawn.

C2090-552 Practice Exam Questions with Answers IBM InfoSphere Optim for Distributed Systems - V7.3.1 Certification

Question # 6

Once an Archive Collection has been completed and Archive Files have been added, which statement describes how ODM processes the Archive Collection?

A.

ODM processes Archive Files in alphabetical order

B.

ODM processes Archive Files in the order they are listed in the collection

C.

ODM processes Archive Files by the date entered in the collection

D.

ODM processes Archive Files in the order that you specify in your query

Full Access
Question # 7

Consider the following Archive file name that is defined using macros: /home/<$USER>/archives/.AF Which filenames would be generated from this macro? (Note: Assume that the file was created on Monday, February 2, 2009, by the person with the user ID of dev3x and the last sequential number assigned was 263.)

A.

/dev3x/Feb000263.AF

B.

/home/dev3x/archives/MON 264.af

C.

/home/dev3x/archives/Feb264.af

D.

/home/dev3x/archives/MON000264.AF

Full Access
Question # 8

You must have a password to review and change Product Options. What is the default password?

A.

"null"

B.

"softech"

C.

"optim"

D.

"ibm"

Full Access
Question # 9

It is considered a best practice to mask data using functions that produce consistent results (e.g., the same masked values are produced each time the data is masked). Why is this considered a best practice?

A.

Consistency makes it easier to reverse the masking process.

B.

The Optim functions that produce consistent results are the easiest to use.

C.

All Optim functions produce consistent outputs.

D.

Simplifies the daily work for the users/testers of the masked data.

Full Access
Question # 10

Optim objects are saved in the Optim Directory. Which two statements are true about saving Optim objects? (Choose two.)

A.

Optim objects like Column Maps, Table Maps and Access Definitions are saved with two-part names.

B.

Only Optim relationships are saved in the Optim Directory.

C.

If a Column Map is noted as local, with no name, it is used only once and then discarded.

D.

An Archive Request cannot be saved in the Optim Directory.

E.

There may be more than one Optim object with the same name as long as they are different types of objects.

Full Access
Question # 11

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

A.

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

B.

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

C.

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

D.

DB2 LUW, Oracle, Microsoft SQL Server, Microsoft Access

Full Access
Question # 12

Optim is installed on both a Windows workstation and a UNIX Server. Command line jobs have been scheduled as cron jobs on the server. What will cause the scheduled jobs to fail?

A.

A second Optim Windows workstation has been connected directly to the database server.

B.

The connection between the Windows workstation and the UNIX Server has been severed.

C.

The pstlocal.cfg file is invalid.

D.

The optimserver.cfg file is invalid.

Full Access
Question # 13

Which components are required by Optim to access iSeries data?

A.

Oracle with HSODBC, a DB Alias, and a wrapper

B.

InfoSphere Federation Server, a nickname, and a wrapper

C.

InfoSphere Federation Server, a DBLINK, and a nickname

D.

Oracle with Federation, a nickname, and a wrapper

Full Access
Question # 14

Which two statements are true for a Delete Request? (Choose two.)

A.

The Delete Process will delete Tables, Rows and Indexes.

B.

The Delete Process uses an Extract or Archive File to identify the set of Rows to be removed.

C.

Specifications for the Delete Process are stored as an Archive Request.

D.

It is not necessary to save the delete request before it is run.

E.

Delete requests must be run separately.

Full Access
Question # 15

The Optim Directory is built as part of the installation on the first workstation. Which two statements are correct about the Optim Directory? (Choose two.)

A.

The Optim Directory can reside on DB2 LUW, Oracle or Microsoft Access.

B.

There may be more than one Optim Directory and they may reside on both Windows and UNIX.

C.

The Optim Directory can reside on DB2 z/OS, Teradata or Microsoft SQL Server.

D.

The definitions can be migrated from one Optim Directory to another with an Export and Import process.

E.

The Optim Directory is always stored on a Windows workstation.

Full Access
Question # 16

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

A.

Autorun.bat

B.

The graphical user interface

C.

The command line

D.

Install.exe

E.

The Windows GUI

Full Access
Question # 17

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 particular column. Which two of the following can you use to define a data-driven relationship? (Choose two.)

A.

String literals or hexadecimal literals

B.

SUBSTR, RAND, or SEQ Functions

C.

Data privacy functions

D.

NULL, CURRENT_DATE, CURRENT_TIME

E.

Numeric Constants and Boolean Constants

Full Access
Question # 18

On trying to execute Delete, the expected rows are not deleted. There are no messages on the Delete Request Report. What could be the reason for this?

A.

The Optim user does not have the database authority to delete data from the database.

B.

The database is set to read only and so data cannot be delete from it.

C.

Delete Rows after Archive on the Access Definition has not been checked.

D.

The delete was not run at the correct time of day.

Full Access
Question # 19

When designing and building storage profiles that will include writing archived data to other than Tier 1 storage (e.g., Tape, WORM drive), which statement is correct?

A.

All disk type and nondisk storage devices are fully supported by Optim.

B.

Make sure to implement Archive File splitting, as Optim can only write split archive files to nondisk type storage devices.

C.

Make sure that archive files are no larger than 100 MB, as all nondisk supported storage devices can only store data in 100 MB segments.

D.

Local disk processing space is a consideration, since archive data may need to be written first to local disk before any other storage devices.

Full Access