C2090-461 Exam Questions

What does an Access Control List protect?

You are setting up an Optim Connect server on a Solaris machine. Which of the following is NOT a step that must be performed?

ODM processes Archive File Collections according to specific rules. Which two answers correctly describe this process? (Choose two.)

In which Optim processes can a Column Map be used?

Click the Exhibit button. Given this information from the Relationships tab of an Access Definition, and the information from this Show Steps report in the exhibit, why is the STAT...

ODM/Optim Connect is supported to run on which UNIX/Linux operating system?

After an Archive File and associated Archive Index has been created, you discover that you need to add an additional column to the Archive File Index. Which process would Optim sup...

What is the function of the REMOVEROWS keyword on the Command Line Utility?

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

When positioning ODM/Optim Connect as a mechanism to view archived data, which capability would you promote?

Which components are required by Optim to access iSeries data?

Optim is installed on both a Windows workstation and a UNIX Server. Command line jobs have been scheduled as cron jobs on the server. What will cause the scheduled jobs to fail?

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

When performing a Delete Request against an Oracle Database, you notice that Oracle is not using the Oracle Array Delete capability even though this feature has been enabled. Which...

Which performance enhancement do multiple database connections provide when used during an extract or archive?

One part of the Optim process report provides detailed performance information about your Archive, Extract and Delete processes, including basic table and selection criteria inform...

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

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

You are planning an installation of IBM Optim. Which two configurations are supported for the Optim Server and Optim Directory? (Choose two.)

Where can the Optim Directory be stored?

Which of the following is true of an Archive Action?

You are installing Optim at a site where they are currently using an older version of Optim. After replacing the product libraries during the installation, which statement describe...

When configuring an Optim Directory, which of the following DBMS types are supported?

Where are default variables and prompts for variable values defined?

When creating an Access Definition, why it is important to remember when a relationship is traversed from child to parent?

On trying to execute Delete, the expected rows are not deleted. There are no messages on the Delete Request Report. What could be the reason for this?

When using the Age function within a Column Map to age date values in a source column, there are certain rules that must be followed regarding the data types that are supported. Wh...

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

When creating a subset for testing purposes, which statement is true?

What are two benefits of using Optim archiving for application decommissioning? (Choose two.)

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?

Which Optim method is used to: mask Name and Address fields, produce consistent results, use fictitious yet valid data, and is easy to maintain?

Which of the following could be used as part of an Archive Request?

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

When editing a table, one can right-click on any column and select "Lock". What does the Lock function do?

Which statement is true regarding a data transformation process that uses a Column Map during an Insert/Load process?

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

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 ?ultip...

Which of the following are valid for On Error Options for Error Handling in a Restore Request?

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

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

During the Convert process, for what are Column Maps used?

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

Which statement describes a generic relationship?

Which of the following relationship types does Optim support?

During a proof of concept, you successfully install and configure Optim to archive data from a DB2 LUWtest application database running on an AIX server. A test archive (without de...

Where do you enable tracing for Optim Connect?

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

When installing Optim, what is the minimum disk space needed for the database?

You are planning an installation of IBM Optim. Which two configurations are supported for the Optim Server and Optim Directory? (Choose two.)