IBM P2090-054 - IBM Information Management DB2 10 pureScale Technical Mastery Test v3 Exam
Page: 2 / 14
Total 69 questions
Question #6 (Topic: )
Consider the scenario where a database administrator is required to restore a database
backup for a DB2 pureScale environment. Which of the following statements is correct?
backup for a DB2 pureScale environment. Which of the following statements is correct?
A. The RESTORE DATABASE command will need to be executed on each DB2 member within the cluster to restore just the database. A separate command will be required to restore the metadata for each member.
B. The RESTORE DATABASE command will need to be executed on the shared storage to restore the database. The metadata cannot be retrieved until the shared storage is restarted.
C. The RESTORE DATABASE command will need to be executed on each DB2 caching facility within the cluster to restore just the database. All node metadata is not recoverable since it is not stored within database backups.
D. The RESTORE DATABASE command will need to be executed on only one of the members within the cluster. This operation will restore both the database and metadata for all members.
Answer: D
Question #7 (Topic: )
Which of the following memory heaps is NOT configurable on the cluster caching facility?
A. Shared Communication Area (SCA) Memory.
B. Lock Memory.
C. Local Buffer Pool Memory.
D. Group Buffer Pool Memory.
Answer: C
Question #8 (Topic: )
How does DB2 pureScale balance the workload among its members?
A. Workload balance must be handled by the application.
B. Workload balance is automatically performed by DB2 pureScale by rerouting the workload to members with lighter loads.
C. Workload balance is handled by the Self Tuning Memory Manager (STMM) feature.
D. Workload balance cannot be handled by DB2 pureScale. It must be handled by a third- party application.
Answer: B
Question #9 (Topic: )
Which of the following is NOT a reason for a database administrator to place a DB2
pureScale node into maintenance mode?
pureScale node into maintenance mode?
A. To update the DB2 Cluster Services software.
B. To be able to perform software and hardware updates on both cluster caching facilities (primary and secondary) at the same time.
C. When moving a server to a different location and requiring to disconnect it from the cluster.
D. To ensure that the system does not reboot when installing new software on the system.
Answer: B
Question #10 (Topic: )
A DB2 pureScale environment has fourteen DB2 members and one cluster caching facility.
Having each of the members and cluster caching facility hosted on a separate physical
machine, what is the recommended number of redundant cluster caching facilities
necessary so that the DB2 pureScale environment could be available if the primary cluster
caching facility fails?
Having each of the members and cluster caching facility hosted on a separate physical
machine, what is the recommended number of redundant cluster caching facilities
necessary so that the DB2 pureScale environment could be available if the primary cluster
caching facility fails?
A. 0
B. 1
C. 2
D. 3
Answer: B
