IBM P2090-054 Actual Free Exam Questions & Community Discussion

Exam Code/Number: P2090-054
Exam Name/Title: IBM Information Management DB2 10.5 pureScale Technical Mastery Test v3
Certification Provider: IBM
Corresponding Certification: IBM Information Management

Exam Questions: 70
Updated On: May 30, 2026

Question #15

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

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

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

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

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

Discussion 0

Correct Answer: A Vote an answer

Question #16

How can you verify that a DB2 installation was successful?

A. Verification is performed by running the VERIFY INSTALL command.

B. Verification is completed by the DBA using the database verification toolkit.

C. Verification can be done by successfully creating a SAMPLE database and running SQL commands to retrieve sample data.

D. Verification is automatically performed by the AUTO_CONFIGURE feature.

Discussion 0

Correct Answer: C Vote an answer

Question #17

What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?

A. This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.

B. The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.

C. This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.

D. STMM allows DBAs to inspect the current memory allocation by buffer pools.

Discussion 0

Correct Answer: A Vote an answer

Question #18

Which of the following memory heaps is NOT configurable on the cluster caching facility?

A. Local Buffer Pool Memory.

B. Lock Memory.

C. Shared Communication Area (SCA) Memory.

D. Group Buffer Pool Memory.

Discussion 0

Correct Answer: A Vote an answer

Question #19

How does DB2 pureScale balance the workload among its members?

A. Workload balance is handled by the Self Tuning Memory Manager (STMM) feature.

B. Workload balance cannot be handled by DB2 pureScale. It must be handled by a third-
party application.

C. Workload balance must be handled by the application.

D. Workload balance is automatically performed by DB2 pureScale by rerouting the workload to members with lighter loads.

Discussion 0

Correct Answer: D Vote an answer

Question #20

Consider the scenario of a DB2 pureScale environment with two DB2 members, and assume there is an active connection to "member 3". Due to some maintenance emergency, "member 3" needs to be stopped. Which one of the following commands will stop "member 3"?

A. db2stop node 3 all members

B. db2stop force member 3

C. db2stop immediate member 3

D. db2stop member 3

Discussion 0

Correct Answer: B Vote an answer

Question #21

Which of the following options best describes the differences between Label Based Access Control (LBAC) and Row and Column Access Control (RCAC)?

A. RCAC returns the data based on what is being asked (data centric), while LBAC returns data based on who is asking what (user centric). Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.

B. RCAC is a fixed label security model designed for the US government while LBAC is a general purpose security model best suited for commercial customers.

C. LBAC allows you to protect access only to rows, while RCAC allows you to protect both rows and columns.

D. With RCAC users do not get an error when accessing protected data, while with LBAC users can get an error if they don't have the necessary credentials to access a LBAC
protected column.

Discussion 0

Correct Answer: D Vote an answer

Download Free IBM P2090-054 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM P2090-054 exam.