최신IBM Information Management DB2 10.5 pureScale Technical Mastery Test v3 - P2090-054무료샘플문제

A. DB2 10 pureScale introduced support for partitioned indexes and partition reorgs.

B. DB2 10 pureScale introduced support for range-partitioned tables. Attach/detach operations are limited to the first and last partitions only.

C. DB2 10 pureScale introduced support for split mirror technology as a backup method.

D. DB2 10 pureScale is able to leverage DB2's Workload Manager.

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

B. Verification is automatically performed by the AUTO_CONFIGURE feature.

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

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

A. This component is used to keep page caching consistent across all members through a shared group buffer pool.

B. This component provides a global buffer pool.

C. This component is used to balance the workload through a global workload resource pool.

D. This component is used to coordinate locking through a global lock manager to prevent conflicting access to the same table data by different members.

A. primary: SYNC secondary: SYNC

B. primary: PEER secondary: CATCHUP

C. primary: PRIMARY secondary: SECONDARY

D. primary: PRIMARY secondary: PEER

A. A table space is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as it is read from the physical media.

B. A table space is a DB2 component that manages access to databases.

C. A table space is a logical storage grouping that can be composed of one or more containers.

D. A table space is a space reserved for catalog tables and base table data.

A. 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.

B. 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.

C. 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.

D. 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.

A. Automatic storage allows automatic allocation of free space in memory for optimizing query execution.

B. Automatic storage simplifies storage management by allowing you to specify storage paths where the database manager can place table space data.

C. Automatic storage is an option which is set when you create a DB2 database. It allows transactions that are executed to be automatically committed.

D. Automatic storage is a function of DB2 that allows tables to be backed up automatically on a set schedule.