P2090-712 Exam Questions
70 real P2090-712 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #1
The data in an extract file is to be inserted into a new test database in which tables and relationships have not been defined. Which Optim utility should be used to define the dat...
- Question #2
Which file is used as the source file for a restore process?
- Question #3
After the data has been archived, what components does Optim require in order to provide and configure seamless access to archive files/collections via ODBC/JDBC/XML?
- Question #4
Which of the following is true regarding Archive Indexes?
- Question #5
What is referenced during an Insert or a Load process?
- Question #6
Which statement is TRUE about the Restore Process?
- Question #7
Which object provides the parameters that Optim uses to communicate with the database?
- Question #9
A generic relationship is used between pairs of tables with differing _____.
- Question #10
Which of the following actions does NOT require a primary key?
- Question #11
Which of the following processes masks data in an existing Extract file and creates a second Extract file?
- Question #12
Where can you define different default Archive File directories for different Optim workstations at user level?
- Question #13
Which of the following utilities is used to create database objects at a destination without loading data?
- Question #14
Which definition is used to fetch data from multiple tables for the Table Editor in a single action?
- Question #15
How does Compare determine that pairs of tables contain corresponding rows?
- Question #16
Which of the following data privacy functions allow one to consistently mask the same first name when you use the same source and NAME_LOOKUP lookup table?
- Question #17
Which editor can be used to populate a table with randomly generated Social Security Numbers?
- Question #18
What is the naming convention for relationships?
- Question #19
Which of the following file formats is not supported by the Browse Utility?
- Question #21
Which of the following data privacy functions allow one to consistently mask the same address when you use the same source and ADDRESS lookup table?
- Question #23
Which of the following value propositions is true with regards to Optim Archiving?
- Question #24
Which of the following actions requires a primary key?
- Question #26
What tool can be used to create boundary conditions in the test database for application testing?
- Question #28
What components does Optim Test Data Management and Optim Data Privacy require to be installed and configured from the client launchpad?
- Question #29
Which request uses an existing extract file to create a masked extract file?
- Question #30
What components are required for Optim Test Data Management and Optim Data Privacy to be installed and configured from the server launchpad?
- Question #31
Which statement is TRUE about Data Store Aliases?
- Question #32
Which of the following best describes an Archive File Collection?
- Question #33
What is the recommended method to extract all customer records with orders made in 2011 and who are now located in the state of California?
- Question #34
What does Optim Designer require in order to communicate with a database server?
- Question #35
What is referenced to exclude one or more columns from processing during a Compare Request?
- Question #36
One can define the traversal path for selecting table data in ______.
- Question #38
Which data privacy function can be used to populate a table with random feminine first names?
- Question #39
Which of the following functions does NOT require an Optim Data Privacy Option License?
- Question #40
Which of the following statements is FALSE about the Optim Edit Utility?
- Question #41
Where do you define transformation functions?
- Question #42
What does an Archive process reference to determine rules such as how long to retain the created Archive File before deletion?
- Question #43
What can be used to view data in an archive or extract file?
- Question #44
When can a convert process be initiated using the Optim Designer/Manager interface?
- Question #45
Which statement is true about the extract process?
- Question #46
Which of the following value propositions is true with regards to Optim's Data Privacy capability?
- Question #47
A customer needs to create relationally-intact subsets of their production database for verification of a new application deployment. Which Optim solutions should be used to handle...
- Question #48
When defining an Access Definition for an Extract Request, we can view the records from the Start Table and select specific records to be extracted. Which Optim feature is this?
- Question #49
Which statement is true about the Restore Process?
- Question #51
Which scripting language is used to define custom masking functions?
- Question #52
An organization uses Optim Archiving to archive historical data from their Siebel application. The application users want to view the archived Siebel records directly from the Sieb...
- Question #53
What function maintains relational integrity during data masking?
- Question #54
Which object provides the parameters that Optim uses to communicate with the database?
- Question #55
What Optim command can be used by script to execute Optim batch jobs?
- Question #56
Which statement is true regarding the load process?
- Question #57
Which Database Management System is used by the Optim Repository through Optim Designer?