HP2-N36 Online Practice Questions and Answers

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.

What are key features of Vertica? (Select three.)

A. uses fully custom SQL syntax

B. columnar data store

C. stored data that is encoded and compressed

D. native high availability

E. runs on a Windows platform

F. data caching for fast retrieval

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

What are the actions of the moveout task? (Select two.)

A. Moveout consolidates containers already on disk.

B. Moveout places data into all defined projections on the source table.

C. Moveout rewrites all ROS containers.

D. Moveout moves data from memory to disk.

E. Moveout writes data to memory.

F. Moveout purges deleted data already on disk.

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.

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 is a benefit of having identically-sorted buddy projections?

A. improved storage usage, since Vertica shares data files

B. more efficient use of disk since the data is only on one node

C. better query performance, since Vertica gets half the data from each projection

D. fast recovery of a down node

Which statements are true about a prejoin projection? (Select three.)

A. A prejoin projection enforces primary and foreign key constraints.

B. A prejoin projection does not increase the storage footprint.

C. A prejoin projection slows down data loading.

D. A prejoin projection can process any type of join.

E. A prejoin projection adds no limitations to the tables in the join.

F. A prejoin projection improves query run time performance.

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

Which features are available when using the Management Console for monitoring Vertica? (Select two.)

A. can only be accessed from a Windows machine

B. can only be accessed from a Linux machine

C. can be used by multiple users, with different sets of privileges for each

D. provides a unified view of all Vertica clusters

E. provides a visual depiction of CPU usage across the nodes of the cluster