Master the C2090-552 IBM InfoSphere Optim for Distributed Systems - V7.3.1 content and be ready for exam day success quickly with this Pass4sure C2090-552 exam guide. We guarantee it!We make it a reality and give you real C2090-552 questions in our IBM C2090-552 braindumps.Latest 100% VALID IBM C2090-552 Exam Questions Dumps at below page. You can use our IBM C2090-552 braindumps and pass your exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-552 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-552 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-552-exam-dumps.html
Q1. A table contains two columns, CUSTNAME and STATE. You have created the following character expression to mask CUSTNAME: SUBSTR(CUSTNAME,1,3) CONCAT 'EE' + SUBSTR(STATE,1) || SUBSTR(CUSTNAME,5,2) Given the values shown below for CUSTNAME and STATE: CUSTNAME=SANDERS STATE=GA What reflects the value of CUSTNAME after the character expression has been applied?
A. ANDEEARS
B. SANEEGER
C. ANDEEGER
D. SANEEAER
Answer: B
Explanation:
Q2. 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?
A. 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.
B. Use Compare to generate a file of changes that you can use to update the test database after each refresh.
C. Edit the original extract file to permanently change the values in these specific rows.
D. 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.
Answer: D
Explanation:
Q3. Which statement is true about Optim relationships?
A. Primary keys are required.
B. Foreign keys are required.
C. Corresponding columns must be identical and compatible.
D. At least one side in a relationship must be specified by a column name.
Answer: D
Explanation:
Q4. Which two statements are true about Optim security roles? (Choose two.)
A. Functional Privilege classes such as Create New Actions and Create New Definitions can be controlled using Roles.
B. Privileges such as Archive Request and Compare Request can be controlled using Roles
C. By default, the Access Control Domain allows access to all Optim Actions and privileges. Only denial of privileges can be assigned using roles.
D. Default Roles may not be modified to allow or deny Functional Privilege Classes and New Action Privileges.
E. Edit the FAD (File Access Definition) to control which roles has access to all of the files.
Answer: A,B
Explanation:
Q5. Where are default variables and prompts for variable values defined?
A. Compare Request
B. Column Map
C. Access Definition
D. Personal Options
Answer: C
Explanation:
Q6. Where do you enable tracing for Optim Connect?
A. IRPCD.ini
B. optdbg.xml
C. Edit binding using nav_util
D. command switches
Answer: C
Q7. When you specify the default minimum retention period for protecting Archive Files on a managed storage system from deletion, when will the files be deleted?
A. When the expiration date on the Archive File has been reached, Optim issues a request to the managed storage system to delete the file.
B. After the minimum retention period expires, the file can be deleted from Optim.
C. After the minimum retention period expires, the file can be marked deleted by the managed storage system.
D. After the retention period is reached, the file will be automatically deleted by Optim.
Answer: C
Explanation:
Q8. Which of the following are valid for On Error Options for Error Handling in a Restore Request?
A. Stop, Process Row, Skip Row
B. Stop, Continue, Edit Row
C. Process Row, Skip Row, Next Row
D. Process Row, Next Row, Insert Row
Answer: A
Explanation:
Q9. On trying to execute Delete, the expected rows are not deleted. There are no messages on the Delete Request Report. What could be the reason for this?
A. The Optim user does not have the database authority to delete data from the database.
B. The database is set to read only and so data cannot be delete from it.
C. Delete Rows after Archive on the Access Definition has not been checked.
D. The delete was not run at the correct time of day.
Answer: C
Explanation:
Q10. Which statement describes a generic relationship?
A. A generic relationship is used by Optim when two tables don't have a declared relationship but the columns of the primary key match in name and data type.
B. A generic relationship is established when Optim Security is enabled and allows the security administrator to remove duplicate relationships between tables and automatically point Access Definitions to the unique relationship.
C. A generic relationship is used for one or more pairs of tables that have the same base name, column names, and attributes, but different creator ids.
D. A generic relationship is a default relationship that Optim creates between any primary keys declared either in the database or Optim where the column names and datatypes match and have an index.
Answer: C
Explanation: