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.

What is the purpose of the tiebreaker disk in a DB2 pureScale environment?

A. Tiebreaker is used to determine which half of the DB2 pureScale instance should remain online upon a communication failure.

B. Tiebreaker is used to determine which clients are accessing the data on the storage.

C. Tiebreaker is used to determine which databases are currently active and can be accessed by the clients directly in graphical user interface (GUI).

D. Tiebreaker is used by DB2 to transfer data when packets collide.

Which of the following statements is FALSE about DB2 pureScale?

A. DB2 pureScale provides near-linear scalability.

B. DB2 pureScale requires application changes to scale out.

C. DB2 pureScale provides 24 X 7 availability and it can recover itself from a crash.

D. DB2 pureScale is able to handle key capacity spikes with pay by the day pricing.

Consider the scenario where a server "pscale1" hosts a DB2 member and one cluster caching facility. In a situation where a database administrator wants to perform an operating system update on "pscale1", which one of the following options will ensure that both the member and cluster caching facility won't be automatically restarted by DB2 cluster services while the system is upgraded?

A. Log in to any of the hosts as a root user. Stop the member and cluster caching facility. Remove the member and cluster caching facility from the cluster.

B. Log in to any of the hosts as root user. Bring the member on "pscale1" to quiesce mode. Bring the member on "pscale1" to maintenance mode. Bring cluster caching facility on "pscale1" to maintenance mode.

C. Log in to "pscale1" as a DB2 instance user. Bring the member on "pscale1" to quiesce mode and stop the cluster caching facility. Stop the instance on "pscale1". Log in as DB2 cluster services administrator. Bring "pscale1" host to maintenance mode.

D. Log in as a cluster services administrator. Bring the member on "pscale1" to quiesce mode and stop the cluster caching facility. Bring the member on "pscale1" to maintenance mode. Bring cluster caching facility on "pscale1" to maintenance mode.

Which one of the following options is CORRECT about DB2 pureScale feature?

A. DB2 pureScale is only available for DB2 Express-C and DB2 Advanced Enterprise Edition.

B. DB2 pureScale uses the same concept of HADR where the data is replicated from a primary database to a standby database.

C. DB2 pureScale persists data in the cluster caching facilities (CFs).

D. DB2 pureScale reduces the risk and cost associated with growing your distributed database solution by providing extreme capacity and application transparency.