HP HP2-N36 Online Practice Questions and Exam Preparation

HP HP2-N36 Online Questions & Answers

• Question 11:

  What are key features of Vertica? (Select three.)

  A. uses fully custom SQL syntax
  B. columnar data store
  C. stored data that is encoded and compressed
  D. native high availability
  E. runs on a Windows platform
  F. data caching for fast retrieval
  B. columnar data store
  C. stored data that is encoded and compressed
  D. native high availability

  ---

  Reference:http://www.vertica.com/the-analytics-platform/

• Question 12:

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

  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.
  A. Create a resource pool with dedicated resources for the CEO.
  E. Profile the query to determine estimated resource usage.

• Question 14:

  What are features of using the Vertica backup script? (Select two.)

  A. It uses a lightweight locking protocol, stopping data loading for a brief period of time
  B. It can be run remotely via the Management Console
  C. It enables recovery by database, node, or table
  D. It enables backup of the entire database only
  E. It can be run while the database is not running.
  B. It can be run remotely via the Management Console
  C. It enables recovery by database, node, or table

• Question 15:

  What are the benefits of ordering data in projection design? (Select two.)

  A. It enables optimum encoding.
  B. It enables partitioning of data.
  C. It enables efficient sharing of data between similarly-ordered projections.
  D. It enables efficient application of query predicates.
  E. It enables segmentation of data.
  D. It enables efficient application of query predicates.
  E. It enables segmentation of data.

• Question 16:

  What is the Resource Manager's role in query processing?

  A. serializing all requests to simulate concurrency
  B. determination and allocation of request importance
  C. determination and allocation of memory, threads, and file handles for the request
  D. allowing queries to run in place of background tasks
  C. determination and allocation of memory, threads, and file handles for the request

• Question 17:

  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.
  B. A merge join uses memory more efficiently.
  C. A merge join requires no optimization.

  ---

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

• Question 18:

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

  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

  ---

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

• Question 20:

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

  A. Delete vectors move deleted records to files in a new location.
  B. Delete vectors enable historical queries of data marked for deletion until the data has been purged.
  C. Delete vectors rewrite the original files, immediately purging them off the system.
  D. Delete vectors are stored in a different location, minimizing storage impact.
  E. Delete vectors are a fast method for marking records for deletion.
  B. Delete vectors enable historical queries of data marked for deletion until the data has been purged.
  E. Delete vectors are a fast method for marking records for deletion.

  ---

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