New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Note! Following P2090-050 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

IBM PureData System for Analytics Technical Mastery Test v1 Questions and Answers

Question 1

In order to set a runaway query event totrigger when a query runs longer than two minutes, which two items must be configured? (Choose two.)

Options:

A.

The runaway query event was enabled.

B.

The pg.log file was configured for two minutes.

C.

The runaway query event was configured for two minutes.

D.

The nzsystem command was used to set the QUERYTIMEOUT to two minutes.

E.

The CREATE USER command was used to set the QUERYTIMEOUT to two minutes.

Buy Now
Question 2

Why is table skew important to manage?

Options:

A.

Low table skew negatively impacts performance.

B.

High table skew negatively impacts performance.

C.

Low table skew negatively impacts data compression.

D.

Deleted rows consume disk space until they are freed.

Question 3

Which statement is NOT true?

Options:

A.

nzbackup backs up selected tables.

B.

nzbackup backs up to a file system destination.

C.

nzbackup backs up to a Veritas NetBackup destination.

D.

nzbackup backs up to a IBM Tivoli Storage Manager destination.