Exam Code: C2090-552 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM InfoSphere Optim for Distributed Systems - V7.3.1
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-552 Exam.
2021 Apr C2090-552 Study Guide Questions:
Q41. ODM processes Archive File Collections according to specific rules. Which two answers correctly describe this process? (Choose two.)
A. Tables with the same name and Creator ID must have a different DB Alias.
B. Tables with matching creator IDs and names are unioned.
C. Columns with the same name and incompatible attributes are unioned.
D. To be processed, a table need not exist in every Archive File.
E. Archive File Security is ignored for Archive File Collections.
Answer: B,D
Explanation:
Q42. 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?
A. There is no way to preserve the edits, you will have to re-edit those special test cases each time the data is refreshed from the extract file.
B. Use Compare to generate a file of changes that you can use to update the test database after each refresh.
C. Edit the original extract file to permanently change the values in these specific rows.
D. 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.
Answer: D
Explanation:
Q43. What does an Access Control List protect?
A. the Optim program
B. nav_util
C. Optim Configuration tasks
D. any Optim object
Answer: D
Explanation:
Abreast of the times C2090-552 exam price:
Q44. Where do you enable tracing for Optim Connect?
A. IRPCD.ini
B. optdbg.xml
C. Edit binding using nav_util
D. command switches
Answer: C
Q45. Click the Exhibit button.
Given the information from the Relationships tab of an Access Definition, and the associated Show Steps report as shown in the exhibit, what is the reason that the ITEM 552.S table is listed as UNTRAVERSED?
A. Options (2) must be enabled for the relationship between DETAILS and ITEM 552.S.
B. The DETAILS table is designated as a Reference Table so all relationships are ignored for this table.
C. Options (1) must be disabled for the relationship between DETAILS and ITEM 552.S.
D. No relationship exists between ITEM 552.S and any other table.
Answer: B
Explanation:
Q46. Which databases are directly supported on distributed platforms for archiving by Optim?
A. Sybase, Oracle, Informix, Progress, DB2 LUW, MySQL, Microsoft SQL Server
B. Informix, Microsoft SQL Server, Sybase, DB2 LUW, Oracle
C. Microsoft Access, MySQL, Progress, DB2 LUW, Oracle, Informix, Sybase
D. DB2 LUW, Oracle, Microsoft SQL Server, Microsoft Access
Answer: B
Explanation:
Actual C2090-552 resource:
Q47. During the Convert process, for what are Column Maps used?
A. Invoke the Column Map Editor.
B. Add additional functionality to the Table Maps that make up a Column Map.
C. Provide specifications needed to match or exclude columns or when data transformations are needed.
D. Validate that all data privacy rules established by a specific data governance policy are properly implemented.
Answer: C
Explanation:
Q48. Which statement about disk storage requirements for Archive Index Files is correct?
A. The disk storage requirements are always less than the requirements for the associated Archive Files.
B. The disk storage requirements are always specified in the Optim Directory.
C. The disk storage requirements are often the same or more than the associated Archive Files.
D. The disk storage requirements are the same as the associated Archive Files.
Answer: C
Q49. When editing a table, one can right-click on any column and select "Lock". What does the Lock function do?
A. "Lock" will request a table lock from the DBMS so that no other changes can be made.
B. "Lock" will lock the column in place so that it is always visible during horizontal scrolling.
C. "Lock" will lock the editing session so that no additional changes can be made to that column.
D. "Lock" will lock the named Edit Request and finalize it in the Optim Directory.
Answer: B
Explanation:
Q50. 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?
A. ARC2006Aug01SEQ65.AF is also corrupted and should just be deleted.
B. ARC2006Aug01SEQ65.AF was moved; move it back into the same directory, and you should be able to browse it.
C. The Optim Server needs to be started and then you should be able to browse ARC2006Aug01SEQ65.AF.
D. The Optim Connect daemon is not running and needs to be restarted.
Answer: B
Explanation: