Free IBM P2090-047 Practice Test & Real Exam Questions

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: Aug 03, 2026

Question #1

Given a plan ID, how would you obtain the query execution plan? (Choose two.)

A. Run EXECUTION PLAN before the query has been submitted.

B. Issue "SELECT * FROM _V_SESSION;"

C. Go to the query history within the Windows NzAdmin GUI tool.

D. Issue "SHOW PLANFILE <nn>;" after the query has been submitted.

E. Turn ODBC tracing ON.

Discussion 0

Correct Answer: C,D Vote an answer

Question #2

Which is NOT a function that can be performed by nzbackup?

A. Backup users/groups

B. Backup data

C. Backup the /nz/data directory

D. Backup schemas

Discussion 0

Correct Answer: C Vote an answer

Question #3

What two types of notification can be configured for an event? (Choose two.)

A. Insert a row into Table

B. Run a stored procedure.

C. Send an email to a list of addresses.

D. Send a Simple Network Message Protocol (SNMP) event.

E. Run a command on the active Host.

Discussion 0

Correct Answer: C,E Vote an answer

Question #4

nzload is invoked with the "allowReplay" option enabled. While the PureData System for Analytics Appliance changes state from online to pausing then to online, which statement is true about the nzload process on the Appliance?

A. nzload automatically restarts but the user must remove the allowReplay option.

B. nzload must be stopped and resumed by the user from the last check point.

C. nzload automatically continues without user intervention.

D. nzload will fail.

Discussion 0

Correct Answer: C Vote an answer

Question #5

When enabled, query history always collects information about login failures, session creation, session termination, and query history process startup. Which area does query history NOT collect data?

A. Tables

B. Disks

C. Queries

D. Plans

Discussion 0

Correct Answer: B Vote an answer

Question #6

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. ALTER TABLE TableA

C. DROP TABLE TableA

D. GRANT SELECT ON TableA TO UserA

Discussion 0

Correct Answer: D Vote an answer

Question #7

When are zonemaps initially created for a table?

A. ALTER TABLE ADD ZONEMAPS

B. nzreclaim

C. nzbackup

D. CREATE TABLE

Discussion 0

Correct Answer: D Vote an answer

Question #8

What is the fastest join utilized by PureData System for Analytics?

A. Expression join.

B. Cross product join.

C. Hash join.

D. Merge join.

Discussion 0

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