[Free] 2018(Jan) EnsurePass Pass4sure IBM P2090-040 Dumps with VCE and PDF 21-30

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released P2090-040
100% Free Download! 100% Pass Guaranteed!

IBM Information Management Optim Technical Mastery v3

Question No: 21

Which statement is true about Optim relationships?

  1. Primary Key is required

  2. Foreign keys are required

  3. Corresponding columns must have identical data types and attributes

  4. At least one column in a corresponding pair must be specified by column name

Answer: D

Question No: 22

Where do you define transformation functions?

  1. Archive Request Editor

  2. Table Editor

  3. Table Map Editor

  4. Column Map Editor

Answer: D

Question No: 23

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 database object before running the insert process?

  1. Edit utility

  2. Load utility

  3. Create utility

  4. Browse utility

Answer: C

Question No: 24

Which statement is true about the Restore Process?

  1. Data must be loaded into a staging database before being restored to the original database

  2. Data cannot be restored to the original database if the data model has changed

  3. Data can only be restored from one Archive File per process

  4. The Insert Process is one method used to restore data

Answer: D

Question No: 25

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

  1. Shuffle

  2. Transformation Library

  3. Lookup

  4. Propagate

Answer: C

Question No: 26

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 Siebel interface. Which of the following archive access options should be implemented?

  1. ODBC Access

  2. JDBC Access

  3. Native Application Access

  4. XML

Answer: C

Question No: 27

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

  1. During an extract process and an edit process

  2. During an archive process and an extract process

  3. During an archive process and as a standalone convert process

  4. During an insert/load process and as a standalone convert process

Answer: D

Question No: 28

Which of the following actions requires a primary key?

  1. Deleting data

  2. Defining Optim relationships

  3. Comparing data

  4. Defining an Access Definition

Answer: A

Question No: 29

Which scripting language is used to define custom masking functions?

  1. LUA

  2. Perl

  3. Java

  4. PHP

Answer: A

Question No: 30

Which statement is true about the extract process?

  1. Point and Shoot is the only sampling method used for extract process

  2. Extract process can extract data from tables located on different databases

  3. Access definition used in an archive process cannot be used in an extract process

  4. Data in an extract file created from a DB2 database cannot be restored to an Oracle database

Answer: B

100% Ensurepass Free Download!
Download Free Demo:P2090-040 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-040 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.