Exam ID HP2-N36
Exam type Web-Based online exam used in certifications
Exam duration 1 hour 30 minutes
Exam length 50 questions
Passing score 70%
Delivery languages English
Related Certifications
Supporting courses These recommended courses help you prepare for the exam:

Register for this Exam

You will need an HPE Learner ID and a Pearson VUE login and password.

No reference material is allowed at the testing site. This exam may contain beta test items for experimental purposes.

Exam description

This exam tests your skills on the Vertica platform.

Ideal candidate for this exam

This exam is for Vertica system administrators, database analysts, and application developers.
Prior to taking the exam, candidates are expected to complete the “Vertica Introduction” training (formerly titled “Vertica Boot Camp”) or equivalent self directed study, plus three to six months of production level experience with the Vertica platform.
Candidates should have one to three years Linux experience and experience with a scripting language such as Perl or Python. We suggest an extensive working knowledge of SQL plus three to four years of technical, hands on experience with a relational database. A solid understanding of relational database systems including theory, design, and structure is important.

Exam contents

This exam has 50 questions. Here are types of questions to expect:
  • Multiple choice (multiple responses)
  • Multiple choice (single response)

Advice to help you take this exam

HPE highly recommends the associated training.
HPE exams test whether you have the knowledge and skills required of IT professionals. Many exam questions present a scenario that outlines a particular environment or problem. Some questions include exhibits.
If a question asks for more than one answer, select all correct options. There is no partial credit.
If a question takes too much time, mark the item for review and return to it at the end of the exam.


This exam validates that you can:

Vertica Architecture

  • Identify key features of Vertica
  • Describe high availability capabilities and describe Vertica's transaction model
  • Differentiate between compression and encoding
  • Installation of Vertica


Projection Design

  • Identify characteristics and determine features of projections used in Vertica
  • Define RLE
  • Describe ORDER BY importance in projection design
  • Describe the purpose of projection segmentation
  • Understanding buddy projections
  • Determining segmentation and partitioning


Loading Data into Vertica

  • Identify benefits of loading data into WOS and directly into ROS
  • Define the actions of the moveout and mergeout tasks
  • Describe how mergeout purges data marked for deletion
  • Copying data directly to ROS
  • Identifying characteristics of data file directory
  • Understanding both WOS and ROS
  • Distinguishing between moveout and mergeout actions


Removing Data Permanently from Vertica and Advanced Projection Design

  • Describe the process used to mark records for deletion
  • Identify the advantages and disadvantages of using delete vectors to identify records marked for deletion
  • Identify the process for processing a large delete or update
  • Distinguish between deleting partitions and deleting records
  • Identify the advantages of a merge join versus a hash join
  • Identify the advantages of a group by pipe versus a group by hash
  • Describe the characteristics of a prejoin projection
  • Determine methods available to optimize a projection for delete processing


Cluster Management in Vertica

  • Identify the steps used to add nodes to an existing cluster
  • Describe the benefits of having identically sorted buddy projections
  • Identify the steps of online recovery of a failed node
  • Define local segmentation capability in Vertica
  • Distinguish between the items in a Vertica cluster


Backup/Restore and Resource Management in Vertica

  • Identify situations when a backup is recommended
  • Identify features of the Vertica file used for backup and restore
  • Define the Resource Manager's role in query processing
  • Describe the differences between maxconcurrency and plannedconcurrency
  • Using query profiles and resource pools


Monitoring and Troubleshooting Vertica

  • Define the use of Management Console in monitoring Vertica
  • Determine methods to troubleshoot spread
  • Describe how to disallow user connections, while preserving dbadmin connectivity
  • Defining, using and logging into Management Console
  • Administering a cluster using Management Console


Analytics and Performance Tuning

  • Understanding analytics syntax
  • Using Event Based Windows, Time Series, Event Series Join, and Pattern Matching
  • Using explain plans and query profiles
  • Improving query performance
  • Analyzing an explain plan

Learning resources that were developed before the Hewlett-Packard Company separation might contain some content and brand elements that have not been updated for Hewlett Packard Enterprise. Learning resources with the highest usage are updated.