March Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

IBM P2090-054 IBM Information Management DB2 10 pureScale Technical Mastery Test v3 Exam Practice Test

Page: 1 / 7
Total 69 questions

IBM Information Management DB2 10 pureScale Technical Mastery Test v3 Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$36  $119.99

PDF Study Guide

  • Product Type: PDF Study Guide
$31.5  $104.99
Question 1

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

Options:

A.

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

B.

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.

C.

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.

D.

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.

Question 2

Which one of the following options is CORRECT about DB2 pureScale feature?

Options:

A.

DB2 pureScale is only available for DB2 Express-C and DB2 Advanced Enterprise Edition.

B.

DB2 pureScale uses the same concept of HADR where the data is replicated from a primary database to a standby database.

C.

DB2 pureScale persists data in the cluster caching facilities (CFs).

D.

DB2 pureScale reduces the risk and cost associated with growing your distributed database solution by providing extreme capacity and application transparency.

Question 3

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?

Options:

A.

db2instance -display -cluster -modifications

B.

db2instance -list -cfs -details

C.

db2instance -all -cfs

D.

db2instance -list

Question 4

The following are true about the Configuration Advisor, EXCEPT:

Options:

A.

It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.

B.

It creates database objects such as indexes and MQTs to improve performance.

C.

By default, the Configuration Advisor is automatically executed when you create a new database.

D.

To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.

Question 5

Which one of the following options is CORRECT?

Options:

A.

In both DB2 pureScale and HADR environments data is available all the time.

B.

DB2 pureScale transfers log files from a primary database to a standby database.

C.

HADR persists data in the cluster caching facilities (CFs).

D.

In a pureScale environment, the data is available all the time, while in a HADR environment the data is available most of the time.

Question 6

Which one of the following statements is FALSE about DB2 Workload Management (WLM)?

Options:

A.

When a WLM threshold condition is violated an action is executed in order to maintain stability in the system.

B.

DB2 Workload Management uses workloads to identify incoming work based on the connection attributes under which the work is submitted.

C.

DB2 Workload Management dispatcher can be used to control sharing of memory resources among active workloads.

D.

DB2 Workload Management allows dynamic re-prioritization of work by remapping a workload to a different service class.

Question 7

Which one of the following statements is TRUE about DB2 Workload Management (WLM)?

Options:

A.

DB2 Workload Management requires several application changes in order to make the application aware of the WLM feature.

B.

DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server.

C.

DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs, REORGs, or RUSTATS.

D.

DB2 Workload Management allows you to assign resources to different workloads, which leads to a stable and predictable execution environment.

Question 8

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

Options:

A.

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.

B.

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.

C.

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.

D.

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.

Question 9

Which of the following options does NOT describe a benefit of DB2's Row Compression?

Options:

A.

Compression allows you to reduce CPU workload because there is less data to process.

B.

Compression allows you to retrieve the same amount of data using fewer disk operations (I/O).

C.

Compression allows you to cache more data in the buffer pools using the same amount of space.

D.

Compression allows you to store the same amount of data in less space, which can significantly save storage costs.

Question 10

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

Options:

A.

All data remains locked until the failover operation is completed.

B.

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

C.

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

D.

DB2 pureScale requires database administrator intervention to handle failover scenarios.

Page: 1 / 7
Total 69 questions