Vendor: IBM
Exam Code: P2090-026
Exam Name: IBM Information Management DB2 10 pureScale Mastery Test v2
QUESTION 1
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 2
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 3
Which of the following is NOT a reason for a database administrator to place a DB2 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 4
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?
A. 0
B. 1
C. 2
D. 3
Answer: B
QUESTION 5
Which of the following statements is INCORRECT regarding backup operations in a DB2 pureScale environment?
A. Only one backup image is produced for the entire cluster.
B. Issuing a single backup/restore database command on any member initiates a backup or restore operation on behalf of all members.
C. Database metadata and transaction logs from the members are not included in the backup image.
D. A backup operation can be performed even if one member is inconsistent.
Answer: C
If you want to pass IBM P2090-026 successfully, donot missing to read latest lead2pass IBM P2090-026 dumps.
If you can master all lead2pass questions you will able to pass 100% guaranteed.