C2090-552 - IBM InfoSphere Optim for Distributed Systems Fundamentals

Go back to IBM

Example Questions

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 deleting data) is initiated from the Optim Server running on a Windows 2003 server and runs successfully the first day. · The Optim directory is on a non-application database on the Windows 2003 server. · During the evening, the client site runs a security routine that automatically deletes any unknown or foreign objects (e.g., packages, plans, procedures) from the application databases running on the AIX server. · The next day, the same test archive will no longer run from the Optim Server. Which step must you perform to enable the archive to run? 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? 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 describes what must be performed to make the new version usable? 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? 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 you prove this to yourself, the customer and auditors? 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? 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.) You are setting up an Optim Connect server on a Solaris machine. Which of the following is NOT a step that must be performed? Which Optim method is used to: mask Name and Address fields, produce consistent results, use fictitious yet valid data, and is easy to maintain? What does an Access Control List protect? What is the maximum number of rows allowed in an Archive File? 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? What are functions of the Compare component? 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.) One part of the Optim process report provides detailed performance information about your Archive, Extract and Delete processes, including basic table and selection criteria information as defined in the Access Definition, the number of key values used to retrieve rows, and DBMS Access statistical information. This report is essential for tuning your Optim processes. What is the name of this report and where do you indicate that Optim produce the report? For what does Optim allow you to automatically generate file names? When editing a table, one can right-click on any column and select "Lock". What does the Lock function do? Which of the following is true of an Archive Action? What identifies the tables, relationship traversals, and selection criteria for the data to be archived? 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? 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.) What does the Convert process do? 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 applications including COGNOS, Business Objects, and a home grown JDBC application. What is necessary to ensure success? 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/<GLJE $DD $MON $YY _s $SEQ3>.AF Which filename would be generated from this macro? (Note: Assume that the file was created on Monday, August 29, 2011, by the person with the user ID of PSFT_GL, and the last sequential number assigned was 263.) What are two benefits of using Optim archiving for application decommissioning? (Choose two.) Which two statements are true about security initialization when configuring Optim? (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 different countries. Which two questions should be asked to help decide the possibilities? (Choose two.) You are planning an installation of IBM Optim. Which two configurations are supported for the Optim Server and Optim Directory? (Choose two.) Which components are required by Optim to access iSeries data? 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 program. You will be testing for several weeks and want to keep these special test cases, even though you may be re-loading your test data many times. Is there some way to retain these edited values so that they are not lost when the data is refreshed from the extract file? 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? When creating an Access Definition, why it is important to remember when a relationship is traversed from child to parent? 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? When using a generic relationship, which of the following must be different between pairs of tables? 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? 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? What is the purpose of the Archive Registration Utility? Which of the following is true about the Archive Directory? When creating a subset for testing purposes, which statement is true? What is the function of the REMOVEROWS keyword on the Command Line Utility? Where can the Optim Directory be stored? Which two actions ensure the development of a quality, repeatable Test Data Management (TDM) process? (Choose two.) 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? During a proof of concept, you successfully install and configure Optim to archive data from 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 runs successfully the first day. ?The Optim directory is on a non-application database on the Windows 2003 server. ?During the evening, the client site runs a security routine that automatically deletes any unknown or foreign objects (e.g., packages, plans, procedures) from the application databases running on the Solaris server. ?The next day, the same test archive will no longer run from the Optim Server. Which step must you perform to enable the archive to run? 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? 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? Which of the following could be used as part of an Archive Request? During the Convert process, for what are Column Maps used? Which statement is true about Optim relationships?