What are characteristics of projections in Vertica? (Select three.)

A. A projection can contain data from one or more source tables.

B. A projection can contain data from only one source table.

C. A projection can contain a subset of rows from the source table.

D. Each projection contains all rows from the source table.

E. A projection can contain a subset of columns from the source table.

F. Each projection contains all columns from the source table.

What does the acronym RLE stand for?

A. run language encoding

B. random length encoding

C. random language encoding

D. run length encoding

How does Vertica implement high availability in a clustered environment?

A. full replicas of fact tables and segmented dimension tables

B. full replicas of all data on all nodes

C. built-in redundancy of data

D. continuous mirroring of data

What are the actions of the mergeout task? (Select three.)

A. Mergeout rewrites all ROS containers.

B. Mergeout writes data to memory.

C. Mergeout consolidates containers on disk.

D. Mergeout places data into all defined projections on the source table.

E. Mergeout purges deleted data already on disk.

F. Mergeout moves data from memory to disk.

What is the WOS?

A. a redundant copy of commonly read data, cached in memory

B. a column-store, disk-based method for storing data in Vertica

C. a redundant write-only location used to improve node uptime

D. a row-store, memory-based method for adding data to Vertica

Which task consolidates data containers, sorting, compressing, and purging data as needed?

A. mergesync

B. movesync

C. mergeout

D. moveout

What is the Resource Manager's role in query processing?

A. serializing all requests to simulate concurrency

B. determination and allocation of request importance

C. determination and allocation of memory, threads, and file handles for the request

D. allowing queries to run in place of background tasks

Which statements are true about a prejoin projection? (Select three.)

A. A prejoin projection enforces primary and foreign key constraints.

B. A prejoin projection does not increase the storage footprint.

C. A prejoin projection slows down data loading.

D. A prejoin projection can process any type of join.

E. A prejoin projection adds no limitations to the tables in the join.

F. A prejoin projection improves query run time performance.

How can you disallow user connections, while preserving dbadmin connectivity?

A. SELECT close_session (session_id);

B. SELECT close_all_sessions;

C. SELECT set_config_parameter ('MaxClientSessionsVS');

D. SELECT set_config_parameter ('MaxClientSessionsVO');

Which methods exist to troubleshoot spread? (Select two.)

A. Power cycle the server

B. Restart the spread daemon on the node.

C. Restart the Vertica process on the node.

D. Verify that spread.conf is the same on all nodes.

E. Verify that spread.conf is different on all nodes.