Create Next App

Exam contains 131 questions

Page 6 of 22

Question 31 🔥

Which statement is true about queries on the Pure Data System for Analytics appliance?

Which database solution meets these requirements?

A. Queries are executed in parallel by the host.

Highly voted

B. Queries must be compressed before they can be executed.

Highly voted

C. Queries are compiled into snippets and executed in parallel by the S-Blades.

Highly voted

D. Queries must be uncompressed by the user and executed in parallel by the host.

Highly voted

E. A query is compiled into a snippet which is executed across all available S-Blades.

Highly voted

Discussion of the question

Question 32 🔥

All database users are members of what predefined database group, which governs the basic access permissions that are granted to the system?

Which database solution meets these requirements?

A. GUEST

Highly voted

B. USERS

Highly voted

C. PUBLIC

Highly voted

D. GLOBAL

Highly voted

Discussion of the question

Question 33 🔥

Which command will backup users and groups on the system?

Which database solution meets these requirements?

A. nzbackup -all

Highly voted

B. nzhostbackup

Highly voted

C. nzbackup-globals

Highly voted

D. nzbackup-system

Highly voted

Discussion of the question

Question 34 🔥

Which statement is TRUE regarding any database user?

Which database solution meets these requirements?

A. The user has a tablespace defined

Highly voted

B. The user can be assigned to more than one group

Highly voted

C. The user must have a corresponding host account

Highly voted

D. The user can be removed from the default PUBLIC group

Highly voted

Discussion of the question

Question 35 🔥

Why is it important to manage data skew?

Which database solution meets these requirements?

A. Low table skew negatively impacts performance

Highly voted

B. High table skew negatively impacts performance

Highly voted

C. Low table skew negatively impacts data compression

Highly voted

D. Deleted rows consume disk space until they are freed

Highly voted

Discussion of the question

Question 36 🔥

Which statement regarding temporary tables is TRUE?

Which database solution meets these requirements?

A. They are limited to 1 terabyte in size

Highly voted

B. They may include a DISTRIBUTE ON clause

Highly voted

C. They are limited to 16 tables per user per database

Highly voted

D. They will be included in any nzbackup of the database

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_560

Exam contains 131 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us