What is the difference between dropping a partition and deleting records?

A. Dropping a partition creates delete vectors; deleting records does not create delete vectors.

B. Dropping a partition can be rolled back; deleting records cannot be rolled back.

C. Dropping a partition creates new files; deleting records does not create new files.

D. Dropping a partition recovers space immediately; deleting records does not recover space immediately.

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 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.