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.
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.
How are records marked for deletion?
A. Vertica removes the file that stores the deleted data.
B. Vertica rewrites the files that contained the deleted records, ignoring records to be deleted.
C. Vertica deletes the records from the original source files.
D. Vertica creates a delete vector, identifying records to be deleted.
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
How does mergeout purge data marked for deletion?
A. It creates delete vectors, identifying files that can be removed from the system.
B. It updates files by removing records marked with delete vectors.
C. It writes undeleted records to files in a new location, then deletes all source files.
D. It writes deleted records to files in a new location, then deletes all source files.
What are the advantages of a merge join versus a hash join? (Select two.)
A. Sometimes a merge join runs faster than a hash join.
B. A merge join uses memory more efficiently.
C. A merge join requires no optimization.
D. A merge join can spill to disk if the inner table is too large.
E. A merge join joins the data into a new projection.
What is local segmentation capability in Vertica?
A. Vertica automatically splits current segments in half to redistribute them to new nodes.
B. Vertica automatically partitions the data, allowing partitions to be dropped and recreated on new nodes.
C. Vertica automatically creates more segments than are currently needed, allowing some segments to be moved to new nodes as needed.
D. Vertica automatically partitions the segmented data, allowing some partitions to be moved to new nodes as needed.
What is the process for online recovery of a failed node? (Select two.)
A. The recovered node gathers the necessary files from nodes with its buddy projections.
B. The recovered node verifies that it is current once a recovery cycle completes.
C. The recovered node uses spread to speed up the recovery process.
D. The recovered node restores all files from the last backup.
E. The recovered node must be rebuilt from epoch 0.
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.
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.
