C2090-461 Exam Questions

You must have a password to review and change Product Options. What is the default password?

Optim objects are saved in the Optim Directory. Which two statements are true about saving Optim objects? (Choose two.)

Given the following command-line export command: PR0CMND /EXPORT TYPE=EX NAME=%.% Which required parameter is missing from this syntax?

Which statement about disk storage requirements for Archive Index Files is correct?

Regarding the ODM/Optim Connect, which statement is true?

Which statement is correct with respect to setting expectations around archive access and reporting?

In a batch file, you can direct the processing that follows the PR0CMND processing, by using the process return code, with one of the statements shown below: (1) For Windows: IF ER...

A customer wants to Decommission their mainframe. Which scenario will Optim address?

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?

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

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

Once an Archive Collection has been completed and Archive Files have been added, which statement describes how ODM processes the Archive Collection?

How do you start the Optim Server when it is installed on Windows?

Optim relationships are used by all Optim tools. If multiple relationships exist between a pair of tables, which two statements are true? (Choose two.)

After the Relationship Index Analyzer has completed, which two actions can be performed from the pop-up dialog window? (Choose two.)

When performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ey Lookup?in the AccessWhen performing a Delete Request, you notice t...

You discovered a slow performance issue during an archive process with delete deferred. By using the Statistical Report and the Relationship Index Analysis, you were able to determ...

You are having an issue with your Optim Server (running on Linux) and IBM Support has asked you to enable tracing. Where would you go to enable tracing on the Optim Server?

A table contains two columns, CUSTNAME and STATE. You have created the following character expression to mask CUSTNAME: SUBSTR(CUSTNAME,1,3) CONCAT 'EE' + SUBSTR(STATE,1) || SUBSTR...

Which of the following are included in an Access Definition?

You have created an Access Definition containing multiple tables. The tables each have primary keys and additional non-unique indexes that have been added over the years. While def...

It is considered a best practice to mask data using functions that produce consistent results (e.g., the same masked values are produced each time the data is masked). Why is this...

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

Which statement is true about Optim relationships?

What is the purpose of records with primary key values of ?1? ?2? and ?3?contained in an Optim lookup table?

Click the Exhibit button. Using the Optim Editor as shown in the exhibit, you have made multiple changes on each of the updated rows in the SALES and CUSTOMERS tables. You now deci...

Click the Exhibit button. The client understands that the first two archive files shown in the exhibit are in an inaccessible status. When they try to browse the third archive file...

A row in a parent table is related to rows in one of several child tables based on a value in a particular column. What is this type of Relationship called?

Which two of the following are true about a Restore Request? (Choose two.)

Which Optim process(es) produce output which can be selectively restored to a database?

In a Delete Request, Compare Row Contents has been checked on the General tab of the Delete Request Editor. What is the impact of this option?

When using Optim to decommission a database, which statement is true?

Which statement is true about Optim relationships?

A customer wants to archive all orders from the Order table that are older than 24 months (2 years). The column name used to determine this is called "Created". How can an Optim de...

Which of the following is true about the Archive Directory?

You have extracted some data from production to use for a test. After the insert, you used the Edit function to change some values in specific rows to test certain logic in your pr...

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