[Free] 2018(Jan) EnsurePass Testinsides IBM P2090-054 Dumps with VCE and PDF 21-30

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: 21

Which one of the following options is correct about DB2 pureScale installation?

  1. A single setup image is required for installing both members and cluster caching facilities. The DB2 pureScale Setup Wizard must be invoked on each host to install all of the components of the DB2 pureScale feature.

  2. Different setup images are required for for installing both members and cluster caching facilities. An invocation of the Setup Wizard is required to install all of the DB2 Members of the DB2 pureScale feature. Another invocation of the Setup Wizard is required to install all of the Cluster Caching Facilities.

  3. A single setup image is required for installing both members and cluster caching facilities. A single invocation of the Setup Wizard from the installation-initiating host installs all of the components of the DB2 pureScale feature across all hosts that you specify as part of the DB2 pureScale environment.

  4. Different setup images are required for installing both members and cluster caching facilities. The DB2 pureScale Setup Wizard must be invoked on each host to install all of the components of the DB2 pureScale feature.

Answer: C

Question No: 22

Which of the following statements is FALSE about DB2 pureScale?

  1. DB2 pureScale provides near-linear scalability.

  2. DB2 pureScale requires application changes to scale out.

  3. DB2 pureScale provides 24 X 7 availability and it can recover itself from a crash.

  4. DB2 pureScale is able to handle key capacity spikes with pay by the day pricing.

Answer: B

Question No: 23

How are client connections handled in a standard DB2 pureScale environment?

  1. Connections must be directed to the primary cluster caching facility in the system.

  2. Connections must be directed to the shared storage.

  3. Connections must be directed to all members in the system, so that all members stay in sync.

  4. Connections can be directed to any of the members in the system.

Answer: D

Question No: 24

Which of the following is NOT valid state for the Cluster Caching Facility?

  1. ONLINE

  2. PRIMARY

  3. ERROR

  4. PEER

Answer: A

Question No: 25

Which one of the following options describes a benefit of Geographically Dispersed pureScale Cluster (GDPC)?

  1. GDPC allows the placement of redundant cluster caching facilities at different locations. The pureScale members must be at the same physical location.

  2. GDPC provides independent transaction processing, which means that on normal operations, each cluster caching facility is at a different location processing the transactions from the members on its respective location.

  3. GDPC provides active / active system availability, which means that during normal operations, the pureScale members at both locations are retrieving data from their local host discs, maintaining an optimal level of activity on all members, both within and between locations.

  4. GDPC provides active / active system availability, which means that during normal operations, the pureScale members at both locations are sharing the workload between them as usual, maintaining an optimal level of activity on all members, both within and between locations.

Answer: D

Question No: 26

Each DB2 member in a DB2 pureScale environment has an associated database log.

Where is this log stored?

  1. Locally on each member.

  2. Tie-breaker disk.

  3. Cluster caching facility.

  4. Shared storage.

Answer: D

Question No: 27

Which of the following statements describes the STMM (Self-Tuning Memory Manager) functionality in a DB2 pureScale environment?

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

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

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

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

Answer: D

Question No: 28

Which one of the following options is INCORRECT about DB2 pureScale?

  1. DB2 10 pureScale introduced support for range-partitioned tables. Attach/detach operations are limited to the first and last partitions only.

  2. DB2 10 pureScale introduced support for split mirror technology as a backup method.

  3. DB2 10 pureScale is able to leverage DB2#39;s Workload Manager.

  4. DB2 10 pureScale introduced support for partitioned indexes and partition reorgs.

Answer: A

Question No: 29

Where is data stored in a typical DB2 pureScale environment?

  1. All members hold a local data partition of the database.

  2. Data is split among both, members and a shared storage.

  3. In a shared storage accessible by all members.

  4. Data is permanently stored in the cluster caching facility.

Answer: C

Question No: 30

A database administrator retrieved the following status from the DB2 members in a DB2 pureScale environment:

Ensurepass 2018 PDF and VCE

Which of the following options will start ONLY the member hosted in NODE102?

  1. db2start member on NODE102

  2. db2start NODE102

  3. db2start member 1

  4. db2cluster -node node102 -exit – maintenance

Answer: C

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.