Exam Code: C2090-552 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM InfoSphere Optim for Distributed Systems - V7.3.1
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-552 Exam.
2021 Apr C2090-552 Study Guide Questions:
Q51. 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:
Q52. 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:
Q53. Where can the Optim Directory be stored?
A. DB2 UDB for z/OS running on mainframe platform
B. SQL Server running on UNIX platform
C. DB2 LUW running on Windows, UNIX or Linux platforms
D. Microsoft Access database running on Windows platforms
Answer: C
Explanation:
Refresh C2090-552 practice question:
Q54. 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:
Q55. A customer wants to Decommission their mainframe. Which scenario will Optim address?
A. They want to continue to use the CICS z/OS application to access the data.
B. Initially, their data was entered into their z/OS DB2 database. They have now decided to use Oracle on an AIX machine. They want to convert the DB2 packages to Oracle stored procedures.
C. They have data stored in both VSAM and DB2 on the z/OS platform and want to give up both their DB2 z/OS license and their hosted z/OS environment.
D. They want to store a copy of the application with the archives, in case they have to restore the data.
Answer: C
Explanation:
Q56. A table contains two columns, CUSTNAME and STATE. You have created the following character expression to mask CUSTNAME: SUBSTR(CUSTNAME,1,3) CONCAT 'EE' + SUBSTR(STATE,1) || SUBSTR(CUSTNAME,5,2) Given the values shown below for CUSTNAME and STATE: CUSTNAME=SANDERS STATE=GA What reflects the value of CUSTNAME after the character expression has been applied?
A. ANDEEARS
B. SANEEGER
C. ANDEEGER
D. SANEEAER
Answer: B
Explanation:
Approved C2090-552 questions pool:
Q57. In Optim implementations, which object aligns with the term "business object"?
A. Archive Request
B. Archive Reporting Tool
C. Access Definition
D. Archive File Collection
Answer: C
Explanation:
Q58. 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:
Q59. A data-driven relationship exists when a row in the parent table is related to rows in one of several child tables on the basis of the value in a particular column. Which two of the following can you use to define a data-driven relationship? (Choose two.)
A. String literals or hexadecimal literals
B. SUBSTR, RAND, or SEQ Functions
C. Data privacy functions
D. NULL, CURRENT_DATE, CURRENT_TIME
E. Numeric Constants and Boolean Constants
Answer: A,E
Explanation:
Q60. You are installing IBM Optim into an Oracle environment. Which statement is correct about user permissions?
A. The installation user requires the DBA role.
B. The installation user is the only user that can run Optim.
C. The installation user's permissions must be deleted once the installation is complete and all DB Aliases are created.
D. The installation user must have the SELECT ANY DICTIONARY role.
Answer: D
Explanation: