P2090-070 IBM Information Management Optim z/OS Technical Mastery Test v1

This proctored technical mastery test examines Optim z/OS knowledge regarding the ability to identify, manage and close sales opportunities.

The test is applicable to sales representatives who demonstrate sales and technical knowledge of the Optim z/OS product and targets the technical sales
professional who can deliver a comprehensive business solution to customers through solution identification, product differentiation, and competitive
positioning.

This technical mastery test meets one of the technical requirements for the IBM Software Value Incentive Program and counts toward your PartnerWorld membership level. It is strongly advised that the candidate complete the recommendededucation prior to attempting this technical mastery test.
Skill name: Information Management Optim z/OS Technical Professional v1 PartnerWorld skill code: 32001013

Test information
Number of questions: 40
Time allowed in minutes: 75
Required passing score: 70%
Languages: English
Proctored

Section 1 — DATA GROWTH (25%)
Use the BROWSE utility to inspect data
Define an archive criteria
Perform a date-based archive
Perform a restore of archived data

Section 2 — TEST DATA MANAGEMENT (27.5%)
Define an Access Definition using existing DB2 RI relationships
Define an Optim relationship
Perform an extract
Perform a creation and insert of target tables
Use COMPARE to inspect data
Use the EDIT utility against test data

Section 3 — DATA PRIVACY SOLUTION (20%)
Create a CONVERT that uses several method for masking data
Preserve referential integrity during CONVERT
Use COMPARE to assure intended results of masking

Section 4 — COMMON ELEMENTS (22.5%)
Understand the major components of the Optim architecture
Define relationships
Define and review traversal by Access Definition

Section 5 — INSTALLATION, CONFIGURATION, AND SECURITY (5%)
Know the major aspects of installation and security
Know the major aspects of security
QUESTION: No:1
A generic relationship is used between pairs of tables with differing _.

A. base names
B. column names
C. attributes
D. creator IDs

Answer: D

QUESTION: No:2
Which of the following facilities is used to create database objects at a destination without loading data’?

A. Insert
B. Load
C. Create
D. Restore

Answer: C

QUESTION: No:3
What is NOT a function of the Compare component?

A. transform test data to protect privacy
B. compare archived data with current data to evaluate changes
C. identify differences between the contents of two tables
D. analyze differences in data before and after execution of an application

Answer: A

QUESTION: No:4
Which method is NOT a suggested way to examine data in an archive file?

A. Use Optim Browse to examine the archive file contents.
B. Write a custom program using OPTIM’s Archive API.
C. Use Optim Open Data Manager (ODM)
D. Use the ISPF Browse facility to examine the contents of the archive file.

Answer: D

QUESTION: No:5
When including Legacy data in Optim processes, which of the following is FALSE?

A. Legacy Tables are supported not only for the Move Process but also for the Archive Process.
B. A Legacy TabIe’s structure is specified by identifying a “copybook” or building the equivalent from scratch.
C. “Legacy Tables” includes support for sequential datasets, VSAM, and IMS.
D. A Legacy Table must be associated to a Data Source.

Answer: A

Click here to view complete Q&A of P2090-070 exam
Certkingdom Review