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.
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?
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.
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.
Which of the following options describes correct cluster caching facility states when both primary and secondary cluster caching facilities are in sync?
A. primary: PRIMARY secondary: SECONDARY
B. primary: SYNC secondary: SYNC
C. primary: PRIMARY secondary: PEER
D. primary: PEER secondary: CATCHUP
How does DB2 pureScale handle member(s) failover scenarios?
A. All data remains locked until the failover operation is completed.
B. Future connections are evenly distributed among the surviving members of the cluster.
C. Current connections to the failed member will be on hold until the member recovers and is back online.
D. DB2 pureScale requires database administrator intervention to handle failover scenarios.
Consider the scenario that a technical expert accidentally trips over the power cord of a DB2 pureScale cluster node, bringing the node offline. Assume the cluster contains a SECONDARY cluster caching facility and other DB2 members. What will be the outcome of this situation if the node was hosting both the PRIMARY cluster caching facility and a DB2 member?
A. The secondary cluster caching facility will become the primary. All client transactions sent to be processed by the offline server will be re-routed to the remaining members within the cluster.
B. DB2 pureScale cannot host both the cluster caching facility and a member on a single host.
C. The cluster will put all transactions on hold until the server is back online.
D. The secondary cluster caching facility will be in SYNC state. All client connections will be terminated and will need to re-issued by the client.
In a DB2 pureScale environment, which of the following statements is NOT a characteristic of the cluster caching facility?
A. This component is used to balance the workload through a global workload resource pool.
B. This component is used to coordinate locking through a global lock manager to prevent conflicting access to the same table data by different members.
C. This component is used to keep page caching consistent across all members through a shared group buffer pool.
D. This component provides a global buffer pool.
Consider the scenario of a DB2 pureScale environment with two DB2 members, and assume there is an active connection to "member 3". Due to some maintenance emergency, "member 3" needs to be stopped. Which one of the following commands will stop "member 3"?
A. db2stop force member 3
B. db2stop immediate member 3
C. db2stop node 3 all members
D. db2stop member 3
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your P2090-054 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.