IBM P2090-054 Certification Exam Material - Free Download and Guaranteed Pass

IBM P2090-054 Certification Exam Material - Free Download and Guaranteed Pass



Exam code : P2090-054
Exam name : IBM Information Management DB2 10 pureScale Technical Mastery Test v3

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
Answer: A
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.
Answer: A
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
Answer: C
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.
Answer: B
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.
Answer: A
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.
Answer: D
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