Our pass rate is high to 98.9% and the similarity percentage between our C2090-552 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the IBM C2090-552 exam in just one try? I am currently studying for the IBM C2090-552 exam. Latest IBM C2090-552 Test exam practice questions and answers, Try IBM C2090-552 Brain Dumps First.
♥♥ 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
Q31. After the Relationship Index Analyzer has completed, which two actions can be performed from the pop-up dialog window? (Choose two.)
A. Create All Indexes
B. Notify DBA Via E-mail
C. Create Index
D. Create Database Relationship
E. Open Access Definition
Answer: A,C
Explanation:
Q32. Which of the following is true about the Archive Directory?
A. The Archive Directory is specified in the Object Tab.
B. The Archive Directory is specified in the Access Definition.
C. If a default Archive Directory is not specified, the default Data Directory specified in Personal Options is used.
D. If a default Archive Directory is not specified, the default Data Directory specified in System Options is used.
Answer: C
Explanation:
Q33. Which two statements are true about security initialization when configuring Optim? (Choose two.)
A. Security may be initialized at a later date.
B. Functional Security defaults to "enabled".
C. By default, the Access Control Domain allows access to all Optim functions.
D. Security initialization must occur as part of the first workstation's configuration.
E. Functional Security defaults to "disabled".
Answer: A,E
Explanation:
Q34. Which Optim method is used to: mask Name and Address fields, produce consistent results, use fictitious yet valid data, and is easy to maintain?
A. rand_lookup
B. shuffle
C. hash_lookup
D. cbhash
Answer: C
Explanation:
Q35. Which statement is correct with respect to setting expectations around archive access and reporting?
A. Access to archive data performs just like a database.
B. ODM/Optim Connect must be used to access the archives.
C. Access using ODM/Optim Connect provides nearline access to archived data.
D. Archive data access should rarely be required.
Answer: C
Explanation:
Q36. Optim is installed on both a Windows workstation and a UNIX Server. Command line jobs have been scheduled as cron jobs on the server. What will cause the scheduled jobs to fail?
A. A second Optim Windows workstation has been connected directly to the database server.
B. The connection between the Windows workstation and the UNIX Server has been severed.
C. The pstlocal.cfg file is invalid.
D. The optimserver.cfg file is invalid.
Answer: C
Explanation:
Q37. Which statement is true about Optim relationships?
A. You can reference a maximum of 64 columns for any table in the relationship.
B. You can use a Large Object (LOB) or SQL variant column.
C. You can match a literal or constant to a literal or constant.
D. You can create a Relationship using an SQL Variant column.
Answer: A
Explanation:
Q38. ODM/Optim Connect is supported to run on which UNIX/Linux operating system?
A. Solaris, AIX, Ubuntu
B. Red Hat Enterprise Linux, HP-UX, AIX
C. SUSE Linux Enterprise, Solaris, Fedora
D. HP-UX, Ubuntu, Red Hat Enterprise Linux
Answer: B
Explanation:
Q39. When editing a table, one can right-click on any column and select "Lock". What does the Lock function do?
A. "Lock" will request a table lock from the DBMS so that no other changes can be made.
B. "Lock" will lock the column in place so that it is always visible during horizontal scrolling.
C. "Lock" will lock the editing session so that no additional changes can be made to that column.
D. "Lock" will lock the named Edit Request and finalize it in the Optim Directory.
Answer: B
Explanation:
Q40. Which of the following is true of an Archive Action?
A. Archive Actions are only executed when the Archive file is browsed using the command line.
B. Archive Actions may be executed when data is processed by an Archive, a Delete or a Restore request.
C. Archive Actions are defined in Personal Options.
D. Archive Actions are saved as part of an extract request.
Answer: B
Explanation: