IBM P2090-070 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM Information Management Optim z/OS Technical Mastery Test v1 |
| Exam Number: | P2090-070 |
| Exam Price: | USD $200 (approximate, subject to change) |
| Available Languages: | English |
| Real Exam Qty: | 40-50 |
| Exam Format: | Multiple Response, Multiple Choice |
| Passing Score: | 66% |
| Exam Duration: | 90 minutes |
| Certificate Validity Period: | Not specified |
| Recommended Training: | IBM Optim Product Documentation |
| Exam Registration: | IBM Certification Portal Pearson VUE IBM Exam Registration |
| Sample Questions: | IBM P2090-070 Sample Questions |
| Exam Way: | Authorized Pearson VUE Test Center or Online Proctored (OnVUE) |
| Pre Condition: | No formal prerequisites; hands-on experience with IBM Optim on z/OS recommended |
| Official Syllabus URL: | https://www.ibm.com/certify |
IBM P2090-070 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: IBM Optim Architecture and Concepts | 20% | - Optim Directory and Security - Relationships, Access Definitions, Table Maps and Column Maps |
| Topic 2: Data Archiving and Data Growth Management | 25% | - Restore and Browse Archived Data - Archive Definition and Process |
| Topic 3: Data Comparison and Synchronization | 15% | - Compare Process and Reports - Convert and Load Operations |
| Topic 4: Installation, Configuration and Administration on z/OS | 20% | - Query Capture and Replay - Setup and Site Options |
| Topic 5: Test Data Management | 20% | - Data Subsetting and Extract - Data Masking and Privacy |
IBM Information Management Optim z/OS Technical Mastery Test v1 Sample Questions:
Question 1
What statement is TRUE about Optim Data Growth solution?
A. ARCHIVE offers Direct or Offline Delete processing when data deletion is deferred.
B. During Delete Process, a row is deleted even if the table has a Delete Restrict relationship to another
table that still contains rows.
C. Group selection processing is available for Archive Processes.
D. The ARC and ACT commands are available for Access Definitions used in both Archive Process and
Extract Process.
Question 2
Which one of the following processes masks data in an existing Extract file and creates a second
Extract file?
A. Insert
B. Convert
C. Extract
D. Load
Question 3
What is NOT a capability of the Table Editor?
A. scroll and view related tables in sync
B. undo changes even after a new "fetch set" has been retrieved
C. allow revision to data by overtyping
D. join several tables
Question 4
Which statement is FALSE about installing Optim for z/OS?
A. Optim provides the CLIST PSTINST for installation using an ISPF dialog.
B. Optim must be installed on each DB2 subsystem in which it is to run.
C. Optim provides installation options such as full install, upgrade to new release, and maintain directory
and sample database.
D. DB2 SYSADM authority and update authority for the load and skeleton libraries are NOT need to install Optim.
Solutions:
| Question 1 Answer: A | Question 2 Answer: B | Question 3 Answer: B | Question 4 Answer: D |


PDF Version Demo






We are confident about the products and aim to help you pass with ease. In case of failure, we will provide a no hassle full money back guarantee for the purchasing fee.
1048 Customer Reviews
Quality and ValueITbraindumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITbraindumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITbraindumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.