Cause all that matters here is passing the IBM C2090-552 exam. Cause all that you need is a high score of C2090-552 IBM InfoSphere Optim for Distributed Systems - V7.3.1 exam. The only one thing you need to do is downloading Testking C2090-552 exam study guides now. We will not let you down with our money-back guarantee.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-552 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-552 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-552-exam-dumps.html
Q61. 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:
Q62. 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:
Q63. In a batch file, you can direct the processing that follows the PR0CMND processing, by using the process return code, with one of the statements shown below: (1) For Windows: IF ERRORLEVEL n GOTO x (2) For UNIX or Linux: IF EXITCODE n GOTO x Which Optim command line processing function causes Optim to return the process code based on the success or failure of the process that can subsequently be used to direct the processing of other steps?
A. OUTPUT
B. RETURNCODE
C. EXITCODE
D. ERRORLEVEL
Answer: A
Explanation:
Q64. Which of the following is NOT an attribute of a Column Map?
A. Column Map names are a two part name
B. You can create a new Column Map from the Definitions submenu.
C. Columns with the same name and compatible data types are not automatically matched.
D. If a match is not found for a Destination or Source 2 column, the status is NOT USED or REQUIRED.
Answer: C
Explanation:
Q65. Which statement describes advantages of using an Optim Insert process instead of a Load process to populate a test database?
A. An Insert process can always insert all the data successfully regardless of the presence of complex referential integrity (RI) cycles.
B. An Insert process allows for Update/Insert processing in one step; a Load process may not.
C. An Insert process will be faster than a Load process when inserting large volumes of data.
D. An Insert process allows you to use Column Maps to transform data; a Load process does not.
Answer: B
Explanation:
Q66. In addition to a license, which of the following is necessary to run ODM in a production environment?
A. Optim Connect Server software
B. Report writer software
C. Optim Connect Studio software
D. Oracle HSODBC
Answer: A
Explanation:
Q67. Which two statements are true for a Delete Request? (Choose two.)
A. The Delete Process will delete Tables, Rows and Indexes.
B. The Delete Process uses an Extract or Archive File to identify the set of Rows to be removed.
C. Specifications for the Delete Process are stored as an Archive Request.
D. It is not necessary to save the delete request before it is run.
E. Delete requests must be run separately.
Answer: B,D
Explanation:
Q68. Why is it important to use the ultiple column?feature of Optim masking functions (e.g., Lookup, Hash_Lookup) when using those functions to maskWhy is it important to use the ?ultiple column?feature of Optim masking functions (e.g., Lookup, Hash_Lookup) when using those functions to mask multiple fields in a table?
A. Use of the ultiple column?feature makes coding a column map much easier.Use of the ?ultiple column?feature makes coding a column map much easier.
B. Use of this feature is only a matter of preference.
C. The ultiple column?feature allows you to concatenate multiple columns into a single column.The ?ultiple column?feature allows you to concatenate multiple columns into a single column.
D. This feature significantly improves performance during the masking process.
Answer: D
Explanation:
Q69. 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. an AIX Server, Windows Desktop, and Optim DRA
B. a Sun Solaris Server and Multiple Windows Desktops with Rhumba
C. Optim Data Growth with ODM/Optim Connect
D. Optim TDM, DP, and Archive with ODM/Optim Connect
Answer: C
Explanation:
Q70. A ew?in the Status column of the Relationship tab of the Access Definition panel indicates a relationship is being displayed for the first time. WhichA ?ew?in the Status column of the Relationship tab of the Access Definition panel indicates a relationship is being displayed for the first time. Which two events will cause the relationship to be displayed as ew??(Choose two.) two events will cause the relationship to be displayed as ?ew??(Choose two.)
A. A new Optim Primary Key has been defined for the relationship
B. A new relationship between tables on the list is defined
C. The indexes used by the database relationship have been modified
D. A table is added to the list
E. A column has been added to a table in the relationship chain
Answer: B,D
Explanation: