HP HP2-N36 Online Practice Questions and Exam Preparation

HP HP2-N36 Online Questions & Answers

• Question 41:

  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
  A. full replicas of fact tables and segmented dimension tables

• Question 42:

  What are the actions of the mergeout task? (Select three.)

  A. Mergeout rewrites all ROS containers.
  B. Mergeout writes data to memory.
  C. Mergeout consolidates containers on disk.
  D. Mergeout places data into all defined projections on the source table.
  E. Mergeout purges deleted data already on disk.
  F. Mergeout moves data from memory to disk.
  C. Mergeout consolidates containers on disk.
  D. Mergeout places data into all defined projections on the source table.
  E. Mergeout purges deleted data already on disk.

  ---

  Reference:https://my.vertica.com/docs/6.1.x/HTML/index.htm#2624.htm#o14826

• Question 43:

  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).
  A. Restart spread on all hosts in the cluster.
  E. Redistribute data to the new host(s).

• Question 44:

  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.
  A. A prejoin projection enforces primary and foreign key constraints.
  B. A prejoin projection does not increase the storage footprint.
  E. A prejoin projection adds no limitations to the tables in the join.

• Question 45:

  What does Time Series do?

  A. enables identification of a sequence of defined events
  B. evaluates the values of a given set of variables and groups those values into a window
  C. increments a counter based on whether an expression evaluates as true
  D. enables analysis of two series of data when their measurement intervals do not align precisely
  B. evaluates the values of a given set of variables and groups those values into a window

• Question 46:

  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.
  A. A projection can contain data from one or more source tables.
  D. Each projection contains all rows from the source table.
  F. Each projection contains all columns from the source table.

  ---

  Reference:http://184.106.12.19/2011/09/02/the-power-of-projections-part-2/

• Question 47:

  What are the disadvantages of using delete vectors to identify records marked for deletion? (Select two.)

  A. Delete vectors are stored in a different location, minimizing storage impact.
  B. Delete vectors rewrites files, causing additional overhead.
  C. Delete vectors must be recognized during the query process to remove records marked for deletion from the result set, slowing down the processing of a query.
  D. Delete vectors do not instantly reclaim space used by deleted records.
  E. Delete vectors must be maintained forever.
  C. Delete vectors must be recognized during the query process to remove records marked for deletion from the result set, slowing down the processing of a query.
  D. Delete vectors do not instantly reclaim space used by deleted records.

• Question 48:

  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');
  C. SELECT set_config_parameter ('MaxClientSessionsVS');

• Question 49:

  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
  A. root and dbadmin users only

• Question 50:

  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
  D. provides a unified view of all Vertica clusters
  E. provides a visual depiction of CPU usage across the nodes of the cluster