HP2-N36 Online Practice Questions and Answers

What are the benefits of ordering data in projection design? (Select two.)

A. It enables optimum encoding.

B. It enables partitioning of data.

C. It enables efficient sharing of data between similarly-ordered projections.

D. It enables efficient application of query predicates.

E. It enables segmentation of data.

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

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

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

How can you disallow user connections, while preserving dbadmin connectivity?

A. SELECT close_session (session_id);

B. SELECT close_all_sessions;

C. SELECT set_config_parameter ('MaxClientSessionsVS');

D. SELECT set_config_parameter ('MaxClientSessionsVO');

What is available on the Jobs chart in the Management Console? (Select two)

A. loading status and errors

B. resource pool usage

C. memory usage

D. recovery progress and errors

E. query performance

Who can log in to the Management Console?

A. root and dbadmin users only

B. root user only

C. any user with permission granted

D. dbadmin user only