[Free] 2018(Jan) Dumps4cert Testking IBM P2090-054 Dumps with VCE and PDF 11-20

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released P2090-054
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/P2090-054.html

IBM Information Management DB2 10 pureScale Technical Mastery Test v3

Question No: 11

Which of the following statements is INCORRECT regarding backup operations in a DB2 pureScale environment?

  1. Only one backup image is produced for the entire cluster.

  2. Issuing a single backup/restore database command on any member initiates a backup or restore operation on behalf of all members.

  3. Database metadata and transaction logs from the members are not included in the backup image.

  4. A backup operation can be performed even if one member is inconsistent.

Answer: C

Question No: 12

Which of the following statements is FALSE when monitoring the high usage of lock memory in a DB2 pureScale environment?

  1. Performance will not be affected due to high usage of Lock Memory.

  2. Data concurrency issues can arise due to a high number of lock escalations.

  3. Lock escalations can take place if there is insufficient memory.

  4. Request for locks might be denied.

Answer: A

Question No: 13

Consider the scenario where two members, quot;M1quot; and quot;M2quot;, intend to update two different rows on the same data page: 1.quot;M1quot; is doing an update on row R1 within a data page. It is granted exclusive access to the page containing that row of data. 2.quot;M2quot; requires an exclusive lock to the same page to update row R2. It passes this request to the cluster caching facility. quot;M2quot; waits while the request is processed. 3.The cluster caching facility sees that member quot;M1quot; already has an exclusive access to the page. It issues a request to quot;M1quot; for the page. In the meantime, quot;M2quot; waits. 4.quot;M1quot; processes the request by writing the page back to the global buffer pool and then releasing the page lock. (quot;M1quot; retains any row or table locks it might have had). 5.The cluster caching facility grants quot;M2quot; access to the page. quot;M2quot; reads the page from the global buffer pool to perform whatever operations for which the page is needed. Which of the following DB2 pureScale monitoring elements can be used to monitor the above scenario?

  1. Lock escalation.

  2. Lock contention.

  3. Log Retain.

  4. Page reclaiming.

Answer: D

Question No: 14

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?

  1. db2instance -display -cluster -modifications

  2. db2instance -list -cfs -details

  3. db2instance -all -cfs

  4. db2instance -list

Answer: D

Question No: 15

What is the purpose of the tiebreaker disk in a DB2 pureScale environment?

  1. Tiebreaker is used to determine which half of the DB2 pureScale instance should remain online upon a communication failure.

  2. Tiebreaker is used to determine which clients are accessing the data on the storage.

  3. Tiebreaker is used to determine which databases are currently active and can be accessed by the clients directly in graphical user interface (GUI).

  4. Tiebreaker is used by DB2 to transfer data when packets collide.

Answer: A

Question No: 16

Which of the following options justifies why you should be actively monitoring buffer pool hit ratios on your DB2 pureScale environment?

  1. Attaining high local buffer pool (LBP) and global buffer pool (GBP) hit ratios are in general an indication of overall good performance as more pages are found in memory than having to fetch from I/O.

  2. Attaining low local buffer pool (LBP) and global buffer pool (GBP) hit ratios are in

    general an indication of overall good performance as more pages are found in memory than having to fetch from I/O.

  3. High local buffer pool (LBP) hit ratios are the only important metric that must be monitored since it indicates that there are a higher number of pages fetched from physical storage than from the local buffer pool.

  4. Low local buffer pool (LBP) hit ratios are the only important metric that must be monitored since it indicates that there are a higher number pages fetched directly from physical storage than from the local buffer pool.

Answer: A

Question No: 17

Consider a scenario where a database administrator (DBA) requires an overview of the pureScale cluster database. After issuing a quot;db2instance -listquot; command, the DBA notices that one of the members is in WAITING_FOR_FAILBACK state. What does WAITING_FOR_FAILBACK mean in a pureScale environment?

  1. The member is waiting for a connection to be established with a failed Cluster Caching Facility.

  2. The member is waiting to failback to its home host.

  3. The member is waiting to failback to a remote host.

  4. The member is waiting to failback to the failed Cluster Caching Facility .

Answer: B

Question No: 18

Consider the scenario where a client application is connected to DB2 pureScale quot;member 1quot;. The DB2 pureScale environment has three DB2 pureScale members. In a situation where quot;member 1quot; fails, the client is still able to execute operations against the DB2 pureScale cluster with minimal interference. Which of the following technologies allow the client to continue performing operations?

  1. Decentralized log files for member recovery.

  2. Geographically Dispersed pureScale Cluster (GDPC).

  3. Automatic Client Reroute.

  4. Redundant cluster caching facility.

Answer: C

Question No: 19

Consider the scenario where a database administrator (DBA) would like to apply operating system updates on the host machine that contains one of the DB2 pureScale members.

The primary cluster caching facility and other members are located on different physical machines. Which of the following tasks should be performed by the DBA on the host machine before applying the operating system updates, so that the member will not be restarted?

  1. Place the member into maintenance mode.

  2. Place the host machine into maintenance mode.

  3. Place the member into quiesce mode.

  4. Place the cluster caching facility in standby mode.

Answer: B

Question No: 20

Which of the following options is correct about possible configurations for DB2 pureScale#39;s network topology?

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

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

  3. DB2 pureScale does not support multiple cluster interconnect adapter ports, but It supports multiple switches, which greatly improves network resiliency.

  4. DB2 pureScale supports multiple cluster interconnect adapter ports for both cluster caching facilities and members. It does not support multiple switches.

Answer: A

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

Dumps4cert 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