HP HP ExpertONE Certification HP2-N36 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.

  Correct Answer: B

• Question 2:

  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

  Correct Answer: A

• Question 3:

  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.

  Correct Answer: BC

• Question 4:

  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.

  Correct Answer: C

• Question 5:

  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

  Correct Answer: DE

• Question 6:

  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

  Correct Answer: AD

• Question 7:

  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

  Correct Answer: B

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

  Correct Answer: B

• Question 9:

  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

  Correct Answer: B

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

  Correct Answer: C