IBM Information Management DB2 10.5 pureScale Technical Mastery Test v3 認定 P2090-054 試験問題:

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

2. Which of the following options describes correct cluster caching facility states when both primary and secondary cluster caching facilities are in sync?

A) primary: PRIMARY secondary: SECONDARY
B) primary: SYNC secondary: SYNC
C) primary: PEER secondary: CATCHUP
D) primary: PRIMARY secondary: PEER

3. What does the table partitioning feature in DB2 allow you to do?

A) Table partitioning allows you to create result set tables from a join query, which automatically splits the data into smaller chunks, thereby increasing the performance of your DB2 database.
B) Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing the performance of your DB2 database.
C) Table partitioning allows you to partition the table data based on the hash values of the primary key.
D) Table partitioning allows you to create very large tables that are divided across multiple storage objects so that you can quickly attach and detach large quantities of data from the tables.

4. Which of the following is NOT a reason for a database administrator to place a DB2 pureScale node into maintenance mode?

A) To be able to perform software and hardware updates on both cluster caching facilities (primary and secondary) at the same time.
B) When moving a server to a different location and requiring to disconnect it from the cluster.
C) To update the DB2 Cluster Services software.
D) To ensure that the system does not reboot when installing new software on the system.

5. 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 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.
B) 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.
C) 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.
D) 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.

質問と回答：