C2090-552 - IBM InfoSphere Optim for Distributed Systems Fundamentals
Go back to IBM
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?
Update the DB Alias to the DB2 LUWtest application database.
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?
Archive Request, Access Definition, Storage Profile, Report Request
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?
From the Configuration Tasks menu, run both the Apply Maintenance for Optim Directory Access and Apply Maintenance for DB Alias Access tasks to install the new packages/plans.
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?
Produce a report using the Optim Report Request Editor set to Security for the report type, then format to the customer requirements.
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?
Archive will not delete rows which have been updated since the time of the Archive Process.
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.)
Use more than one database connection for the archive process.
Increase the Key Lookup Limit for this table.
You are setting up an Optim Connect server on a Solaris machine. Which of the following is NOT a step that must be performed?
Enter the TCP/IP address of the Solaris machine in the /etc/hosts.conf file.
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?
any Optim object
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?
Archive indexes should be specified in the Access Definition that will support the query workload planned for the archived data.
What are functions of the Compare component?
Track database changes, identify differences between databases, and analyze test data before and after the application is executed.
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.)
Use the Collections tab on the Archive Request Editor to specify the collection(s) in which the Archive File should be added automatically.
An Archive File may belong to multiple Archive Collections, and an Archive Collection may contain multiple Archive Files.
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?
Statistical Report; selected for creation on the Archive or Extract Process Request.
For what does Optim allow you to automatically generate file names?
Extract Files, Compare Files, Archive Files, Control Files, and Archive Index Files
When editing a table, one can right-click on any column and select "Lock". What does the Lock function do?
"Lock" will lock the column in place so that it is always visible during horizontal scrolling.
Which of the following is true of an Archive Action?
Archive Actions may be executed when data is processed by an Archive, a Delete or a Restore request.
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 key field in the lookup table that contains the sequence numbers has gaps in those sequence numbers.
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.)
There may be more than one Optim Directory and they may reside on both Windows and UNIX.
The definitions can be migrated from one Optim Directory to another with an Export and Import process.
What does the Convert process do?
Transforms data in an Extract File to a non-comma separated file.
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?
Optim Data Growth with ODM/Optim Connect
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.)
Reduced maintenance costs because application and database maintenance and license fees are no longer paid for the old application and its database, but data remains accessible to the user community.
Optim can store decommissioned data in a compressed format so it will take less storage then it did in production.
Which two statements are true about security initialization when configuring Optim? (Choose two.)
Security may be initialized at a later date.
Functional Security defaults to "disabled".
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.)
Where is the country column?
Can you show me your data model?
You are planning an installation of IBM Optim. Which two configurations are supported for the Optim Server and Optim Directory? (Choose two.)
Sun Solaris with Oracle or Informix databases
AIX with DB2 or Informix databases
Which components are required by Optim to access iSeries data?
InfoSphere Federation Server, a nickname, and a wrapper
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?
After the data is edited, make an extract file of your test tables, and use this new extract file to refresh your data after each test.
Which two of the following are true about a Restore Request? (Choose two.)
You can Create, Modify, or Delete a Restore Request
A Restore Request can be saved
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?
Any selection criteria for the parent table is ignored.
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?
Local disk processing space is a consideration, since archive data may need to be written first to local disk before any other storage devices.
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?
Simplifies the daily work for the users/testers of the masked data.
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?
Create new Archive Entries for Archive Files imported from a different location or for which the entry has been removed.
Which of the following is true about the Archive Directory?
If a default Archive Directory is not specified, the default Data Directory specified in Personal Options is used.
When creating a subset for testing purposes, which statement is true?
Any table may be designated the Start Table in the process but the relationship usage parameters will have to be adjusted accordingly.
What is the function of the REMOVEROWS keyword on the Command Line Utility?
Removes rows specified in selection criteria
Where can the Optim Directory be stored?
Oracle running on Windows, UNIX or Linux platforms
Which two actions ensure the development of a quality, repeatable Test Data Management (TDM) process? (Choose two.)
building and running Optim extract and convert requests
running load/insert requests to populate target test databases
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?
Delete Rows after Archive on the Access Definition has not been checked.
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?
Update the DB Alias to the Oracle test application database.
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?
The userid and password will come from the pstlocal.cfg file if the request originated from the UNIX command line. It will come from the Windows registry if the request originated from Windows.
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?
The pstlocal.cfg file is invalid.
Which of the following could be used as part of an Archive Request?
During the Convert process, for what are Column Maps used?
Provide specifications needed to match or exclude columns or when data transformations are needed.
Which statement is true about Optim relationships?
You can reference a maximum of 64 columns for any table in the relationship.