Latest Free 000-551 practice exam demo
IBM – IBM Certified Specialist – IBM Optim Implementation for Dist 000-551 Practice exam
Exam Number/Code: 000-551
Questions and Answers:143 Q&As
Updated: 2009-08-18
Register for Exam: Prometric/Pearson VUE
Exam Name:IBM Certified Specialist – IBM Optim Implementation for Dist
Free 000-551 Demo Download
Examsoon offers free demo for Certified Specialist 000-551 Practice exam (IBM Certified Specialist – IBM Optim Implementation for Dist). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.
Free Download 000-551 PDF Practice exam
Exam : IBM 000-551
Title : IBM Certified Specialist – IBM Optim Implementation for Dist
1. What are two possible locations where would you could find the fetch strategy chosen by Attunity when working with an extended data source? (Choose two.)
A. nav.log
B. irpcd.log
C. optdbg.xml
D. db2trc file
E. admin_svc.log
Answer: AC
2. You have exported an Archive Request and checked the ‘export subordinate definitions’ box. Which types of objects might you expect to find in the export file?
A. Archive Request, Access Definition, Optim Relationships, Optim Primary Keys
B. Archive Request and Access Definition only
C. Archive Request, Access Definition, and Table Map
D. Archive Request, Access Definition, Storage Profile, Report Request
Answer: D
3. The Optim Initialization Exit facility provides which three benefits? (Choose three.)
A. Observes what is being done by a given user at various points in a programs logic.
B. Automates the reporting of Optim requests that fail.
C. Ensures that the users request meets your company security standards.
D. Changes the request, if needed, to pass your company standards or forbids the request altogether.
E. Adds support to Optim for new code pages.
Answer: ACD
4. 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
5. Given the command line syntax shown below:
PR0CMND /R JOB=PERSONNEL’ OUTPUT=PER.TXT MONITOR+ QUIET+
Which task is performed?
A. Runs the job named PERSONNEL, places the process report output in a file named PER.TXT, and displays prompts and error dialogs during the process.
B. Schedules a job named PERSONNEL, stores the extracted data in a file named PER.TXT, and displays information dialogs during the process.
C. Runs the job named PERSONNEL, places the process report output in a file named PER.TXT, and displays information dialogs during the process.
D. Schedules the job named PERSONNEL, stores the extracted data in a file named PER.TXT, and displays prompts and error dialogs during the process.
Answer: C
6. You have installed the Optim Server on an AIX system. The system is configured with various internal and external storage options attached to the server. Where should the Optim Temporary Work folder be placed?
A. the attached archive appliance
B. the attached NAS device
C. the system’s internal disk drives
D. the attached SAN device
Answer: C
7. An Archive File Collection is a list of Archive Files that are treated as a single data source by Open Data Manager (ODM). Which two statements are true regarding Archive Collections? (Choose two.)
A. Use the Collections tab on the Archive Request Editor to specify the collection(s) in which the Archive File should be added automatically.
B. An Archive File may belong to multiple Archive Collections, and an Archive Collection may contain multiple Archive Files.
C. Archive Files contained within a collection do not need to be registered in the Archive Directory.
D. ODM, by default, processes the Archive Files in the collections in ascending date order based on the dates the Archive Files were created.
E. An Archive File containing multiple tables with the same names and creator ids, but with different DB Aliases, may be stored in an Archive Collection.
Answer: AB
8. 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
9. Click the Exhibit button.
Given this information from the Relationships tab of an Access Definition, and the information from this Show Steps report in the exhibit, why is the STATE_LOOKUP table listed as UNTRAVERSED?
A. There is no active relationship for the STATE_LOOKUP table.
B. Q2 needs to be activated between SALES and STATE_LOOKUP.
C. Q1 needs to be de-activated between SALES and STATE_LOOKUP.
D. The relationship between SALES and STATE_LOOKUP is unselected.
Answer: B
10. One Optim report provides detailed performance information about your Archive, Extract and Delete processes, including basic table and selection criteria information as defined in the Access Definition, the number of key values used to retrieve rows, and DBMS Access statistical information. This report is essential for tuning your Optim processes. What is the name of this report and where do you indicate that Optim produce the report?
A. Process Report; selected for creation on the Archive or Extract Process Request.
B. Show Steps Report; provided on Access Definition Editor.
C. Statistical Report; selected for creation on the Archive or Extract Process Request.
D. File Access Definition Report; selected for use on the Archive Process Request.
Answer: C
11. Which performance enhancement do multiple database connections provide when used during an extract or archive?
A. Multiple database connections allow you to extract/archive rows from multiple tables simultaneously.
B. Multiple database connections allow you to extract/archive rows from a single table concurrently.
C. Multiple database connections allow you to extract/archive rows only from Reference Tables simultaneously.
D. Multiple database connections cannot be used during extract or archive, only during delete.
Answer: B
12. What are three valid levels of Optim Security? (Choose three.)
A. Database Security
B. Object Security
C. Functional Security
D. Network Security
E. Archive File Security
Answer: BCE
13. In Attunity, where is the metadata stored?
A. On the server where IRPCD is running.
B. In XML files where it can be manually updated.
C. In the Optim Directory where the DB Alias is found.
D. On the client where Attunity Studio is running.
Answer: A
14. When performing an archive process that uses a Storage Profile, which action could be performed as a result of using the storage profile?
A. Creates a connection to the database for use by the storage management device.
B. Creates a connection to the storage management device and copies an Archive File to a backup device.
C. Creates a storage allocation parameter for the storage or file management system.
D. Creates a duplicate of the existing information from the Archive Repository on the storage management device.
Answer: B
15. When using InfoSphere Federation Server to access Optim extended data sources, what must be created to define a federated object?
A. a wrapper, a system definition, a user mapping, and a nickname
B. a wrapper, a server definition, a user mapping, and a DB Alias
C. a wrapper, a system definition, a nickname, and a DB Alias
D. a wrapper, a server definition, a user mapping, and a nickname
Answer: D
000-551 Practice exam Description
Credit Toward CertificationWhen you pass Practice exam 000-551: IBM Certified Specialist – IBM Optim Implementation for Dist, you complete the requirements for the following certification(s):
IBM Certified Technical Specialist: IBM Certified Specialist – IBM Optim Implementation for Dist Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of IBM.IBM exam might include adaptive testing technology and simulation items.IBM does not identify the format in which exam are presented. Please use this preparation guide to prepare for the exam, regardless of its format.
We have examsoon 000-551 practice exam,examsoon 000-551 exam,examsoon 000-551 study guide,examsoon 000-551 dumps.and Pass4sure 000-551 exam,Pass4sure 000-551 practice exam,pass4sure 000-551 study guide. and we have Testking 000-551 exam,Testking 000-551 study guide,examsoon 000-551 exam.etc.
Examsoon professional IT Q&As vendors, offer well after-sale service for 000-551 exam. To all the customers buy the real 000-551 exam questions and answers, examsoon provide track service for 000-551 study guides. when you buy the Q&As with in 3 months. you can enjoy the upgrade Q&As service for free with 000-551 practice exam. If in this period, the certified test center change the Certified Specialist 000-551 Exam Q&As, we will update the Certified Specialist 000-551 exam Q&As in the first time, and provide you the download update for free
