C2090-552 Exam Questions

Which two actions ensure the development of a quality, repeatable Test Data Management (TDM) process? (Choose two.)

A client has asked you to decide on the Start Table for the Access Definition. Assume that they are trying to get a subset of the data with a good distribution of data from many di...

What are functions of the Compare component?

What does the Convert process do?

After running a Convert process, how can the data in the converted Extract File be browsed?

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?

When accessing archived data through SQL Server, which statement is true?

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

Which statement is true about Column Map exits?

When designing and building storage profiles that will include writing archived data to other than Tier 1 storage (e.g., Tape, WORM drive), which statement is correct?

You have exported an Archive Request and checked the 'export subordinate definitions' box. Which types of objects might you expect to find in the export file?

Which statement describes how Optim handles relationships?

What is the purpose of the Archive Registration Utility?

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

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

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?

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?

an Oracle test application database running on a Solaris server. ?A test archive (without deleting data) is initiated from the Optim Server running on a Windows 2003 server and run...

Which two statements are true about security initialization when configuring Optim? (Choose two.)

When installing the Optim Server in a Linux or Unix environment, which two of the following can be used? (Choose two.)

A customer wants filenames that indicate archives are of General Ledger (GL) Journal Entries (JE), created each accounting period (month), as shown below. /home/<$USER>/archives/<G...

Which databases are directly supported on distributed platforms for archiving by Optim?

What is the first step, in order to enable Optim security for functional, object, and archive file security?

The Optim Directory is built as part of the installation on the first workstation. Which two statements are correct about the Optim Directory? (Choose two.)

In the UNIX pstserv.cfg file, if the DBALIASLOGON parameter is set to CLIENT, how does Optim Server obtain the userid and password to log the user onto the database?

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?