IBM InfoSphere Optim for Distributed Systems Fundamentals 試験
Question No : 1
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?
Question No : 2
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 in the list, they get the error shown in the foreground window as shown in the exhibit. Which statement is correct?
Question No : 3
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 decide that you want to undo the last change to row 1 in SALES. What should you do?
Question No : 4
What is the purpose of records with primary key values of ?1? ?2? and ?3?contained in an Optim lookup table?
Question No : 5
Which statement is true about Optim relationships?
Question No : 6
What identifies the tables, relationship traversals, and selection criteria for the data to be archived?
Question No : 7
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?
Question No : 8
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?
Question No : 9
Which of the following are included in an Access Definition?
Question No : 10
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?
Question No : 11
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?
Question No : 12
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.)
Question No : 13
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 ?ey 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?
Question No : 14
After the Relationship Index Analyzer has completed, which two actions can be performed from the pop-up dialog window? (Choose two.)
Question No : 15
Optim relationships are used by all Optim tools. If multiple relationships exist between a pair of tables, which two statements are true? (Choose two.)