Create Next App

Exam contains 131 questions

Page 3 of 22

Question 13 🔥

What can be backed up using the nzbackup utility?

Which database solution meets these requirements?

A. Host data

Highly voted

B. pg.log files

Highly voted

C. Temporary tables

Highly voted

D. User permissions

Highly voted

Discussion of the question

Question 14 🔥

Which of the following will NOT show the current sessions on the Netezza server?

Which database solution meets these requirements?

A. nzsql\act

Highly voted

B. nzsession

Highly voted

C. nzsystem-showSessions

Highly voted

D. SELECT* FROM_v_session

Highly voted

Discussion of the question

Question 15 🔥

Which of the following statements about temporary tables is TRUE?

Which database solution meets these requirements?

A. Synonyms can be created for temporary tables

Highly voted

B. Temporary tables have been deprecated as of NPS 7.0.3

Highly voted

C. Temporary tables can be specified as a base table for materialized views

Highly voted

D. When a user executes the command "SET SESSION READ ONLY", they are still able to create and write to temporary tables

Highly voted

Discussion of the question

Question 16 🔥

What are two considerations for usage of materialized views? (Choose two.)

Which database solution meets these requirements?

A. Materialized views are not supported.

Highly voted

B. Materialized views are logical entities.

Highly voted

C. Materialized views may improve query performance.

Highly voted

D. Materialized views are the same as database views.

Highly voted

E. Materialized views are considered for usage by the Optimizer.

Highly voted

Discussion of the question

Question 17 🔥

Netezza database accounts are NOT created and/or managed using

Which database solution meets these requirements?

A. The NzAdmin tool

Highly voted

B. The Netezza Performance Portal

Highly voted

C. The Netezza command line interface

Highly voted

D. The Netezza host's command line interface

Highly voted

Discussion of the question

Question 18 🔥

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