Printable of C2090-552 download materials and ebook for IBM certification for customers, 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:
Q21. When you create a new Column Map, which of the following is NOT a valid source?
A. A table in an Extract File
B. A constant value
C. A table in an Archive File
D. A table in a database
Answer: B
Explanation:
Q22. 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?
A. Process Report; selected for creation on the Archive or Extract Process Request.
B. Show Steps Report; provided on Access Definition Editor.
C. Statistical Report; selected for creation on the Archive or Extract Process Request.
D. File Access Definition Report; selected for use on the Archive Process Request.
Answer: C
Explanation:
Q23. You must have a password to review and change Product Options. What is the default password?
A. "null"
B. "softech"
C. "optim"
D. "ibm"
Answer: C
Renovate C2090-552 free exam questions:
Q24. You have installed the Optim Server on an AIX system. The system is configured with various internal and external storage options attached to the server. Where should the Optim Temporary Work folder be placed?
A. the attached archive appliance
B. the attached NAS device
C. the system's internal disk drives
D. the attached SAN device
Answer: C
Explanation:
Q25. Which performance enhancement do multiple database connections provide when used during an extract or archive?
A. Multiple database connections allow you to extract/archive rows from multiple tables simultaneously including the Start table.
B. Multiple database connections allow you to extract/archive rows from a single table concurrently.
C. Multiple database connections allow you to extract/archive rows only from Reference Tables simultaneously.
D. Multiple database connections cannot be used during extract or archive, only during delete.
Answer: B
Q26. After an Archive File and associated Archive Index has been created, you discover that you need to add an additional column to the Archive File Index. Which process would Optim support to accomplish this task?
A. Use the Optim Utility Menu to Access the Archive Index Maintenance Function. Select the
appropriate index from the menu and delete it.
Create a new Archive Index with the appropriate columns and save this index.
B. Since the Archive File cannot be modified, you must create an additional Archive Index with the
correct columns and instruct your users to use this index when performing queries against the
Archive File.
C. Use the Optim Utility Menu to Access the Archive Index Maintenance Function. Select the
appropriate table and modify the Archive Index with the additional columns needed. Execute this
modification and then save it.
D. Once created, Archive Indexes cannot be deleted or modified. You must restore the archived
data to a database and then run the Archive Request again (creating a new Archive File) while
specifying the correct Archive Index as part of the Archive Request.
Answer: C
Explanation:
High value C2090-552 questions pool:
Q27. 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?
A. All disk type and nondisk storage devices are fully supported by Optim.
B. Make sure to implement Archive File splitting, as Optim can only write split archive files to nondisk type storage devices.
C. Make sure that archive files are no larger than 100 MB, as all nondisk supported storage devices can only store data in 100 MB segments.
D. Local disk processing space is a consideration, since archive data may need to be written first to local disk before any other storage devices.
Answer: D
Explanation:
Q28. In an Archive Request, which of the following is true about the Database Connections Process Option?
A. Increasing Database Connections allows multiple Databases to be accessed concurrently.
B. Database Connections Process Option is only available if Maximum Database Connections on the Database tab of Personal Options is 2 or more.
C. Increasing the number of database connections to process small amounts of data may decrease performance.
D. Setting database connections to 0 allows an unlimited number of threads to be used for an archive.
Answer: C
Explanation:
Q29. For what does Optim allow you to automatically generate file names?
A. Access Definitions, Archive Files, Extract Files
B. Archive Requests, Insert Requests, Delete Requests, Compare Requests, Convert Requests, and Edit Requests
C. Extract Files, Compare Files, Archive Files, Control Files, and Archive Index Files
D. all Optim files
Answer: C
Explanation:
Q30. Which two statements are true about Optim security roles? (Choose two.)
A. Functional Privilege classes such as Create New Actions and Create New Definitions can be controlled using Roles.
B. Privileges such as Archive Request and Compare Request can be controlled using Roles
C. By default, the Access Control Domain allows access to all Optim Actions and privileges. Only denial of privileges can be assigned using roles.
D. Default Roles may not be modified to allow or deny Functional Privilege Classes and New Action Privileges.
E. Edit the FAD (File Access Definition) to control which roles has access to all of the files.
Answer: A,B
Explanation: