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

What is the WOS?

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 redundant write-only location used to improve node uptime

D. a row-store, memory-based method for adding data to Vertica

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.

If your CEO runs a query each day, how can you be assured necessary resources will be available when the query is run? (Select two.)

A. Create a resource pool with dedicated resources for the CEO.

B. Move all other users out of the general pool, leaving the CEO as the only user in the general pool.

C. Reserve one core for use by the CEO user only.

D. Assign the CEO user to the general resource pool with a high MEMORYCAP.

E. Profile the query to determine estimated resource usage.

What is a difference between maxconcurrency and plannedconcurrency?

A. Maxconcurrency is a hard limit to the number of queries running within a pool; plannedconcurrency is used to create a query budget.

B. Maxconcurrency is used to create a query budget; plannedconcurrency is a hard limit to the number of queries running within a pool.

C. Maxconcurrency is a hard limit to the number of queries running within a pool; plannedconcurrency limits the number of queries running on the cluster.

D. Maxconcurrency limits the number of queries running on the cluster; plannedconcurrency is a hard limit to the number of queries running within a pool.

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');

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

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