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

Dumpsbuddy Logo
  1. Home
  2. IBM
  3. Certified Specialist
  4. C2090-552
  5. IBM InfoSphere Optim for Distributed Systems - V7.3.1 Questions and Answers
Note! IBM has retired the C2090-552 Exam Contact us through Live Chat or email us for more information.

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

Questions 4

How do you start the Optim Server when it is installed on Windows?

Options:

A.

It must be started as a service and initiated by root.

B.

It must be started manually as a process by any user.

C.

It must be started by a user with the ability to log on as a batch job.

D.

It must be started automatically when the machine is started.

Buy Now
Questions 5

Given the following command-line export command: PR0CMND /EXPORT TYPE=EX NAME=%.% Which required parameter is missing from this syntax?

Options:

A.

The name of the export file is missing.

B.

The name of the report file is missing.

C.

The name of the Optim Directory is missing.

D.

The name of the parameter file is missing.

Buy Now
Questions 6

You discovered a slow performance issue during an archive process with delete deferred. By using the Statistical Report and the Relationship Index Analysis, you were able to determine that there was a missing index on one of the tables. The index has been added to the database, and the Statistical Report reflects that the index is being used for a key lookup. Performance has improved somewhat. Which two actions will help you to further increase performance of the archive? (Choose two.)

Options:

A.

Force a scan on this table.

B.

Increase your commit frequency.

C.

Use more than one database connection for the archive process.

D.

Increase the Key Lookup Limit for this table.

E.

Turn the Compare Rows option off.

Buy Now
Questions 7

What are functions of the Compare component?

Options:

A.

Track database changes, transform test data to protect privacy, and identify differences between databases.

B.

Track database changes, identify differences between databases, and analyze test data before and after the application is executed.

C.

Transform test data to protect privacy, identify differences between databases, and analyze test data before and after the application is executed.

D.

Track database changes, compare metadata to protect privacy, and analyze test data before and after the application is executed.

Buy Now
Questions 8

Click the Exhibit button.

Given the information from the Relationships tab of an Access Definition, and the associated Show Steps report as shown in the exhibit, what is the reason that the ITEM 552.S table is listed as UNTRAVERSED?

Options:

A.

Options (2) must be enabled for the relationship between DETAILS and ITEM 552.S.

B.

The DETAILS table is designated as a Reference Table so all relationships are ignored for this table.

C.

Options (1) must be disabled for the relationship between DETAILS and ITEM 552.S.

D.

No relationship exists between ITEM 552.S and any other table.

Buy Now
Questions 9

Click the Exhibit button.

Which Optim high level architecture area is missing from the exhibit for an archiving project requiring a Collection of Archive Files for data reporting and viewing?

Options:

A.

Optim Server

B.

Extended Data Source Manager

C.

WebSphere Application Server

D.

ODM/Optim Connect

Buy Now
Questions 10

When you specify the default minimum retention period for protecting Archive Files on a managed storage system from deletion, when will the files be deleted?

Options:

A.

When the expiration date on the Archive File has been reached, Optim issues a request to the managed storage system to delete the file.

B.

After the minimum retention period expires, the file can be deleted from Optim.

C.

After the minimum retention period expires, the file can be marked deleted by the managed storage system.

D.

After the retention period is reached, the file will be automatically deleted by Optim.

Buy Now
Questions 11

In Optim implementations, which object aligns with the term "business object"?

Options:

A.

Archive Request

B.

Archive Reporting Tool

C.

Access Definition

D.

Archive File Collection

Buy Now
Questions 12

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 13

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

Options:

A.

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

B.

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

C.

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

D.

Edit the default Optim FAD (File Access Definition) to define roles and grants.

Buy Now
Questions 14

When accessing archived data through SQL Server, which statement is true?

Options:

A.

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

B.

The archived data must be defined to Optim Connect.

C.

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

D.

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

Buy Now
Questions 15

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

Options:

A.

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

B.

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

C.

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

D.

The original extract file is modified with the Column Map specifications.

Buy Now
Questions 16

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

Options:

A.

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

B.

Compare Row Contents is selected in the Delete Request Editor

C.

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

D.

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

E.

The table to be deleted has file attachments.

Buy Now
Questions 17

What does an Access Control List protect?

Options:

A.

the Optim program

B.

nav_util

C.

Optim Configuration tasks

D.

any Optim object

Buy Now
Questions 18

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 19

Why is it important to use the ultiple column?feature of Optim masking functions (e.g., Lookup, Hash_Lookup) when using those functions to maskWhy is it important to use the ?ultiple column?feature of Optim masking functions (e.g., Lookup, Hash_Lookup) when using those functions to mask multiple fields in a table?

Options:

A.

Use of the ultiple column?feature makes coding a column map much easier.Use of the ?ultiple column?feature makes coding a column map much easier.

B.

Use of this feature is only a matter of preference.

C.

The ultiple column?feature allows you to concatenate multiple columns into a single column.The ?ultiple column?feature allows you to concatenate multiple columns into a single column.

D.

This feature significantly improves performance during the masking process.

Buy Now
Exam Code: C2090-552
Exam Name: IBM InfoSphere Optim for Distributed Systems - V7.3.1
Last Update: Dec 27, 2024
Questions: 129