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

1 cluster caching facility and 1 DB2 members.

2 cluster caching facilities and 1 DB2 member.

1 cluster caching facility and 2 DB2 members.

2 cluster caching facilities and 2 DB2 members.

Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.

Table data is protected against direct access to the table. Access using views is unrestricted.

In order to take advantage of this feature, applications must be changed to work with the RCAC feature.

Row and column level access control allows the creation of column masks that can control what column values a user is permitted to see.

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

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.

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.

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.

Shared Communication Area (SCA) Memory.

Lock Memory.

Local Buffer Pool Memory.

Group Buffer Pool Memory.

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

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

Lock escalations can take place if there is insufficient memory.

Request for locks might be denied.

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

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

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

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

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

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

DB2 10 pureScale is able to leverage DB2's Workload Manager.

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