Consider the scenario of a DB2 pureScale environment with two DB2 members, and assume there is an active connection to "member 3". Due to some maintenance emergency, "member 3" needs to be stopped. Which one of the following commands will stop "member 3"?
A. db2stop immediate member 3
B. db2stop member 3
C. db2stop node 3 all members
D. db2stop force member 3
正解:D
質問 2:
Which one of the following options is TRUE about High Availability and Disaster Recovery (HADR) feature?
A. HADR allows up to four HADR standby databases.
B. HADR allows up to five HADR standby databases.
C. HADR allows up to three HADR standby databases.
D. HADR allows up to two HADR standby databases.
正解:C
質問 3:
Which of the following options does NOT describe a benefit of DB2's Row Compression?
A. Compression allows you to reduce CPU workload because there is less data to process.
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 retrieve the same amount of data using fewer disk operations (I/O).
正解:A
質問 4:
How does automatic storage work in DB2?
A. Automatic storage allows automatic allocation of free space in memory for optimizing query execution.
B. Automatic storage is an option which is set when you create a DB2 database. It allows transactions that are executed to be automatically committed.
C. Automatic storage simplifies storage management by allowing you to specify storage paths where the database manager can place table space data.
D. Automatic storage is a function of DB2 that allows tables to be backed up automatically on a set schedule.
正解:C
質問 5:
Which one of the following options contains the minimum configuration for a DB2 pureScale cluster capable of recovering from a member failure?
A. 1 cluster caching facility and 2 DB2 members.
B. 1 cluster caching facility and 1 DB2 members.
C. 2 cluster caching facilities and 2 DB2 members.
D. 2 cluster caching facilities and 1 DB2 member.
正解:A
質問 6:
How does DB2 pureScale balance the workload among its members?
A. Workload balance cannot be handled by DB2 pureScale. It must be handled by a third-
party application.
B. Workload balance is automatically performed by DB2 pureScale by rerouting the workload to members with lighter loads.
C. Workload balance is handled by the Self Tuning Memory Manager (STMM) feature.
D. Workload balance must be handled by the application.
正解:B
質問 7:
A database administrator executed a db2iupdt command in order to drop a cluster caching facility from a DB2 pureScale cluster. Which command can be used to verify that the cluster caching facility is no longer part of the cluster?
A. db2instance -display -cluster -modifications
B. db2instance -list -cfs -details
C. db2instance -all -cfs
D. db2instance -list
正解:D
Morishita -
昨年度、問題で10点足りず不合格となってしまいました。
Pass4TestのP2090-054問題集を使って勉強し、合格することができました。
情報量とみやすさのバランスが完璧です。