Download IBM InfoSphere Optim for Distributed Systems Fundamentals.C2090-552.Pass4Sure.2015-03-25.129q.vcex
| Vendor: | IBM |
| Exam Code: | C2090-552 |
| Exam Name: | IBM InfoSphere Optim for Distributed Systems Fundamentals |
| Date: | Mar 25, 2015 |
| File Size: | 850 KB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
Discount: 20%
Demo Questions
Question 1
Which of the following is NOT an attribute of a Column Map?
- Column Map names are a two part name
- You can create a new Column Map from the Definitions submenu.
- Columns with the same name and compatible data types are not automatically matched.
- If a match is not found for a Destination or Source 2 column, the status is NOT USED or REQUIRED.
Correct answer: C
Question 2
When setting up Optim Connect Studio, which of the following is true?
- Only one binding can be defined for each machine.
- Optim Connect Studio does not support renaming a binding.
- Parallel processing and Query Processor parameters are defined on the Server tab.
- Registration of the product is done using Optim Configuration.
Correct answer: B
Explanation:
answer is corrected. answer is corrected.
Question 3
Once an Archive Collection has been completed and Archive Files have been added, which statement describes how ODM processes the Archive Collection?
- ODM processes Archive Files in alphabetical order
- ODM processes Archive Files in the order they are listed in the collection
- ODM processes Archive Files by the date entered in the collection
- ODM processes Archive Files in the order that you specify in your query
Correct answer: B
Question 4
How do you start the Optim Server when it is installed on Windows?
- It must be started as a service and initiated by root.
- It must be started manually as a process by any user.
- It must be started by a user with the ability to log on as a batch job.
- It must be started automatically when the machine is started.
Correct answer: C
Question 5
Optim relationships are used by all Optim tools. If multiple relationships exist between a pair of tables, which two statements are true? (Choose two.)
- Optim will not allow you to create duplicate relationships between tables.
- Optim will view two relationships between tables as possible duplicates and ignore one.
- Optim will view two relationships between tables as possible duplicates but will still use both if selected.
- Optim allows duplicate relationships but will ignore them if they are in fact duplicate.
- Optim will keep cycling until all relevant rows have been found.
Correct answer: CE
Question 6
After the Relationship Index Analyzer has completed, which two actions can be performed from the pop-up dialog window? (Choose two.)
- Create All Indexes
- Notify DBA Via E-mail
- Create Index
- Create Database Relationship
- Open Access Definition
Correct answer: AC
Question 7
When performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ey Lookup?in the AccessWhen performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ?ey Lookup?in the Access Method of the Table Access Strategy panel for the Delete Request.
Why might Optim be doing a scan even though you have specified to us e a key to access the table?
- The wrong index was chosen for the Optim Primary Key for the table.
- The table has a very large amount of data and the database engine has chosen a different access strategy than what you have specified.
- You do not have authority in the database to specify a key to use.
- Compare Row Contents option was not selected prior to running the Delete Request.
Correct answer: A
Question 8
You discovered a slow performance issue during an archive process with delete deferred. By using the Statistical Report and the Relationship Index Analysis, you were able to determine that there was a missing index on one of the tables. The index has been added to the database, and the Statistical Report reflects that the index is being used for a key lookup. Performance has improved somewhat.
Which two actions will help you to further increase performance of the archive? (Choose two.)
- Force a scan on this table.
- Increase your commit frequency.
- Use more than one database connection for the archive process.
- Increase the Key Lookup Limit for this table.
- Turn the Compare Rows option off.
Correct answer: CD
Question 9
You are having an issue with your Optim Server (running on Linux) and IBM Support has asked you to enable tracing.
Where would you go to enable tracing on the Optim Server?
- By checking the nable Tracing?check box in the Optim Configuration applet in Control PanelBy checking the ?nable Tracing?check box in the Optim Configuration applet in Control Panel
- By editing the pstserv.cfg or pstlocal.cfg file to enable tracing
- By enabling tracing using the Optim Command Line Utility with the keyword TRACING=1
- By using the idden?capabilities within the Windows GUI as explained by IBM SupportBy using the ? idden?capabilities within the Windows GUI as explained by IBM Support
Correct answer: B
Question 10
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?
- ANDEEARS
- SANEEGER
- ANDEEGER
- SANEEAER
Correct answer: B
Explanation:
answer is up-to-date. answer is up-to-date.
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!