最新的IBM PureData System for Analytics Technical Mastery Test v1 - P2090-050免費考試真題

A. Materialized views can reference only onebase table in the FROM clause.

B. Materialized views can contain a WHERE clause.

C. Materialized views can contain an ORDER BY clause.

D. Materialized views can contain aggregates.

E. Materialized views can contain a HAVING clause.

A. Host resets or fails.

B. Disk resets or fails.

C. Snippet Processing Unit (SPU) resets or fails.

D. S-Blade resets or fails.

A. Columns to be compressed must be defined.

B. The nzcompress utility must be run to compress thedatabase.

C. Data automatically gets compressed.

D. The nzcompress utility must be run to compress the table.

A. Materialized views are the same as database views.

B. Materialized views may improve query performance.

C. Materialized views are not supported.

D. Materialized views are logical entities.

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

A. Uncommitted read

B. Committed read

C. Serializable

D. Repeatable read

A. Primary key constraints will be checked.

B. Statistics will automatically be generated.

C. Groom will be automatically invoked.

D. Materialized views will be automatically generated.

A. /nz/kit/log

B. The SYSTEM database

C. /usr/local

D. /var/log