HP HP2-N36 Online Practice Questions and Exam Preparation

HP HP2-N36 Online Questions & Answers

• Question 1:

  What are the standard clauses in an analytics query?

  A. It includes a PARTITION clause, with required over_clause, order_clause, and frame_clause.
  B. It includes an OVER clause, with required partition_clause, order_clause, and frame_clause
  C. It includes an OVER clause, with optional partition_clause, order_clause, and frame_clause.
  D. It includes a PARTITION clause, with optional over_clause, order_clause, and frame clause.
  B. It includes an OVER clause, with required partition_clause, order_clause, and frame_clause

• Question 2:

  Which methods exist to troubleshoot spread? (Select two.)

  A. Power cycle the server
  B. Restart the spread daemon on the node.
  C. Restart the Vertica process on the node.
  D. Verify that spread.conf is the same on all nodes.
  E. Verify that spread.conf is different on all nodes.
  B. Restart the spread daemon on the node.
  C. Restart the Vertica process on the node.

• Question 3:

  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 4:

  What does an event-based window do?

  A. 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
  C. enables identification of a sequence of defined events
  D. increments a counter based on whether an expression evaluates as true
  B. evaluates the values of a given set of variables and groups those values into a window

• Question 5:

  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
  A. loading status and errors
  D. recovery progress and errors

• Question 6:

  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

• Question 7:

  What can be used to determine memory resources needed by a query?

  A. Generate an EXPLAIN plan on the query.
  B. Review the digraph of the query.
  C. PROFILE the query.
  D. Run the query and view the information in the results.
  C. PROFILE the query.

• Question 8:

  Which statement is true about a query explain plan?

  A. It determines how to run the query, runs it, and returns the result.
  B. It writes the SQL to execute a query.
  C. It tells exactly how many rows will be returned by the query.
  D. It displays the results of Optimizer to the user, showing projection(s) used and the query process.
  B. It writes the SQL to execute a query.

• Question 9:

  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
  A. enables analysis of two series of data when their measurement intervals do not align

  ---

  explanation:

  Reference:http://www.vertica.com/wp-content/uploads/2011/06/Whats-New-in-Vertica-50.pdf(page 1, see event series join)

• Question 10:

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