C2090-552試験無料問題集（129題）「IBM InfoSphere Optim for Distributed Systems Fundamentals 認定」

出題：1

You are installing IBM Optim into an Oracle environment. Which statement is correct about user permissions?

A. The installation user's permissions must be deleted once the installation is complete and all DB Aliases are created.

B. Theinstallation user requires the DBA role.

C. The installation user must have the SELECT ANY DICTIONARY role.

D. The installation user is the only user that can run Optim.

正解：C 解答を投票する

出題：2

You can use the silent installer in a UNIX environment to installthe Optim Server. The silent installer is NOT available for which two of the following platforms? (Choose two.)

A. HP-UX 11i v2

B. Solaris 8

C. Red Hat Linux 3

D. IBM AIX 5

E. SUSE 10

正解：B,C 解答を投票する

出題：3

In which Optim processes can a Column Map be used?

A. Archive, Restore

B. Restore, Insert,Load, Convert

C. Archive, Delete, Restore

D. Extract, Convert, Insert, Load, Delete

正解：B 解答を投票する

出題：4

You are licensed for the Optim Test Data Management solution without the Data Privacy
Option. What is the correct list of functions that you can use within a Column Map?

A. LOOKUP, PROP, IDENTITY, CURRENCY, SEQ, RAND

B. SUBSTR, RAND, IDENTITY, SERIAL, PROP, CONCAT, SEQ

C. SHUFFLE, SUBSTR, SERIAL, PROP, SEQ, LOOKUP

D. RAND, SHUFFLE, PROP, AGE, CONCAT, SUBSTR, TRANS COL

正解：B 解答を投票する

出題：5

Which twostatements are true for a Delete Request? (Choose two.)

A. It is not necessary to save the delete request before it is run.

B. The Delete Process will delete Tables, Rows and Indexes.

C. Specifications for the Delete Process are stored as an Archive Request.

D. The Delete Process uses an Extract or Archive File to identify the set of Rows to be removed.

E. Delete requests must be run separately.

正解：A,D 解答を投票する

出題：6

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

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

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

C. Sybase, Informix, Progress, DB2LUW, MySQL, Microsoft SQL Server

D. DB2 LUW, Oracle, Microsoft SQL Server, Microsoft Access

正解：B 解答を投票する

出題：7

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

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

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

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

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

正解：B 解答を投票する

出題：8

Which statement is true about Optim relationships?

A. Corresponding columns must be identical and compatible.

B. Primary keys are required.

C. At least one side in a relationship must be specified by a column name.

D. Foreign keys are required.

正解：C 解答を投票する

C2090-552試験無料問題集「IBM InfoSphere Optim for Distributed Systems Fundamentals 認定」