Proper study guides for Renew IBM IBM InfoSphere Optim for Distributed Systems - V7.3.1 certified begins with IBM C2090-552 preparation products which designed to deliver the High value C2090-552 questions by making you pass the C2090-552 test at your first time. Try the free C2090-552 demo right now.
♥♥ 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
Q51. 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
Q52. Consider the following Archive file name that is defined using macros: /home/<$USER>/archives/<MON $SEQ6>.AF Which filenames would be generated from this macro? (Note: Assume that the file was created on Monday, February 2, 2009, by the person with the user ID of dev3x and the last sequential number assigned was 263.)
A. /dev3x/Feb000263.AF
B. /home/dev3x/archives/MON 264.af
C. /home/dev3x/archives/Feb264.af
D. /home/dev3x/archives/MON000264.AF
Answer: D
Explanation:
Q53. 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:
Q54. Given the command line syntax shown below: PR0CMND /R JOB=ERSONNEL' OUTPUT=PER.TXT MONITOR+ QUIET+ PR0CMND /R JOB=?ERSONNEL' OUTPUT=PER.TXT MONITOR+ QUIET+ Which task is performed?
A. Runs the job named PERSONNEL, places the process report output in a file named PER.TXT, and displays prompts and error dialogs during the process.
B. Schedules a job named PERSONNEL, stores the extracted data in a file named PER.TXT, and displays information dialogs during the process.
C. Runs the job named PERSONNEL, places the process report output in a file named PER.TXT, and displays information dialogs during the process.
D. Schedules the job named PERSONNEL, stores the extracted data in a file named PER.TXT, and displays prompts and error dialogs during the process.
Answer: C
Explanation:
Q55. A client has asked you to decide on the Start Table for the Access Definition. Assume that they are trying to get a subset of the data with a good distribution of data from many different countries. Which two questions should be asked to help decide the possibilities? (Choose two.)
A. Which table has the most data?
B. Where is the data column?
C. Where is the country column?
D. Can you show me your data model?
E. Which table has a self-referencing relationship?
Answer: C,D
Explanation:
Q56. 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:
Q57. You have extracted some data from production to use for a test. After the insert, you used the Edit function to change some values in specific rows to test certain logic in your program. You will be testing for several weeks and want to keep these special test cases, even though you may be re-loading your test data many times. Is there some way to retain these edited values so that they are not lost when the data is refreshed from the extract file?
A. There is no way to preserve the edits, you will have to re-edit those special test cases each time the data is refreshed from the extract file.
B. Use Compare to generate a file of changes that you can use to update the test database after each refresh.
C. Edit the original extract file to permanently change the values in these specific rows.
D. After the data is edited, make an extract file of your test tables, and use this new extract file to refresh your data after each test.
Answer: D
Explanation:
Q58. 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:
Q59. 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:
Q60. Click the Exhibit button.
Using the Optim Editor as shown in the exhibit, you have made multiple changes on each of the updated rows in the SALES and CUSTOMERS tables. You now decide that you want to undo the last change to row 1 in SALES. What should you do?
A. Right-click on the row and choose "Undo Row".
B. Right-click on the row and choose "Undo Change".
C. Right-click on the row and choose "Undo?.
D. Right-click on the row and choose "Undo All".
Answer: C