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 #1

Why is table skew important to manage?

A. High table skew negatively impacts performance.

B. Low table skew negatively impacts data compression.

C. Low table skew negatively impacts performance.

D. Deleted rows consume disk space until they are freed.

Discussion 0

Correct Answer: A Vote an answer

Question #2

Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?

A. Use external tables and UNIX pipes.

B. Use a CTAS (Create Table as Select) SQL statement.

C. Use nzbackup and nzrestore commands.

D. Use the COPY command.

Discussion 0

Correct Answer: B Vote an answer

Question #3

In order for an ODBC application running on Microsoft Windows to connect to PureData System for Analytics, which two steps must be performed? (Choose two.)

A. Install an ODBC driver for Windows.

B. Install nzAdmin for Windows.

C. Create or modify a Data Source Name (DSN) for a connection to a database.

D. Install an ODBC Driver Manager for Windows.

E. Install nzsql for Windows.

Discussion 0

Correct Answer: A,C Vote an answer

Question #4

What operating system runs on a PureData System for Analytics host?

A. Redhat Linux

B. Nucleus OS

C. SUSE Linux

D. AIX

Discussion 0

Correct Answer: A Vote an answer

Question #5

Which will result in support for zonemaps on the LastName column?

A. CREATE TABLE TableA (LastName VARCHAR(20));

B. CREATE TABLE TableA (LastName VARCHAR(20)) DISTRIBUTE ON (LastName);

C. CREATE TABLE TableA (LastName VARCHAR(20));
ALTER TABLE TableA ZONEMAP ON (LastName);

D. CREATE TABLE TableA (LastName VARCHAR(20));
CREATE MATERIALIZED VIEW ViewA AS SELECT * FROM TableA ORDER BY
LastName;

Discussion 0

Correct Answer: D Vote an answer

Question #6

A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?

A. Use an EXTERNAL table.

B. Use a CURSOR.

C. Increase the PreFetch Count.

D. Use the COPY command.

Discussion 0

Correct Answer: A Vote an answer

Question #7

What is the only predefined database user, which is able to access all objects and perform all tasks against the database?

A. root

B. admin

C. public

D. system

Discussion 0

Correct Answer: B 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.