IBM P2090-047 Actual Free Exam Questions & Community Discussion

Exam Code/Number: P2090-047
Exam Name/Title: IBM PureData System for Transactions Technical Mastery Test v1
Certification Provider: IBM
Corresponding Certification: IBM Information Management

Exam Questions: 132
Updated On: Sep 09, 2026

Question #15

Which statement is true regarding the compress engine?

A. Compression degrades data scan speeds.

B. Compression is performed by the SAS switches.

C. Compression is performed by the host.

D. Compression ratio is data dependent.

Discussion 0

Correct Answer: D Vote an answer

Question #16

Columns in a table may be zonemapped. How are those columns chosen?

A. They are added via the ALTER TABLE ADD ZONEMAP(column_name) statement.

B. They are added via the ALTER TABLE ADD INDEX(column_name) statement.

C. They are based on the same columns as the table's distribution key.

D. They are automatically selected by the system.

Discussion 0

Correct Answer: D Vote an answer

Question #17

What is a characteristic of a column that is based on the TIMESTAMP datatype?

A. It includes a timezone offset.

B. It includes a date portion.

C. The value is reevaluated each time the row is selected.

D. The value is initially assigned when the row is first created.

Discussion 0

Correct Answer: B Vote an answer

Question #18

Which statement is true about optimizer settings?

A. They can be set at the database level only.

B. They can be set system wide and at the session level.

C. They can be set system wide only.

D. They can be set at the session and at the group level.

Discussion 0

Correct Answer: B Vote an answer

Question #19

TableA is currently being accessed in a number of long running queries. Which of the following operations is NOT blocked, thus allowing the operation to immediately proceed?

A. TRUNCATE TABLE TableA

B. GRANT SELECT ON TableA TO UserA

C. DROP TABLE TableA

D. ALTER TABLE TableA

Discussion 0

Correct Answer: B Vote an answer

Question #20

When is the ToplogyImbalance event triggered?

A. When a SAS switch has failed.

B. When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement).

C. When the path the path between an S-Blade and its disks has failed.

D. When a disk enclosure's voltage sensor is reading outside the nominal range.

Discussion 0

Correct Answer: B Vote an answer

Question #21

Which piece of information is NOT gathered as part of the statistical information when generate statistics is run on a table?

A. The number of updated rows in the table.

B. The number of unique or distinct values in each column.

C. The minimum and maximum value in each column.

D. The number of rows in the table.

Discussion 0

Correct Answer: A Vote an answer

Download Free IBM P2090-047 Demo

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