Black Friday Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. IBM
  3. Certified Specialist
  4. C2090-552 - IBM InfoSphere Optim for Distributed Systems - V7.3.1

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

Demo: 19 questions
Total 128 questions
Get C2090-552 Full Access Download C2090-552 PDF

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

Question 1

What does the Convert process do?

Options:

A.

Works directly against the database to transform data.

B.

Transforms data in an Archive File to a non-comma separated file.

C.

Transforms data in an Extract File to a non-comma separated file.

D.

Works directly with the database to merge data.

Question 2

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

Question 3

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

Options:

A.

/dev3x/Feb000263.AF

B.

/home/dev3x/archives/MON 264.af

C.

/home/dev3x/archives/Feb264.af

D.

/home/dev3x/archives/MON000264.AF

Question 4

Click the Exhibit button.

The client understands that the first two archive files shown in the exhibit are in an inaccessible status. When they try to browse the third archive file in the list, they get the error shown in the foreground window as shown in the exhibit. Which statement is correct?

Options:

A.

ARC2006Aug01SEQ65.AF is also corrupted and should just be deleted.

B.

ARC2006Aug01SEQ65.AF was moved; move it back into the same directory, and you should be able to browse it.

C.

The Optim Server needs to be started and then you should be able to browse ARC2006Aug01SEQ65.AF.

D.

The Optim Connect daemon is not running and needs to be restarted.

Question 5

Optim relationships are used by all Optim tools. If multiple relationships exist between a pair of tables, which two statements are true? (Choose two.)

Options:

A.

Optim will not allow you to create duplicate relationships between tables.

B.

Optim will view two relationships between tables as possible duplicates and ignore one.

C.

Optim will view two relationships between tables as possible duplicates but will still use both if selected.

D.

Optim allows duplicate relationships but will ignore them if they are in fact duplicate.

E.

Optim will keep cycling until all relevant rows have been found.

Question 6

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.

Question 7

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

Options:

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

Question 8

Regarding the ODM/Optim Connect, which statement is true?

Options:

A.

ODM/Optim Connect is used to make all extended data sources seem like Oracle views.

B.

ODM/Optim Connect is used to expose Optim Archive files to applications.

C.

Archive file security is ignored if you use ODM/Optim Connect.

D.

Optim Extract files exposed by ODM/Optim Connect can be queried with normal ANSI SQL statements.

Question 9

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

Question 10

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

Question 11

What is the primary purpose of the Optim Relationship Index Analyzer Dialog?

Options:

A.

It automatically creates indexes regardless of the user's rights on the tables involved in relationships used in all access definitions stored in an

Optim Repository.

B.

It reviews the last time the RDBMS statistics were updated for tables used in an access definition and automatically issues the commands to update them if they have not been run since the last archive.

C.

It analyzes the index b-trees and if they are inefficient, will drop and rebuild the index automatically or can be scheduled.

D.

It analyzes DBMS indexes for relationships used with the Access Definition and to create any needed indexes, if the user has the correct privileges in the database.

Question 12

Which components are required by Optim to access iSeries data?

Options:

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

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

In an Archive Request, which of the following is true about the Database Connections Process Option?

Options:

A.

Increasing Database Connections allows multiple Databases to be accessed concurrently.

B.

Database Connections Process Option is only available if Maximum Database Connections on the Database tab of Personal Options is 2 or more.

C.

Increasing the number of database connections to process small amounts of data may decrease performance.

D.

Setting database connections to 0 allows an unlimited number of threads to be used for an archive.

Question 15

You are using the Hash_Lookup function and errors occur that indicate records are not found in the Lookup Table. What is the cause of this problem?

Options:

A.

The lookup table is too small in relationship to the number of records in the source database table consequently more records need to be added to the lookup table.

B.

The key field in the lookup table that contains the sequence numbers has gaps in those sequence numbers.

C.

This error could not occur, Hash_Lookup will always return a row from the lookup table.

D.

A memory error has occurred and the Optim process must be restarted.

Question 16

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 17

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.

Question 18

What are two valid levels of Optim Security? (Choose two.)

Options:

A.

Database Security

B.

Object Security

C.

Functional Security

D.

Network Security

E.

Extract File Security

Question 19

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

Load More C2090-552 Questions
Demo: 19 questions
Total 128 questions
Get C2090-552 Full Access Download C2090-552 PDF