After the Relationship Index Analyzer has completed, which two actions can be performed from the pop-up dialog
After the Relationship Index Analyzer has completed, which two actions can be performed from the pop-up dialog window? (Choose two.)
Which two actions will help you to further increase performance of the archive? (Choose two.)
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 determine that there was a missing index on one of the tables. The index has been added to the database, and the Statistical Report reflects that the index is being used for a key lookup. Performance has improved somewhat.
Which two actions will help you to further increase performance of the archive? (Choose two.)
Why might Optim be doing a scan even though you have specified to us e a key to access the table?
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 that Optim is doing a table scan even though you have specified a key Lookup in the Access Method of the Table Access Strategy panel for the Delete Request. Why might Optim be doing a scan even though you have specified to us e a key to access the table?
Where would you go to enable tracing on the Optim Server?
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?
What reflects the value of CUSTNAME after the character expression has been applied?
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(CUSTNAME,5,2)
Given the values shown below for CUSTNAME and STATE:
CUSTNAME=SANDERS STATE=GA
What reflects the value of CUSTNAME after the character expression has been applied?
Which of the following are included in an Access Definition?
Which of the following are included in an Access Definition?
Which statement is true?
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 defining this archive request you have the choice of defining archive indexes. Which statement is true?
Why is this considered a best practice?
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 considered a best practice?
What identifies the tables, relationship traversals, and selection criteria for the data to be archived?
What identifies the tables, relationship traversals, and selection criteria for the data to be archived?
Which statement is true about Optim relationships?
Which statement is true about Optim relationships?