Pinpoint of C2090-552 download materials and bible for IBM certification for customers, Real Success Guaranteed with Updated C2090-552 pdf dumps vce Materials. 100% PASS IBM InfoSphere Optim for Distributed Systems - V7.3.1 exam Today!
2021 May C2090-552 Study Guide Questions:
Q31. ODM/Optim Connect is supported to run on which UNIX/Linux operating system?
A. Solaris, AIX, Ubuntu
B. Red Hat Enterprise Linux, HP-UX, AIX
C. SUSE Linux Enterprise, Solaris, Fedora
D. HP-UX, Ubuntu, Red Hat Enterprise Linux
Answer: B
Explanation:
Q32. Which statement describes advantages of using an Optim Insert process instead of a Load process to populate a test database?
A. An Insert process can always insert all the data successfully regardless of the presence of complex referential integrity (RI) cycles.
B. An Insert process allows for Update/Insert processing in one step; a Load process may not.
C. An Insert process will be faster than a Load process when inserting large volumes of data.
D. An Insert process allows you to use Column Maps to transform data; a Load process does not.
Answer: B
Explanation:
Q33. When using a generic relationship, which of the following must be different between pairs of tables?
A. base names
B. column names
C. creator ids
D. attributes
Answer: C
Explanation:
Most up-to-date C2090-552 free question:
Q34. A ew?in the Status column of the Relationship tab of the Access Definition panel indicates a relationship is being displayed for the first time. WhichA ?ew?in the Status column of the Relationship tab of the Access Definition panel indicates a relationship is being displayed for the first time. Which two events will cause the relationship to be displayed as ew??(Choose two.) two events will cause the relationship to be displayed as ?ew??(Choose two.)
A. A new Optim Primary Key has been defined for the relationship
B. A new relationship between tables on the list is defined
C. The indexes used by the database relationship have been modified
D. A table is added to the list
E. A column has been added to a table in the relationship chain
Answer: B,D
Explanation:
Q35. Optim relationships are used by all Optim tools. If multiple relationships exist between a pair of tables, which two statements are true? (Choose two.)
A. Optim will not allow you to create duplicate relationships between tables.
B. Optim will view two relationships between tables as possible duplicates and ignore one.
C. Optim will view two relationships between tables as possible duplicates but will still use both if selected.
D. Optim allows duplicate relationships but will ignore them if they are in fact duplicate.
E. Optim will keep cycling until all relevant rows have been found.
Answer: C,E
Explanation:
Q36. What is the primary purpose of the Optim Relationship Index Analyzer Dialog?
A. It automatically creates indexes regardless of the user's rights on the tables involved in relationships used in all access definitions stored in an Optim Repository.
B. It reviews the last time the RDBMS statistics were updated for tables used in an access definition and automatically issues the commands to update them if they have not been run since the last archive.
C. It analyzes the index b-trees and if they are inefficient, will drop and rebuild the index automatically or can be scheduled.
D. It analyzes DBMS indexes for relationships used with the Access Definition and to create any needed indexes, if the user has the correct privileges in the database.
Answer: D
Explanation:
Precise C2090-552 study guides:
Q37. A customer wants to archive all orders from the Order table that are older than 24 months (2 years). The column name used to determine this is called "Created". How can an Optim developer implement this requirement?
A. Create a storage profile that will automatically delete the archive after two years based upon the system date minus the created column if one record in the start table meets the criteria.
B. Open the Orders access definition, position the cursor on the Order table and right click and use the archive actions tab from the "Table Specification" pop-up menu to enter a SQL statement fragment "Created before(24M)".
C. Open the Orders access definition, position the cursor on the Order table and right click and use the Selection Criteria tab on the "Table Specification" pop-up menu and find the "Created" column and enter the "before(24M)" for the selection criteria.
D. Open the relationship editor for each child table related to orders and add "before(24M)" as an expression.
Answer: C
Explanation:
Q38. You can specify the default minimum retention period for protecting Archive Files on Centera from deletion. How is the minimum retention period calculated?
A. from the time Centera copies the file
B. from the time the Archive Process copies the file to Centera
C. from the time that the Archive Process copies the file to the local file system
D. from the time Centera copies the file from the local file system
Answer: B
Explanation:
Q39. 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?
A. 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
B. By editing the pstserv.cfg or pstlocal.cfg file to enable tracing C. By enabling tracing using the Optim Command Line Utility with the keyword TRACING=1
D. 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
Answer: B
Explanation:
Q40. 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.)
A. Which table has the most data?
B. Where is the data column?
C. Where is the country column?
D. Can you show me your data model?
E. Which table has a self-referencing relationship?
Answer: C,D
Explanation: