IBM P2090-054 dumps - 100% Pass Guarantee!

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.

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

Consider the scenario where the primary cluster caching facility failed while the secondary cluster caching facility was in CATCHUP state. Which of the following outcomes is CORRECT?

A. The DB2 pureScale cluster would freeze. A database administrator must restore the database from a previous backup and then roll forward the database to a point in time before the freeze.

B. DB2 cluster services will initiate a group restart with the former secondary cluster caching facility becoming the primary CF for the cluster. The instance will be temporarily unavailable while the services restart automatically

C. The instance would be brought down. DB2 cluster services then restarts only the secondary cluster caching facility now in the primary role.

D. The takeover operation succeeds and the secondary cluster caching facility will be promoted to primary. The cluster would continue processing incoming read-only transactions.

Which one of the following options is CORRECT about Temporal Tables?

A. System-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.

B. Application-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.

C. System-period temporal tables combine the historical tracking of an Application-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.

D. Application-period temporal tables combine the historical tracking of a system-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.

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.