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 instance would be brought down. DB2 cluster services then restarts only the secondary cluster caching facility now in the primary role.
B. The takeover operation succeeds and the secondary cluster caching facility will be promoted to primary. The cluster would continue processing incoming read-only transactions.
C. 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
D. 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.
正解:C
質問 2:
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 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.
B. 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.
C. 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.
D. 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.
正解:C
質問 3:
Which one of the following options is FALSE about DB2's Multi-Temperature Data Storage capability?
A. Multi-temperature data management best practices recommend that cold data should be stored in faster devices in order to maximize overall system performance.
B. Multi-temperature data management reduces the total cost of ownership by allowing efficient deployment of storage hardware with minimal administrative overhead.
C. You can use storage groups to implement multi-temperature data management in DB2.
D. Multi-temperature data management integrates with DB2's Workload Manager feature to let you prioritize your workloads based on the data being accessed.
正解:A
質問 4:
What is a buffer pool in DB2?
A. A buffer pool is a DB2 component that manages connections to databases.
B. A buffer pool is a pool of connection buffers that increases performance of applications connecting to the DB2 server.
C. A buffer pool 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.
D. A buffer pool is a logical storage grouping composed of one or more containers.
正解:C
質問 5:
Which of the following is NOT valid state for the Cluster Caching Facility?
A. PRIMARY
B. PEER
C. ONLINE
D. ERROR
正解:C
質問 6:
Which of the following options is correct about possible configurations for DB2 pureScale's network topology?
A. DB2 pureScale does not support multiple cluster interconnect adapter ports, but It supports multiple switches, which greatly improves network resiliency.
B. DB2 pureScale supports multiple cluster interconnect adapter ports for the cluster caching facilities which increases the bandwidth to handle more requests, thus improving performance. It also supports multiple switches, which greatly improves network resiliency.
C. DB2 pureScale supports multiple cluster interconnect adapter ports for the cluster members which increases the bandwidth to process more transactions, thus improving performance. It also supports multiple switches, which greatly improves network resiliency.
D. DB2 pureScale supports multiple cluster interconnect adapter ports for both cluster caching facilities and members. It does not support multiple switches.
正解:B
質問 7:
Which of the following options best defines the Label-Based Access Control (LBAC) feature?
A. DB2 LBAC monitors table data access and tables modifications made by database users.
B. DB2 LBAC lets you decide exactly who has write/read access to individual rows and columns by comparing the security labels between database objects and users.
C. DB2 LBAC allows you to use labels to reference database objects by a short name instead of the full qualified name.
D. DB2 LBAC is the DB2 authority in charge of issuing GRANT and REVOKE statements.
正解:B
Ishii -
これを使って不合格になるわけがないよP2090-054正解だけでなく,間違い選択肢についても確認できる,詳細な解説だお気に入りです。