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 INCORRECT about DB2 pureScale?
A. DB2 10 pureScale introduced support for range-partitioned tables. Attach/detach operations are limited to the first and last partitions only.
B. DB2 10 pureScale introduced support for split mirror technology as a backup method.
C. DB2 10 pureScale is able to leverage DB2's Workload Manager.
D. DB2 10 pureScale introduced support for partitioned indexes and partition reorgs.
Which one of the following options describes a benefit of Geographically Dispersed pureScale Cluster (GDPC)?
A. GDPC allows the placement of redundant cluster caching facilities at different locations. The pureScale members must be at the same physical location.
B. GDPC provides independent transaction processing, which means that on normal operations, each cluster caching facility is at a different location processing the transactions from the members on its respective location.
C. GDPC provides active / active system availability, which means that during normal operations, the pureScale members at both locations are retrieving data from their local host discs, maintaining an optimal level of activity on all members, both within and between locations.
D. GDPC provides active / active system availability, which means that during normal operations, the pureScale members at both locations are sharing the workload between them as usual, maintaining an optimal level of activity on all members, both within and between locations.
Each DB2 member in a DB2 pureScale environment has an associated database log. Where is this log stored?
A. Locally on each member.
B. Tie-breaker disk.
C. Cluster caching facility.
D. Shared storage.
Which of the following statements describes the STMM (Self-Tuning Memory Manager) functionality in a DB2 pureScale environment?
A. When Self-Tuning Memory Manager is enabled in a DB2 pureScale environment, the primary cluster caching facility monitors the memory configuration and propagates any configuration changes to all members.
B. When Self-Tuning Memory Manager is enabled in a DB2 pureScale environment, the secondary cluster caching facility monitors the memory configuration and propagates any configuration changes to all members.
C. When Self-Tuning Memory Manager is enabled in a DB2 pureScale environment, if the member on which the memory manager is running deactivates, the memory manager will remain off until the member is activated. In order for a member to run the memory manager, the database must be active on that member and that member must have SELF_TUNING_MEM set to ON
D. When Self-Tuning Memory Manager is enabled in a DB2 pureScale environment, if the member on which the memory manager is running deactivates, the memory manager will automatically start up on another member that is currently able to run the memory manager. In order for a member to run the memory manager, the database must be active on that member and that member must have SELF_TUNING_MEM set to ON.
Which of the following is NOT valid state for the Cluster Caching Facility?
A. ONLINE
B. PRIMARY
C. ERROR
D. PEER
Which one of the following options is correct about DB2 pureScale installation?
A. A single setup image is required for installing both members and cluster caching facilities. The DB2 pureScale Setup Wizard must be invoked on each host to install all of the components of the DB2 pureScale feature.
B. Different setup images are required for for installing both members and cluster caching facilities. An invocation of the Setup Wizard is required to install all of the DB2 Members of the DB2 pureScale feature. Another invocation of the Setup Wizard is required to install all of the Cluster Caching Facilities.
C. A single setup image is required for installing both members and cluster caching facilities. A single invocation of the Setup Wizard from the installation-initiating host installs all of the components of the DB2 pureScale feature across all hosts that you specify as part of the DB2 pureScale environment.
D. Different setup images are required for installing both members and cluster caching facilities. The DB2 pureScale Setup Wizard must be invoked on each host to install all of the components of the DB2 pureScale feature.
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.
How are client connections handled in a standard DB2 pureScale environment?
A. Connections must be directed to the primary cluster caching facility in the system.
B. Connections must be directed to the shared storage.
C. Connections must be directed to all members in the system, so that all members stay in sync.
D. Connections can be directed to any of the members in the system.
Consider the scenario where a client application is connected to DB2 pureScale "member 1". The DB2 pureScale environment has three DB2 pureScale members. In a situation where "member 1" fails, the client is still able to execute operations against the DB2 pureScale cluster with minimal interference. Which of the following technologies allow the client to continue performing operations?
A. Decentralized log files for member recovery.
B. Geographically Dispersed pureScale Cluster (GDPC).
C. Automatic Client Reroute.
D. Redundant cluster caching facility.
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.