100% Guarantee of C2090-552 study guide materials and ebook for IBM certification for client, Real Success Guaranteed with Updated C2090-552 pdf dumps vce Materials. 100% PASS IBM InfoSphere Optim for Distributed Systems - V7.3.1 exam Today!
2021 May C2090-552 Study Guide Questions:
Q1. 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:
Q2. A customer wants filenames that indicate archives are of General Ledger (GL) Journal Entries (JE), created each accounting period (month), as shown below. /home/<$USER>/archives/<GLJE $DD $MON $YY _s $SEQ3>.AF Which filename would be generated from this macro? (Note: Assume that the file was created on Monday, August 29, 2011, by the person with the user ID of PSFT_GL, and the last sequential number assigned was 263.)
A. /home/PSFT_GL/archives/Aug_s263.AF
B. /home/PSFT_GL/archives/GLJE_MON_s264.AF
C. /home/USER/archives/GLJE29AUG2011_s264.AF
D. /home/PSFT_GL/archives/GLJE29AUG11_s264.AF
Answer: D
Explanation:
Q3. 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:
Update C2090-552 testing engine:
Q4. Why would you use the Optim File Maintenance Facility?
A. To remove rows from registered Archive Files and compress Archive and Extract Files.
B. To update Archive File Indexes and Register Archive Files that have been moved from their original location.
C. To remove rows from registered Archive and Extract Files and compress Archive and Extract Files.
D. To remove rows from registered Archive Files, Extract Files, and database load files, and compress Archive, Extract, and database load Files.
Answer: A
Explanation:
Q5. What does the Convert process do?
A. Works directly against the database to transform data.
B. Transforms data in an Archive File to a non-comma separated file.
C. Transforms data in an Extract File to a non-comma separated file.
D. Works directly with the database to merge data.
Answer: C
Explanation:
Q6. Which of the following are included in an Access Definition?
A. Selection Criteria, Grouping Specifications
B. Table Maps, Column Maps
C. Column Lists, Report Specifications
D. Privacy Functions, Sort Criteria
Answer: A
Explanation:
Vivid C2090-552 lab:
Q7. What are functions of the Compare component?
A. Track database changes, transform test data to protect privacy, and identify differences between databases.
B. Track database changes, identify differences between databases, and analyze test data before and after the application is executed.
C. Transform test data to protect privacy, identify differences between databases, and analyze test data before and after the application is executed.
D. Track database changes, compare metadata to protect privacy, and analyze test data before and after the application is executed.
Answer: B
Explanation:
Q8. During a proof of concept, you successfully install and configure Optim to archive data from an Oracle test application database running on a Solaris server. ?A test archive (without deleting data) is initiated from the Optim Server running on a Windows 2003 server and runs successfully the first day. ?The Optim directory is on a non-application database on the Windows 2003 server. ?During the evening, the client site runs a security routine that automatically deletes any unknown or foreign objects (e.g., packages, plans, procedures) from the application databases running on the Solaris server. ?The next day, the same test archive will no longer run from the Optim Server. Which step must you perform to enable the archive to run?
A. Configure security for the Optim Directory using the Optim Configuration wizard.
B. Update the DB Alias to the Oracle test application database.
C. Drop and rebuild the Optim Directory using the Optim Directory wizard.
D. Re-install the Optim Client and Server on the database on the Solaris server.
Answer: B
Explanation:
Q9. You are installing Optim at a site where they are currently using an older version of Optim. After replacing the product libraries during the installation, which statement describes what must be performed to make the new version usable?
A. From the Configuration Tasks menu, run both the Apply Maintenance for Optim Directory Access and Apply Maintenance for DB Alias Access tasks to install the new packages/plans.
B. The newer version of Optim is automatically compatible with the older version currently installed at the site; do nothing.
C. From the Configuration Tasks menu, run Apply Maintenance for Optim Directory Access only.
D. The Product Options file for the new version must be copied over to replace the Product Options file for the old version.
Answer: A
Explanation:
Q10. Which two actions ensure the development of a quality, repeatable Test Data Management (TDM) process? (Choose two.)
A. building and running Optim extract and convert requests
B. comparing the output of convert requests with the output of archive requests
C. setting up indices to ensure that restore functions perform adequately
D. running load/insert requests to populate target test databases
E. building test DBMS environments and subsystems
Answer: A,D
Explanation: