HP2-N36 Online Practice Questions and Answers

What is the purpose of Vertica's transaction model? (Select three.)

A. Transactions mean that undo logs are not needed.

B. Transactions are used to maintain partitions.

C. Transactions are only written upon an explicit commit being issued.

D. Transactions are used for data recovery.

E. Transactions are used to delete data.

F. Transactions are used to maintain segmentation.

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

Which notation must be added to the COPY command to cause data to be placed directly in ROS?

A. DISC

B. DIRECT

C. NOWOS

D. ROS

What are the benefits of loading data into WOS?

A. The data is cached in memory for quick access.

B. The data is able to be queried as soon as it is loaded.

C. The data is broken out into projections.

D. The data is sorted.

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.

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.

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 are the advantages of a group by pipe versus a group by hash? (Select two.)

A. A group by pipe uses memory more efficiently.

B. A group by pipe can be processed spill to disk if the join result is large.

C. A group by pipe is at least as fast as a group by hash.

D. A group by pipe requires no optimization.

E. A group by pipe builds its entire output table in memory.

What is a Vertica cluster?

A. a collection of projection files

B. a grouping of several Vertica databases

C. the set of nodes running one instance of Vertica

D. a physical machine configured to run an instance of Vertica

What does Event Series Join do?

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

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