HP HP ExpertONE Certification HP2-N36 Questions & Answers

• Question 11:

  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

  Correct Answer: A

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

• Question 12:

  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.

  Correct Answer: BC

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

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

  Correct Answer: AE

• Question 14:

  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

  Correct Answer: D

• Question 15:

  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.

  Correct Answer: ABE

• Question 16:

  What is a difference between maxconcurrency and plannedconcurrency?

  A. Maxconcurrency is a hard limit to the number of queries running within a pool; plannedconcurrency is used to create a query budget.

  B. Maxconcurrency is used to create a query budget; plannedconcurrency is a hard limit to the number of queries running within a pool.

  C. Maxconcurrency is a hard limit to the number of queries running within a pool; plannedconcurrency limits the number of queries running on the cluster.

  D. Maxconcurrency limits the number of queries running on the cluster; plannedconcurrency is a hard limit to the number of queries running within a pool.

  Correct Answer: C

• Question 17:

  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.

  Correct Answer: AE

• Question 18:

  What is local segmentation capability in Vertica?

  A. Vertica automatically splits current segments in half to redistribute them to new nodes.

  B. Vertica automatically partitions the data, allowing partitions to be dropped and recreated on new nodes.

  C. Vertica automatically creates more segments than are currently needed, allowing some segments to be moved to new nodes as needed.

  D. Vertica automatically partitions the segmented data, allowing some partitions to be moved to new nodes as needed.

  Correct Answer: D

  Reference:http://vertica-forums.com/viewtopic.php?f=5andt=874

• Question 19:

  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.

  Correct Answer: BD

• Question 20:

  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

  Correct Answer: AE