Massive Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

IBM C2090-552 IBM InfoSphere Optim for Distributed Systems - V7.3.1 Exam Practice Test

Demo: 19 questions
Total 128 questions

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

Question 1

You are having an issue with your Optim Server (running on Linux) and IBM Support has asked you to enable tracing. Where would you go to enable tracing on the Optim Server?

Options:

A.

By checking the nable Tracing?check box in the Optim Configuration applet in Control PanelBy checking the ?nable Tracing?check box in the Optim Configuration applet in Control Panel

B.

By editing the pstserv.cfg or pstlocal.cfg file to enable tracing

C.

By enabling tracing using the Optim Command Line Utility with the keyword TRACING=1

D.

By using the idden?capabilities within the Windows GUI as explained by IBM SupportBy using the ?idden?capabilities within the Windows GUI as explained by IBM Support

Question 2

Although Optim creates files on fixed media, you can also direct certain file type(s) to secondary media, e.g., tape, content addressed storage, or a hierarchical storage management (HSM) system. Which types of file(s) may be directed to secondary media?

Options:

A.

Extract, Archive, and Archive Index Files

B.

Extract and Archive Files

C.

Archive Files only

D.

Archive Index Files only

Question 3

A client has asked you to decide on the Start Table for the Access Definition. Assume that they are trying to get a subset of the data with a good distribution of data from many different countries. Which two questions should be asked to help decide the possibilities? (Choose two.)

Options:

A.

Which table has the most data?

B.

Where is the data column?

C.

Where is the country column?

D.

Can you show me your data model?

E.

Which table has a self-referencing relationship?

Question 4

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

Options:

A.

"null"

B.

"softech"

C.

"optim"

D.

"ibm"

Question 5

When setting up Optim Connect Studio, which of the following is true?

Options:

A.

Only one binding can be defined for each machine.

B.

Optim Connect Studio does not support renaming a binding.

C.

Parallel processing and Query Processor parameters are defined on the Server tab.

D.

Registration of the product is done using Optim Configuration.

Question 6

Which statement about disk storage requirements for Archive Index Files is correct?

Options:

A.

The disk storage requirements are always less than the requirements for the associated Archive Files.

B.

The disk storage requirements are always specified in the Optim Directory.

C.

The disk storage requirements are often the same or more than the associated Archive Files.

D.

The disk storage requirements are the same as the associated Archive Files.

Question 7

What is the purpose of records with primary key values of ?1? ?2? and ?3?contained in an Optim lookup table?

Options:

A.

They are seed records for every lookup table.

B.

They contain values that can only be accessed from an Optim exit/proc.

C.

They are placeholders that allow the client to quickly locate and create additional lookup tables values.

D.

They provide lookup values in cases where a lookup column contains nulls, or spaces, or zero length values.

Question 8

When installing Optim, what is the minimum disk space needed for the database?

Options:

A.

50gb

B.

50mb

C.

As required

D.

500mb

Question 9

When installing Optim, which of the following is true?

Options:

A.

ODM/Optim Connect must be installed during the Optim Installation process.

B.

ODM/Optim Connect must be installed after Optim is successfully installed.

C.

ODM/Optim Connect can be installed either during the Optim installation, or after Optim is successfully installed.

D.

ODM/Optim Connect is not a part of the Optim Installation.

Question 10

When performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ey Lookup?in the AccessWhen performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ?ey Lookup?in the Access Method of the Table Access Strategy panel for the Delete Request. Why might Optim be doing a scan even though you have specified to us e a key to access the table?

Options:

A.

The wrong index was chosen for the Optim Primary Key for the table.

B.

The table has a very large amount of data and the database engine has chosen a different access strategy than what you have specified.

C.

You do not have authority in the database to specify a key to use.

D.

Compare Row Contents option was not selected prior to running the Delete Request.

Question 11

ODM processes Archive File Collections according to specific rules. Which two answers correctly describe this process? (Choose two.)

Options:

A.

Tables with the same name and Creator ID must have a different DB Alias.

B.

Tables with matching creator IDs and names are unioned.

C.

Columns with the same name and incompatible attributes are unioned.

D.

To be processed, a table need not exist in every Archive File.

E.

Archive File Security is ignored for Archive File Collections.

Question 12

ODM/Optim Connect is supported to run on which UNIX/Linux operating system?

Options:

A.

Solaris, AIX, Ubuntu

B.

Red Hat Enterprise Linux, HP-UX, AIX

C.

SUSE Linux Enterprise, Solaris, Fedora

D.

HP-UX, Ubuntu, Red Hat Enterprise Linux

Question 13

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.

Question 14

What is the maximum number of rows allowed in an Archive File?

Options:

A.

1073241824

B.

2**30 - 1

C.

999,999,999

D.

1,000,000,000

Question 15

When configuring an Optim Directory, which of the following DBMS types are supported?

Options:

A.

DB2, Oracle, Sybase ASE, SQL Server, and IDMS

B.

DB2, Oracle, Sybase ASE, SQL Server, and Informix

C.

DB2, Oracle, SQL Server, IMS and IDMS

D.

Only DB2 and Oracle

Question 16

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?

Options:

A.

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

B.

Show Steps Report; provided on Access Definition Editor.

C.

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

D.

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

Question 17

When creating an Access Definition, why it is important to remember when a relationship is traversed from child to parent?

Options:

A.

Any selection criteria used for the parent table determines the rows retrieved.

B.

Any selection criteria for the parent table is ignored.

C.

Any selection criteria for the child table is ignored unless used in an "AND" selection.

D.

Any selection criteria on the child table is automatically inherited by the parent table.

Question 18

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

Options:

A.

Add a machine.

B.

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

C.

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

D.

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

Question 19

Which statement describes a generic relationship?

Options:

A.

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

B.

A generic relationship is established when Optim Security is enabled and allows the security administrator to remove duplicate relationships between tables and automatically point Access Definitions to the unique relationship.

C.

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.

D.

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.

Demo: 19 questions
Total 128 questions