HP HP2-N36 Online Practice Questions and Exam Preparation

HP HP2-N36 Online Questions & Answers

• Question 1:

  When is a backup recommended? (Select two.)

  A. prior to shutting down the cluster
  B. prior to upgrading Vertica
  C. prior to starting the Vertica cluster
  D. any time large amounts of data have been added, updated, or deleted
  E. any time data is added, updated, or deleted
  A. prior to shutting down the cluster
  E. any time data is added, updated, or deleted

• Question 2:

  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
  D. a row-store, memory-based method for adding data to Vertica

• Question 3:

  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
  C. a row-store, memory-based method for adding data to Vertica

• 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.
  C. PROFILE the query.

• Question 5:

  What is a benefit of having identically-sorted buddy projections?

  A. improved storage usage, since Vertica shares data files
  B. more efficient use of disk since the data is only on one node
  C. better query performance, since Vertica gets half the data from each projection
  D. fast recovery of a down node
  D. fast recovery of a down node

• Question 6:

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

  During Vertica installation, how do you install onto multiple nodes of a cluster?

  A. You must install the application individually on each node.
  B. Run the installation script from the Console machine once per node.
  C. Pass the IP address or node names as part of the -s argument, and it will install the application on each node.
  D. Pass the IP addresses or node names to spread, and it will install the application on each node.
  C. Pass the IP address or node names as part of the -s argument, and it will install the application on each node.

  ---

  Reference:https://my.vertica.com/wbt/installing_vertica/index.htm(start the video and go the topic that says multiple node installation)

• Question 8:

  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.
  A. A group by pipe uses memory more efficiently.
  E. A group by pipe builds its entire output table in memory.

• Question 9:

  What is the process for online recovery of a failed node? (Select two.)

  A. The recovered node gathers the necessary files from nodes with its buddy projections.
  B. The recovered node verifies that it is current once a recovery cycle completes.
  C. The recovered node uses spread to speed up the recovery process.
  D. The recovered node restores all files from the last backup.
  E. The recovered node must be rebuilt from epoch 0.
  B. The recovered node verifies that it is current once a recovery cycle completes.
  D. The recovered node restores all files from the last backup.

• Question 10:

  Which methods are available to optimize a projection for delete processing? (Select two.)

  A. Add a low cardinality column to the beginning of all projections on the source table.
  B. Add a high cardinality column to the end of all projections on the source table.
  C. Add all columns used as delete predicates to all projections on the source table.
  D. Add a low cardinality column to the end of all projections on the source table.
  E. Add a high cardinality column to the beginning of all projections on the source table.
  A. Add a low cardinality column to the beginning of all projections on the source table.
  C. Add all columns used as delete predicates to all projections on the source table.