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.
How does DB2 pureScale balance the workload among its members?
A. Workload balance must be handled by the application.
B. Workload balance is automatically performed by DB2 pureScale by rerouting the workload to members with lighter loads.
C. Workload balance is handled by the Self Tuning Memory Manager (STMM) feature.
D. Workload balance cannot be handled by DB2 pureScale. It must be handled by a third- party application.
A database administrator executed a db2iupdt command in order to drop a cluster caching facility from a DB2 pureScale cluster. Which command can be used to verify that the cluster caching facility is no longer part of the cluster?
A. db2instance -display -cluster -modifications
B. db2instance -list -cfs -details
C. db2instance -all -cfs
D. db2instance -list
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.
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.
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.
The following are true about the Configuration Advisor, EXCEPT:
A. It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.
B. It creates database objects such as indexes and MQTs to improve performance.
C. By default, the Configuration Advisor is automatically executed when you create a new database.
D. To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.
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?
A. In both DB2 pureScale and HADR environments data is available all the time.
B. DB2 pureScale transfers log files from a primary database to a standby database.
C. HADR persists data in the cluster caching facilities (CFs).
D. In a pureScale environment, the data is available all the time, while in a HADR environment the data is available most of the time.
Which one of the following options is correct about the differences between the IMPORT and INGEST utilities?
A. The IMPORT utility is now deprecated and INGEST is the recommended alternative.
B. The IMPORT utility can perform lightweight transformations on the data being processed. The INGEST utility cannot transform data.
C. The INGEST is capable of transforming and streaming data from files and pipes at high speeds into DB2 tables. The IMPORT utility cannot transform the data.
D. The IMPORT utility can import data into a database, while the INGEST can only create database objects based on a script file.
