Testking offers free demo for C2090-552 exam. "IBM InfoSphere Optim for Distributed Systems - V7.3.1", also known as C2090-552 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-552 exam, will help you answer those questions. The C2090-552 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-552 exams and revised by experts!


♥♥ 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. Which databases are directly supported on distributed platforms for Optim Test Data Management? 

A. DB2 LUW, Oracle, Microsoft SQL Server, Microsoft Access 

B. Sybase, Informix, Progress, DB2 LUW, MySQL, Microsoft SQL Server 

C. Informix, Microsoft SQL Server, Sybase, DB2 LUW, Oracle 

D. Microsoft Access, MySQL, Progress, DB2 LUW, Oracle, Sybase 

Answer: C 


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


Q13. What are two valid levels of Optim Security? (Choose two.) 

A. Database Security 

B. Object Security 

C. Functional Security 

D. Network Security 

E. Extract File Security 

Answer: B,C 

Explanation: 


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


Q15. The customer has critical production systems against which Optim archive and delete processes are run. If Optim archive and delete processes are run at the wrong time, it will impact business. Which of the following will resolve the issue? 

A. Using the Optim Configuration program, initialize Optim Security and assign a Security Administrator. For each role, grant or deny the appropriate privileges. 

B. Configure object security, which will deny access to sensitive production objects. 

C. By default, the Access Control Domain allows or denies access to particular Optim functions. 

D. Configure program security to restrict access to the Optim executables. 

Answer: A 

Explanation: 


Q16. When accessing archived data through SQL Server, which statement is true? 

A. Oracle Heterogeneous Services must be configured to access Microsoft SQL Server. 

B. The archived data must be defined to Optim Connect. 

C. SQL Server and Optim must be installed on the same system. 

D. The Optim Server process must be running on the same machine as the Microsoft SQL Server. 

Answer: B 

Explanation: 


Q17. When creating an Access Definition, why it is important to remember when a relationship is traversed from child to parent? 

A. Any selection criteria used for the parent table determines the rows retrieved. 

B. Any selection criteria for the parent table is ignored. 

C. Any selection criteria for the child table is ignored unless used in an "AND" selection. 

D. Any selection criteria on the child table is automatically inherited by the parent table. 

Answer: B 

Explanation: 


Q18. What is the purpose of the Archive Registration Utility? 

A. Create new Archive Entries for Archive Files imported from a different location or for which the entry has been removed. 

B. Create new Archive Files for Archive Files imported from a different location or for which the file has been removed. 

C. Create new Archive Directories for Archive Files exported to a different location or for which the entry has been removed. 

D. Create new Archive Entries for Archive Files exported to a different location or for which the file has been moved. 

Answer: A 

Explanation: 


Q19. When you specify the default minimum retention period for protecting Archive Files on a managed storage system from deletion, when will the files be deleted? 

A. When the expiration date on the Archive File has been reached, Optim issues a request to the managed storage system to delete the file. 

B. After the minimum retention period expires, the file can be deleted from Optim. 

C. After the minimum retention period expires, the file can be marked deleted by the managed storage system. 

D. After the retention period is reached, the file will be automatically deleted by Optim. 

Answer: C 

Explanation: 


Q20. When positioning ODM/Optim Connect as a mechanism to view archived data, which capability would you promote? 

A. Only ODM/Optim Connect provides for access to individual archive files and collections of archive files. 

B. ODM/Optim Connect will provide for the same levels of accessibility regardless of the underlying storage medium. 

C. ODM/Optim Connect can implement row level security for archive data within the ODM/Optim Connect Workspace layer. 

D. ODM/Optim Connect can be run stand-alone without Optim on the same machine. 

Answer: A 

Explanation: