[Free] 2018(Jan) EnsurePass Dumpsleader IBM P2090-054 Dumps with VCE and PDF 1-10

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released P2090-054
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/P2090-054.html

IBM Information Management DB2 10 pureScale Technical Mastery Test v3

Question No: 1

Consider the scenario of a DB2 pureScale environment with two DB2 members, and assume there is an active connection to quot;member 3quot;. Due to some maintenance emergency, quot;member 3quot; needs to be stopped. Which one of the following commands will stop quot;member 3quot;?

  1. db2stop force member 3

  2. db2stop immediate member 3

  3. db2stop node 3 all members

  4. db2stop member 3

Answer: A

Question No: 2

In a DB2 pureScale environment, which of the following statements is NOT a characteristic of the cluster caching facility?

  1. This component is used to balance the workload through a global workload resource pool.

  2. This component is used to coordinate locking through a global lock manager to prevent conflicting access to the same table data by different members.

  3. This component is used to keep page caching consistent across all members through a shared group buffer pool.

  4. This component provides a global buffer pool.

Answer: A

Question No: 3

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

  1. primary: PRIMARY secondary: SECONDARY

  2. primary: SYNC secondary: SYNC

  3. primary: PRIMARY

    secondary: PEER

  4. primary: PEER secondary: CATCHUP

Answer: C

Question No: 4

How does DB2 pureScale handle member(s) failover scenarios?

  1. All data remains locked until the failover operation is completed.

  2. Future connections are evenly distributed among the surviving members of the cluster.

  3. Current connections to the failed member will be on hold until the member recovers and is back online.

  4. DB2 pureScale requires database administrator intervention to handle failover scenarios.

Answer: B

Question No: 5

Consider the scenario that a technical expert accidentally trips over the power cord of a DB2 pureScale cluster node, bringing the node offline. Assume the cluster contains a SECONDARY cluster caching facility and other DB2 members. What will be the outcome of this situation if the node was hosting both the PRIMARY cluster caching facility and a DB2 member?

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

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

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

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

Answer: A

Question No: 6

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?

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

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

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

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

Answer: D

Question No: 7

Which of the following memory heaps is NOT configurable on the cluster caching facility?

  1. Shared Communication Area (SCA) Memory.

  2. Lock Memory.

  3. Local Buffer Pool Memory.

  4. Group Buffer Pool Memory.

Answer: C

Question No: 8

How does DB2 pureScale balance the workload among its members?

  1. Workload balance must be handled by the application.

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

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

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

Answer: B

Question No: 9

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

  1. To update the DB2 Cluster Services software.

  2. To be able to perform software and hardware updates on both cluster caching facilities (primary and secondary) at the same time.

  3. When moving a server to a different location and requiring to disconnect it from the cluster.

  4. To ensure that the system does not reboot when installing new software on the system.

Answer: B

Question No: 10

A DB2 pureScale environment has fourteen DB2 members and one cluster caching facility. Having each of the members and cluster caching facility hosted on a separate physical machine, what is the recommended number of redundant cluster caching facilities necessary so that the DB2 pureScale environment could be available if the primary cluster caching facility fails?

  1. 0

  2. 1

  3. 2

  4. 3

Answer: B

100% Ensurepass Free Download!
Download Free Demo:P2090-054 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-054 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

This entry was posted in P2090-054 Latest Exam (Jan 2018) and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.