IBM Information Management DB2 10.5 pureScale Technical Mastery Test v3 試験
2020 年末感謝：P2090-054 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。
Question No : 1
Which of the following statements describes the STMM (Self-Tuning Memory Manager) functionality in a DB2 pureScale environment?
Question No : 2
Each DB2 member in a DB2 pureScale environment has an associated database log. Where is this log stored?
Question No : 3
Which one of the following options describes a benefit of Geographically Dispersed pureScale Cluster (GDPC)?
Question No : 4
Which of the following is NOT valid state for the Cluster Caching Facility?
Question No : 5
How are client connections handled in a standard DB2 pureScale environment?
Question No : 6
Which of the following statements is FALSE about DB2 pureScale?
Question No : 7
Which one of the following options is correct about DB2 pureScale installation?
Question No : 8
Which of the following options is correct about possible configurations for DB2 pureScale's network topology?
Question No : 9
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?
Question No : 10
Consider the scenario where a client application is connected to DB2 pureScale "member 1". The DB2 pureScale environment has three DB2 pureScale members. In a situation where "member 1" 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?
Question No : 11
Consider a scenario where a database administrator (DBA) requires an overview of the pureScale cluster database. After issuing a "db2instance -list" 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?
Question No : 12
Which of the following options justifies why you should be actively monitoring buffer pool hit ratios on your DB2 pureScale environment?
Question No : 13
What is the purpose of the tiebreaker disk in a DB2 pureScale environment?
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?
Question No : 15
Consider the scenario where two members, "M1" and "M2", intend to update two different rows on the same data page: 1."M1" 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."M2" requires an exclusive lock to the same page to update row R2. It passes this request to the cluster caching facility. "M2" waits while the request is processed. 3.The cluster caching facility sees that member "M1" already has an exclusive access to the page. It issues a request to "M1" for the page. In the meantime, "M2" waits. 4."M1" processes the request by writing the page back to the global buffer pool and then releasing the page lock. ("M1" retains any row or table locks it might have had). 5.The cluster caching facility grants "M2" access to the page. "M2" 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?