What does Time Series do?

A. enables identification of a sequence of defined events

B. evaluates the values of a given set of variables and groups those values into a window

C. increments a counter based on whether an expression evaluates as true

D. enables analysis of two series of data when their measurement intervals do not align precisely

Which statements are true of a projection? (Select two.)

A. They can contain a comparison predicate.

B. They can contain a join condition.

C. They can only be created prior to loading data.

D. They can be created at any time, either before or after data is loaded into a table.

E. They can contain aggregate functions.

What are the benefits of using delete vectors to identify records marked for deletion? (Select two.)

A. Delete vectors move deleted records to files in a new location.

B. Delete vectors enable historical queries of data marked for deletion until the data has been purged.

C. Delete vectors rewrite the original files, immediately purging them off the system.

D. Delete vectors are stored in a different location, minimizing storage impact.

E. Delete vectors are a fast method for marking records for deletion.

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 statement is true about the data directory location across the nodes of a cluster?

A. It must be in the same location on each node.

B. It can be stored in different formats on different nodes.

C. It can be in different locations on each node.

D. It must be in a single location, accessible to all nodes in the cluster.

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

A. mergesync

B. movesync

C. mergeout

D. moveout

What is the ROS?

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 row-store, memory-based method for adding data to Vertica

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

What is a difference between maxconcurrency and plannedconcurrency?

A. Maxconcurrency is a hard limit to the number of queries running within a pool; plannedconcurrency is used to create a query budget.

B. Maxconcurrency is used to create a query budget; plannedconcurrency is a hard limit to the number of queries running within a pool.

C. Maxconcurrency is a hard limit to the number of queries running within a pool; plannedconcurrency limits the number of queries running on the cluster.

D. Maxconcurrency limits the number of queries running on the cluster; plannedconcurrency is a hard limit to the number of queries running within a pool.

What is available on the Jobs chart in the Management Console? (Select two)

A. loading status and errors

B. resource pool usage

C. memory usage

D. recovery progress and errors

E. query performance

What does an event-based window do?

A. enables analysis of two series of data when their measurement intervals do not align precisely

B. evaluates the values of a given set of variables and groups those values into a window

C. enables identification of a sequence of defined events

D. increments a counter based on whether an expression evaluates as true