IBM Information Management DB2 10.5 pureScale Technical Mastery Test v3 問題集 : P2090-054

Which of the following options does NOT describe a benefit of DB2's Row Compression?

• A. Compression allows you to retrieve the same amount of data using fewer disk operations (I/O).
• B. Compression allows you to store the same amount of data in less space, which can significantly save storage costs.
• C. Compression allows you to cache more data in the buffer pools using the same amount of space.
• D. Compression allows you to reduce CPU workload because there is less data to process.

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

Which one of the following options is FALSE about DB2's Multi-Temperature Data Storage capability?

• A. Multi-temperature data management reduces the total cost of ownership by allowing efficient deployment of storage hardware with minimal administrative overhead.
• B. You can use storage groups to implement multi-temperature data management in DB2.
• C. Multi-temperature data management best practices recommend that cold data should be stored in faster devices in order to maximize overall system performance.
• D. Multi-temperature data management integrates with DB2's Workload Manager feature to let you prioritize your workloads based on the data being accessed.

Consider the scenario where a database administrator (DBA) would like to apply operating system updates on the host machine that contains one of the DB2 pureScale members. The primary cluster caching facility and other members are located on different physical machines. Which of the following tasks should be performed by the DBA on the host machine before applying the operating system updates, so that the member will not be restarted?

• A. Place the host machine into maintenance mode.
• B. Place the member into quiesce mode.
• C. Place the cluster caching facility in standby mode.
• D. Place the member into maintenance mode.

Consider the scenario where a database administrator is required to restore a database backup for a DB2 pureScale environment. Which of the following statements is correct?

• A. The RESTORE DATABASE command will need to be executed on only one of the members within the cluster. This operation will restore both the database and metadata for all members.
• B. The RESTORE DATABASE command will need to be executed on each DB2 caching facility within the cluster to restore just the database. All node metadata is not recoverable since it is not stored within database backups.
• C. The RESTORE DATABASE command will need to be executed on the shared storage to restore the database. The metadata cannot be retrieved until the shared storage is restarted.
• D. The RESTORE DATABASE command will need to be executed on each DB2 member within the cluster to restore just the database. A separate command will be required to restore the metadata for each member.