P2090-712 Exam Questions

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...

Which file is used as the source file for a restore process?

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?

Which of the following is true regarding Archive Indexes?

What is referenced during an Insert or a Load process?

Which statement is TRUE about the Restore Process?

Which object provides the parameters that Optim uses to communicate with the database?

A generic relationship is used between pairs of tables with differing _____.

Which of the following actions does NOT require a primary key?

Which of the following processes masks data in an existing Extract file and creates a second Extract file?

Where can you define different default Archive File directories for different Optim workstations at user level?

Which of the following utilities is used to create database objects at a destination without loading data?

Which definition is used to fetch data from multiple tables for the Table Editor in a single action?

How does Compare determine that pairs of tables contain corresponding rows?

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?

Which editor can be used to populate a table with randomly generated Social Security Numbers?

What is the naming convention for relationships?

Which of the following file formats is not supported by the Browse Utility?

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?

Which of the following value propositions is true with regards to Optim Archiving?

Which of the following actions requires a primary key?

What tool can be used to create boundary conditions in the test database for application testing?

What components does Optim Test Data Management and Optim Data Privacy require to be installed and configured from the client launchpad?

Which request uses an existing extract file to create a masked extract file?

What components are required for Optim Test Data Management and Optim Data Privacy to be installed and configured from the server launchpad?

Which statement is TRUE about Data Store Aliases?

Which of the following best describes an Archive File Collection?

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?

What does Optim Designer require in order to communicate with a database server?

What is referenced to exclude one or more columns from processing during a Compare Request?

One can define the traversal path for selecting table data in ______.

Which data privacy function can be used to populate a table with random feminine first names?

Which of the following functions does NOT require an Optim Data Privacy Option License?

Which of the following statements is FALSE about the Optim Edit Utility?

Where do you define transformation functions?

What does an Archive process reference to determine rules such as how long to retain the created Archive File before deletion?

What can be used to view data in an archive or extract file?

When can a convert process be initiated using the Optim Designer/Manager interface?

Which statement is true about the extract process?

Which of the following value propositions is true with regards to Optim's Data Privacy capability?

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...

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?

Which statement is true about the Restore Process?

Which scripting language is used to define custom masking functions?

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...

What function maintains relational integrity during data masking?

Which object provides the parameters that Optim uses to communicate with the database?

What Optim command can be used by script to execute Optim batch jobs?

Which statement is true regarding the load process?

Which Database Management System is used by the Optim Repository through Optim Designer?