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

C2090-552 Questions and Answers

Question # 6

Which databases are directly supported on distributed platforms for Optim Test Data Management?

A.

DB2 LUW, Oracle, Microsoft SQL Server, Microsoft Access

B.

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

C.

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

D.

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

Full Access
Question # 7

Which of the following is true about the Archive Directory?

A.

The Archive Directory is specified in the Object Tab.

B.

The Archive Directory is specified in the Access Definition.

C.

If a default Archive Directory is not specified, the default Data Directory specified in Personal Options is used.

D.

If a default Archive Directory is not specified, the default Data Directory specified in System Options is used.

Full Access
Question # 8

What identifies the tables, relationship traversals, and selection criteria for the data to be archived?

A.

Access Definition

B.

Archive File

C.

Browse Utility

D.

Storage Profile

Full Access
Question # 9

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

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.

Full Access
Question # 10

Which of the following is NOT an attribute of a Column Map?

A.

Column Map names are a two part name

B.

You can create a new Column Map from the Definitions submenu.

C.

Columns with the same name and compatible data types are not automatically matched.

D.

If a match is not found for a Destination or Source 2 column, the status is NOT USED or REQUIRED.

Full Access
Question # 11

When using a generic relationship, which of the following must be different between pairs of tables?

A.

base names

B.

column names

C.

creator ids

D.

attributes

Full Access
Question # 12

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

A.

Database Security

B.

Object Security

C.

Functional Security

D.

Network Security

E.

Extract File Security

Full Access
Question # 13

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 # 14

Given the command line syntax shown below: PR0CMND /R JOB=ERSONNEL' OUTPUT=PER.TXT MONITOR+ QUIET+ PR0CMND /R JOB=?ERSONNEL' OUTPUT=PER.TXT MONITOR+ QUIET+ Which task is performed?

A.

Runs the job named PERSONNEL, places the process report output in a file named PER.TXT, and displays prompts and error dialogs during the process.

B.

Schedules a job named PERSONNEL, stores the extracted data in a file named PER.TXT, and displays information dialogs during the process.

C.

Runs the job named PERSONNEL, places the process report output in a file named PER.TXT, and displays information dialogs during the process.

D.

Schedules the job named PERSONNEL, stores the extracted data in a file named PER.TXT, and displays prompts and error dialogs during the process.

Full Access
Question # 15

Which statement describes advantages of using an Optim Insert process instead of a Load process to populate a test database?

A.

An Insert process can always insert all the data successfully regardless of the presence of complex referential integrity (RI) cycles.

B.

An Insert process allows for Update/Insert processing in one step; a Load process may not.

C.

An Insert process will be faster than a Load process when inserting large volumes of data.

D.

An Insert process allows you to use Column Maps to transform data; a Load process does not.

Full Access
Question # 16

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

A.

1073241824

B.

2**30 - 1

C.

999,999,999

D.

1,000,000,000

Full Access
Question # 17

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 # 18

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

A.

Archive Request

B.

Archive Reporting Tool

C.

Access Definition

D.

Archive File Collection

Full Access
Question # 19

A client wants to Decommission an Oracle 9i application and an IMS application. They need to store the data in a central location. They will be accessing the data from various applications including COGNOS, Business Objects, and a home grown JDBC application. What is necessary to ensure success?

A.

an AIX Server, Windows Desktop, and Optim DRA

B.

a Sun Solaris Server and Multiple Windows Desktops with Rhumba

C.

Optim Data Growth with ODM/Optim Connect

D.

Optim TDM, DP, and Archive with ODM/Optim Connect

Full Access