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

Which User Defined Function (UDF) statement is true?

A. It accepts zero or more input values and produces one or more output values.

B. it accepts exactly one input value and produces one or more output values.

C. It accepts exactly one input value and produces exactly one output value.

D. It accepts zero or more input values but produces one output value.

Discussion 0

Correct Answer: D Vote an answer

Question #9

What is the maximum number of columns that can participate in a distribution key?

A. Depends on the number of columns of integer datatype.

B. Four

C. One

D. Unlimited

Discussion 0

Correct Answer: B Vote an answer

Question #10

With LDAP enabled, which of the following is verified against an LDAP server?

A. Database user GROUP authentication.

B. Database user SELECT privileges.

C. Database user password authentication.

D. Database user ADMIN privileges.

Discussion 0

Correct Answer: C Vote an answer

Question #11

Which component failure does NOT trigger a HardwareServiceRequested event?

A. S-Blade

B. Disk

C. Fan

D. Host

Discussion 0

Correct Answer: D Vote an answer

Question #12

Which file format is NOT supported by the nzload utility?

A. ASCII delimited format.

B. gzip compressed file format.

C. Fixed length record format.

D. PureData System for Analytics compressed file format.

Discussion 0

Correct Answer: B Vote an answer

Question #13

Short Query Bias (SQB) allows for reserved resources to be used for which type of query?

A. Queries with no joins.

B. Queries returning only one row in the result set.

C. SQL statements less than 255 characters in length.

D. Queries with a runtime estimation of less than 2 seconds.

Discussion 0

Correct Answer: D Vote an answer

Question #14

What is nzconvert used for?

A. To upgrade/downgrade the database to a different software version.

B. To translate stored procedures into NZPLSQL compatible syntax.

C. To convert compressed external tables into ASCII text.

D. To convert between character encodings before loading data.

Discussion 0

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