Virtual of C2090-552 exam topics materials and questions pool for IBM certification for candidates, Real Success Guaranteed with Updated C2090-552 pdf dumps vce Materials. 100% PASS IBM InfoSphere Optim for Distributed Systems - V7.3.1 exam Today!
2021 May C2090-552 Study Guide Questions:
Q61. Although Optim creates files on fixed media, you can also direct certain file type(s) to secondary media, e.g., tape, content addressed storage, or a hierarchical storage management (HSM) system. Which types of file(s) may be directed to secondary media?
A. Extract, Archive, and Archive Index Files
B. Extract and Archive Files
C. Archive Files only
D. Archive Index Files only
Answer: C
Explanation:
Q62. Which statement describes how Optim handles relationships?
A. If known to Optim, it will follow the relationships as it extracts data.
B. If known to Optim, it will enforce the referential integrity as it populates the tables.
C. Optim discovers the relationships by examining the column names, especially in primary keys.
D. As long as the relationships are defined in a data modeling tool, Optim will automatically use them.
Answer: A
Explanation:
Q63. Optim objects are saved in the Optim Directory. Which two statements are true about saving Optim objects? (Choose two.)
A. Optim objects like Column Maps, Table Maps and Access Definitions are saved with two-part names.
B. Only Optim relationships are saved in the Optim Directory.
C. If a Column Map is noted as local, with no name, it is used only once and then discarded.
D. An Archive Request cannot be saved in the Optim Directory.
E. There may be more than one Optim object with the same name as long as they are different types of objects.
Answer: A,E
Explanation:
Renewal C2090-552 free exam:
Q64. Which two of the following are true about a Restore Request? (Choose two.)
A. You can Create, Modify, or Delete a Restore Request
B. You cannot Modify a Restore Request
C. Restore Request cannot be saved
D. A Restore Request can be saved
E. A Restore Request is required to put data back to the database
Answer: A,D
Explanation:
Q65. Which of the following are valid for On Error Options for Error Handling in a Restore Request?
A. Stop, Process Row, Skip Row
B. Stop, Continue, Edit Row
C. Process Row, Skip Row, Next Row
D. Process Row, Next Row, Insert Row
Answer: A
Explanation:
Q66. 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?
A. Produce a report using the Optim import/export utility, then format the output to the customer requirements.Produce a report using the Optim import/export utility, then format the output to the customer? requirements.
B. Produce a report using the Optim Report Request Editor set to Security for the report type, then format to the customer requirements.
C. Produce a report using the operating system commands and utilities on the Optim directories, then format to the customer requirements.
D. Produce a report with the Optim Report Request Editor set to File for the report type, then format to the output to the customer requirements.Produce a report with the Optim Report Request Editor set to File for the report type, then format to the output to the customer? requirements.
Answer: B
Explanation:
Download C2090-552 training materials:
Q67. 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?
A. Archive indexes do not need to be defined since Optim has already detected and included the indexes in the archive request.
B. Archive indexes will automatically be created to mirror the indexes that exist on the tables in the archive request.
C. Archive indexes should be specified in the Access Definition to match all of the indexes on the tables.
D. Archive indexes should be specified in the Access Definition that will support the query workload planned for the archived data.
Answer: D
Explanation:
Q68. 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?
A. Archive Request, Access Definition, Optim Relationships, Column Maps
B. Archive Request and Access Definition only
C. Archive Request, Access Definition, and Table Map
D. Archive Request, Access Definition, Storage Profile, Report Request
Answer: D
Explanation:
Q69. When configuring an Optim Directory, which of the following DBMS types are supported?
A. DB2, Oracle, Sybase ASE, SQL Server, and IDMS
B. DB2, Oracle, Sybase ASE, SQL Server, and Informix
C. DB2, Oracle, SQL Server, IMS and IDMS
D. Only DB2 and Oracle
Answer: B
Q70. What is the maximum number of rows allowed in an Archive File?
A. 1073241824
B. 2**30 - 1
C. 999,999,999
D. 1,000,000,000
Answer: C