最新的IBM Information Management DB2 10.5 pureScale Technical Mastery Test v3 - P2090-054免費考試真題

A. db2stop immediate member 3

B. db2stop force member 3

C. db2stop node 3 all members

D. db2stop member 3

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 a function of DB2 that allows tables to be backed up automatically on a set schedule.

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

A. Workload balance must be handled by the application.

B. Workload balance is handled by the Self Tuning Memory Manager (STMM) feature.

C. Workload balance cannot be handled by DB2 pureScale. It must be handled by a third-
party application.

D. Workload balance is automatically performed by DB2 pureScale by rerouting the workload to members with lighter loads.

A. Locally on each member.

B. Tie-breaker disk.

C. Shared storage.

D. Cluster caching facility.

A. DB2 pureScale cannot host both the cluster caching facility and a member on a single host.

B. The secondary cluster caching facility will be in SYNC state. All client connections will be terminated and will need to re-issued by the client.

C. The cluster will put all transactions on hold until the server is back online.

D. The secondary cluster caching facility will become the primary. All client transactions sent to be processed by the offline server will be re-routed to the remaining members within the cluster.

A. When Self-Tuning Memory Manager is enabled in a DB2 pureScale environment, if the member on which the memory manager is running deactivates, the memory manager will automatically start up on another member that is currently able to run the memory manager. In order for a member to run the memory manager, the database must be active on that member and that member must have SELF_TUNING_MEM set to ON.

B. When Self-Tuning Memory Manager is enabled in a DB2 pureScale environment, if the member on which the memory manager is running deactivates, the memory manager will remain off until the member is activated. In order for a member to run the memory manager, the database must be active on that member and that member must have SELF_TUNING_MEM set to ON

C. When Self-Tuning Memory Manager is enabled in a DB2 pureScale environment, the primary cluster caching facility monitors the memory configuration and propagates any configuration changes to all members.

D. When Self-Tuning Memory Manager is enabled in a DB2 pureScale environment, the secondary cluster caching facility monitors the memory configuration and propagates any configuration changes to all members.

A. HADR feature is only available for DB2 Advanced Enterprise Edition.

B. HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby.

C. HADR protects against data loss by replicating data changes from a backup database file to a standby database.

D. HADR protects against data loss by saving data changes from a source database into a local recovery log file.