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 Exambible 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

Q11. What is the first step, in order to enable Optim security for functional, object, and archive file security? 

A. Using the Optim Personal Options, initialize Optim Security and assign a Security Administrator. 

B. Using the Optim Configuration program, initialize Optim Security and assign a Security Administrator. 

C. Edit the default Optim ACD (Access Control Domain) to define roles and grants. 

D. Edit the default Optim FAD (File Access Definition) to define roles and grants. 

Answer: B 

Explanation: 


Q12. When performing an archive process that uses a Storage Profile, which action could be performed as a result of using the storage profile? 

A. Creates a connection to the database for use by the storage management device. 

B. Creates a connection to the storage management device and copies an Archive File to a backup device. 

C. Creates a storage allocation parameter for the storage or file management system. 

D. Creates a duplicate of the existing information from the Archive Repository on the storage management device. 

Answer: B 

Explanation: 


Q13. Given the following command-line export command: PR0CMND /EXPORT TYPE=EX NAME=%.% Which required parameter is missing from this syntax? 

A. The name of the export file is missing. 

B. The name of the report file is missing. 

C. The name of the Optim Directory is missing. 

D. The name of the parameter file is missing. 

Answer: A 

Explanation: 


Q14. 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: 


Q15. Which components are required by Optim to access iSeries data? 

A. Oracle with HSODBC, a DB Alias, and a wrapper 

B. InfoSphere Federation Server, a nickname, and a wrapper 

C. InfoSphere Federation Server, a DBLINK, and a nickname 

D. Oracle with Federation, a nickname, and a wrapper 

Answer: B 

Explanation: 


Q16. Once an Archive Collection has been completed and Archive Files have been added, which statement describes how ODM processes the Archive Collection? 

A. ODM processes Archive Files in alphabetical order 

B. ODM processes Archive Files in the order they are listed in the collection 

C. ODM processes Archive Files by the date entered in the collection 

D. ODM processes Archive Files in the order that you specify in your query 

Answer: B 

Explanation: 


Q17. 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: 


Q18. Which statement is true regarding a data transformation process that uses a Column Map during an Insert/Load process? 

A. Column Maps cannot be used during Insert/Load, only during Convert. 

B. No changes are made to the extract file, only to the rows as they are written to the database. 

C. The original extract file remains unchanged, and a modified copy of the extract file is made with the Column Map specifications applied. 

D. The original extract file is modified with the Column Map specifications. 

Answer: B 

Explanation: 


Q19. 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 


Q20. When using a generic relationship, which of the following must be different between pairs of tables? 

A. base names 

B. column names 

C. creator ids 

D. attributes 

Answer: C 

Explanation: