What is the process to add hosts to an existing cluster? (Select two.)

A. Restart spread on all hosts in the cluster.

B. Recreate all projections on the new hosts.

C. Update spread.conf on the new host(s) only.

D. Install Vertica on the new hosts.

E. Redistribute data to the new host(s).

What are features of using the Vertica backup script? (Select two.)

A. It uses a lightweight locking protocol, stopping data loading for a brief period of time

B. It can be run remotely via the Management Console

C. It enables recovery by database, node, or table

D. It enables backup of the entire database only

E. It can be run while the database is not running.

Which methods are available to optimize a projection for delete processing? (Select two.)

A. Add a low cardinality column to the beginning of all projections on the source table.

B. Add a high cardinality column to the end of all projections on the source table.

C. Add all columns used as delete predicates to all projections on the source table.

D. Add a low cardinality column to the end of all projections on the source table.

E. Add a high cardinality column to the beginning of all projections on the source table.

Which statement is true about a query explain plan?

A. It determines how to run the query, runs it, and returns the result.

B. It writes the SQL to execute a query.

C. It tells exactly how many rows will be returned by the query.

D. It displays the results of Optimizer to the user, showing projection(s) used and the query process.

What are the standard clauses in an analytics query?

A. It includes a PARTITION clause, with required over_clause, order_clause, and frame_clause.

B. It includes an OVER clause, with required partition_clause, order_clause, and frame_clause

C. It includes an OVER clause, with optional partition_clause, order_clause, and frame_clause.

D. It includes a PARTITION clause, with optional over_clause, order_clause, and frame clause.