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.

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.

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 of the following questions is FALSE about DB2 Audit facility?

A. The DB2 Audit facility helps monitor data access to protect against unknown or unwanted behavior.

B. The DB2 Audit facility logs configuration changes made by STMM.

C. The DB2 Audit facility helps you comply with business regulation or legal rules requiring companies to keep historical records of database activities.

D. The DB2 Audit facility allows you to export audit data into a table format for easy reporting.

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.