Exam ID HP2-N45
Exam type Web-Based online exam used in certifications
Exam duration 1 hour 40 minutes
Exam length 60 questions
Passing score 68%
Delivery languages English
Related Certifications
Supporting courses These recommended courses help you prepare for the exam:
Additional study materials

Register for this Exam

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

During the exam, you can make specific comments about the exam and items. HP welcomes these comments as part of our continuous improvement process.

Exam description

This exam tests your skills on administering the Vertica Analytics Platform.

Who should take this exam?

This exam is for Vertica DBAs, partners, and HP employees concerned with Vertica platform advanced administrative tasks like analyzing, diagnosing, troubleshooting, tuning and optimizing Vertica performance. This exam is open only to those who take and pass a lab portion administered and scored by Vertica first.

Exam contents

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

Tips for taking this exam

HP strongly recommends a combination of training, thorough review of courseware and additional study references, and sufficient on the job experience prior to taking the exam.

Take the time to read the entire question and consider all of the options carefully before you answer. If the question indicates that it features an exhibit, study the exhibit and reread the question. Make sure to select the answer that correctly responds to the question that is asked — not simply an answer that includes some correct information. If the question asks for more than one answer, remember to select each correct answer. You will not receive partial credit for a partially correct answer.


This exam validates that you can successfully perform the following:


  • Follow standard procedures to resolve common issues.
  • Locate key information to resolve common issues.



  • Modify key settings to obtain optimal performance.
  • Specify important elements of an optimized database.
  • Create projections that are formatted for optimal performance.



  • Implement a secure Vertica environment.
  • Identify key factors to create a high availability environment.


Database Setup And Automatic Design

  • Create objects in a Vertica database that provide for optimal querying of data.
  • Use the Database Designer to optimize a Vertica database.


Loading and Removing Data

  • Identify factors that play a role in optimizing for the addition and removal of data from Vertica.


Resource Management

  • Identify factors that play a role in optimizing the usage of resources while running transactions in Vertica.