Download IBM InfoSphere Optim for Distributed Systems Fundamentals.C2090-552.BrainDumps.2015-03-27.90q.vcex

Vendor: IBM
Exam Code: C2090-552
Exam Name: IBM InfoSphere Optim for Distributed Systems Fundamentals
Date: Mar 27, 2015
File Size: 580 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
It is considered a best practice to mask data using functions that produce consistent results (e.g., the same masked values are produced each time the data is masked). 
Why is this considered a best practice?
  1. Consistency makes it easier to reverse the masking process.
  2. The Optim functions that produce consistent results are the easiest to use.
  3. All Optim functions produce consistent outputs.
  4. Simplifies the daily work for the users/testers of the masked data.
Correct answer: D
Question 2
What identifies the tables, relationship traversals, and selection criteria for the data to be archived?
  1. Access Definition
  2. Archive File
  3. Browse Utility
  4. Storage Profile
Correct answer: A
Question 3
Which statement is true about Optim relationships?
  1. You can reference a maximum of 64 columns for any table in the relationship.
  2. You can use a Large Object (LOB) or SQL variant column.
  3. You can match a literal or constant to a literal or constant. 
  4. You can create a Relationship using an SQL Variant column.
Correct answer: A
Question 4
What is the purpose of records with primary key values of ?1? ?2? and ?3?contained in an Optim lookup table?
  1. They are seed records for every lookup table.
  2. They contain values that can only be accessed from an Optim exit/proc.
  3. They are placeholders that allow the client to quickly locate and create additional lookup tables values.
  4. They provide lookup values in cases where a lookup column contains nulls, or spaces, or zero length values.
Correct answer: D
Explanation:
answer is verified.
answer is verified.
Question 5
Which of the following is true about the Archive Directory?
  1. The Archive Directory is specified in the Object Tab.
  2. The Archive Directory is specified in the Access Definition.
  3. If a default Archive Directory is not specified, the default Data Directory specified in Personal Options is used.
  4. If a default Archive Directory is not specified, the default Data Directory specified in System Options is used.
Correct answer: C
Explanation:
Question 6
You have extracted some data from production to use for a test. After the insert, you used the Edit function to change some values in specific rows to test certain 
logic in your program. You will be testing for several weeks and want to keep these special test cases, even though you may be re-loading your test data many 
times. Is there some way to retain these edited values so that they are not lost when the data is refreshed from the extract file?  
  1. There is no way to preserve the edits, you will have to re-edit those special test cases each time the data is refreshed from the extract file.
  2. Use Compare to generate a file of changes that you can use to update the test database after each refresh.
  3. Edit the original extract file to permanently change the values in these specific rows.
  4. After the data is edited, make an extract file of your test tables, and use this new extract file to refresh your data after each test.
Correct answer: D
Question 7
Which two actions ensure the development of a quality, repeatable Test Data Management (TDM) process? (Choose two.)
  1. building and running Optim extract and convert requests
  2. comparing the output of convert requests with the output of archive requests
  3. setting up indices to ensure that restore functions perform adequately
  4. running load/insert requests to populate target test databases
  5. building test DBMS environments and subsystems
Correct answer: AD
Explanation:
Question 8
A client has asked you to decide on the Start Table for the Access Definition. Assume that they are trying to get a subset of the data with a good distribution of data from many different countries. Which two questions should be asked to help decide the possibilities? (Choose two.)
  1. Which table has the most data?
  2. Where is the data column?
  3. Where is the country column?
  4. Can you show me your data model?
  5. Which table has a self-referencing relationship?
Correct answer: CD
Question 9
What are functions of the Compare component?
  1. Track database changes, transform test data to protect privacy, and identify differences between databases.
  2. Track database changes, identify differences between databases, and analyze test data before and after the application is executed.
  3. Transform test data to protect privacy, identify differences between databases, and analyze test data before and after the application is executed.
  4. Track database changes, compare metadata to protect privacy, and analyze test data before and after the application is executed.
Correct answer: B
Question 10
What does the Convert process do?
  1. Works directly against the database to transform data.
  2. Transforms data in an Archive File to a non-comma separated file. 
  3. Transforms data in an Extract File to a non-comma separated file.
  4. Works directly with the database to merge data.
Correct answer: C
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!