Which of the following memory heaps is NOT configurable on the cluster caching facility?

A. Shared Communication Area (SCA) Memory.

B. Lock Memory.

C. Local Buffer Pool Memory.

D. Group Buffer Pool Memory.

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.

A database administrator retrieved the following status from the DB2 members in a DB2 pureScale environment: Which of the following options will start ONLY the member hosted in NODE102?

A. db2start member on NODE102

B. db2start NODE102

C. db2start member 1

D. db2cluster -node node102 -exit - maintenance

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.

What are some of the benefits of DB2 Express?

A. DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.

B. DB2 Express is designed for development and testing. It is not used as a production database.

C. DB2 Express is fastest and most powerful DB2 edition.

D. DB2 Express is a tool that allows DBAs to quickly solve complex database issues.

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.

How can you verify that a DB2 installation was successful?

A. Verification is performed by running the VERIFY INSTALL command.

B. Verification is completed by the DBA using the database verification toolkit.

C. Verification is automatically performed by the AUTO_CONFIGURE feature.

D. Verification can be done by successfully creating a SAMPLE database and running SQL commands to retrieve sample data.

Which one of the following statements is TRUE about DB2 Workload Management (WLM)?

A. DB2 Workload Management requires several application changes in order to make the application aware of the WLM feature.

B. DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server.

C. DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs, REORGs, or RUSTATS.

D. DB2 Workload Management allows you to assign resources to different workloads, which leads to a stable and predictable execution environment.

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.