IBM InfoSphere Optim for Distributed Systems Fundamentals (C2090-552) Free Practice Test

Question 1

You can specify the default minimum retention period for protecting Archive Files onCentera from deletion. How is the minimum retention period calculated?

A. from the time the Archive Process copies the file to Centera

B. from the time Centera copies the file

C. from the time Centera copies the file from the local file system

D. from the time that the Archive Process copies the file to the local file system

Correct Answer: A

Question 2

For what does Optim allow you to automatically generate file names?

A. all Optim files

B. Access Definitions, Archive Files, Extract Files

C. Archive Requests, Insert Requests, Delete Requests, Compare Requests,Convert
Requests, and Edit Requests

D. Extract Files, Compare Files, Archive Files, Control Files, and Archive Index Files

Correct Answer: D

Question 3

An Archive File Collection is a list of Archive Files that are treated as a single data source by ODM. Which two statements are true regarding Archive Collections? (Choose two.)

A. An Archive File may belong to multiple Archive Collections, and an Archive Collection may contain multiple Archive Files.

B. An Archive File containing multiple tables with the same names and creator ids, but with different DB Aliases, may be stored in an Archive Collection.

C. ODM, by default, processes the Archive Files in the collections in ascending date order based on the dates the Archive Files were created.

D. Archive Files contained within a collection do not need to be registered in the Archive
Directory.

E. Use the Collections tab on the Archive Request Editor to specify the collection(s) in which the Archive File should be added automatically.

Correct Answer: A,E

Question 4

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

A. Optim Connect Server software

B. Optim Connect Studio software

C. Oracle HSODBC

D. Report writer software

Correct Answer: A

Question 5

Which statement describes how Optim handles relationships?

A. If known to Optim, it will follow the relationships as it extracts data.

B. If known to Optim, it willenforce the referential integrity as it populates the tables.

C. Optim discovers the relationships by examining the column names, especially in primary keys.

D. As long as the relationships are defined in a data modeling tool, Optim will automatically usethem.

Correct Answer: A

Question 6

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?

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

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

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

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

Correct Answer: C

Question 7

A tablecontains 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=SANDERSSTATE=GA What reflects the value of
CUSTNAME after the character expression has been applied?

A. SANEEAER

B. ANDEEARS

C. SANEEGER

D. ANDEEGER

Correct Answer: C

Question 8

The customer has critical production systems against whichOptim archive and delete processes are run. If Optim archive and delete processes are run at the wrong time, it will impact business. Which of the following will resolve the issue?

A. Configure program security to restrict access to the Optim executables.

B. By default, the Access Control Domain allows or denies access to particular Optim functions.

C. Using the Optim Configuration program, initialize Optim Security and assign a Security
Administrator. For each role, grant or deny the appropriate privileges.

D. Configure object security, which will deny access to sensitive production objects.

Correct Answer: C

Question 9

A row in a parent table is related to rows in one of several child tables based on a value in a particular column. What is this type of Relationshipcalled?

A. Data-Driven

B. Symbiotic

C. Compound

D. Generic

Correct Answer: A

Question 10

You have enabled and configured Optim Security according to the customer requirements.You have enabled and configured Optim Security according to the customer? requirements. How do you prove this to yourself, the customerand auditors?

A. Produce a report using the Optim import/export utility, then format the output to the customer requirements.Produce a report using the Optim import/export utility, then format the output to the customer? requirements.

B. Produce a reportusing the Optim Report Request Editor set to Security for the report type, then format to the customer requirements.

C. Produce a report with the Optim Report Request Editor set to File for the report type, then format to the output to the customer requirements.Produce a report with the Optim
Report Request Editor set to File for the report type, then format to the outputto the customer? requirements.

D. Produce a report using the operating system commands and utilities on the Optim directories, then format to the customer requirements.

Correct Answer: B

Welcome to TestSimulate

IBM InfoSphere Optim for Distributed Systems Fundamentals (C2090-552) Free Practice Test