IBM InfoSphere Optim for Distributed Systems Fundamentals - C2090-552 Exam Practice Test

A. Add additional functionality to the Table Maps that make up a Column Map.

B. Provide specifications needed to match or exclude columns or when data transformations are needed.

C. Invoke the ColumnMap Editor.

D. Validate that all data privacy rules established by a specific data governance policy are properly implemented.

A. Theinstallation user requires the DBA role.

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

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

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

A. The database is set to read only and so data cannot be delete from it.

B. The delete was not run at the correct time of day.

C. The Optim user does not have the database authority to delete data from the database.

D. Delete Rows after Archive on the Access Definition has not been checked.

A. Extract, Convert, Insert, Load, Delete

B. Archive, Delete, Restore

C. Restore, Insert,Load, Convert

D. Archive, Restore

A. A tablein an Archive File

B. A constant value

C. A table in an Extract File

D. A table in a database

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

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

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

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

A. a Sun Solaris Server and Multiple Windows Desktops with Rhumba

B. Optim Data Growth with ODM/Optim Connect

C. an AIX Server, Windows Desktop, and Optim DRA

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

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

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

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

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

A. Increasing Database Connections allows multiple Databases to be accessed concurrently.

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

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

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

A. Using theOptim Configuration program, initialize Optim Security and assign a Security
Administrator.

B. Using the Optim Personal Options, initialize Optim Security and assign a Security
Administrator.

C. Edit the default Optim FAD (File Access Definition) to define roles andgrants.

D. Edit the default Optim ACD (Access Control Domain) to define roles and grants.