000-551 IBM IBM Optim Implementation for Distributed Systems (2009)
QUESTION: 109 Which Optim process(es) produce output which can be selectively restored to a database? A. Archive B. Archive, Compare, and Restore C. Extract and Archive D. Archive, Edit, Extract, Compare, and Restore Answer: A QUESTION: 110 When accessing archived data through SQL Server, which two statements are true? (Choose two.) A. Oracle Heterogeneous Services must be configured to access SQL Server. B. Attunity Studio does not need to be installed on the SQL Server system. C. The archived data must be defined to ODM. D. SQL Server and Optim must be installed on the same system. E. The Optim Server process must be running. Answer: B, C QUESTION: 111 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 QUESTION: 112 During the Convert process, for what are Column Maps used? 39
A. Invoke the Column Map Editor. B. Add additional functionality to the Table Maps that make up a Column Map.
You've reached the end of your free preview.
Want to read all 8 pages?
- Fall '20
- Data Management, Microsoft SQL Server, Archive format, Archive file, A. Optim